Dynamic Hibernate Query

Question

I have a method that I use to return a dynamic query. This method is shown below


public Query getLastId(String sProvider)
{
       String serviceProvider = sProvider.toLowerCase();     
       String query2 = "SELECT MAX(:serviceProvider.id) " + 
                   " FROM :sProvider :serviceProvider ";

       return em.createQuery(query2)
              .setParameter("sProvider", sProvider)
              .setParameter("serviceProvider", serviceProvider);

}

I want this method to return this

SELECT MAX(multichoice.id) FROM Multichoice multichoice

when I call the method like this

getLastId("Multichoice");

Please how do I write the query variable to return the answer?

Beatles1692 · Accepted Answer · 2011-04-30 12:52:52Z

1

To do this task you can use Criteria object model and projections to run your query over different types: Take a look at this article (15.7. Projections, aggregation and grouping)

here is the code :

List results = session.createCriteria(class)
.setProjection( Projections.max("id"))
.list();

Then instead of a string you should send a class to your method.

edited Apr 30, 2011 at 12:52

answered Apr 30, 2011 at 12:45

Beatles1692

5,35040 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Dynamic Hibernate Query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related