I'm using the method createSqlQuery which permits to execute SQL.
And I'd like to use the function COUNT in my sql query but I don't know how to to this.

Here is how I do :

createSqlQuery("SELECT count({p.id}) FROM MY_TABLE",
new String[] { "p" },
new Class[] { HbMyTable.class });


I also tried
createSqlQuery("SELECT count(x.ID as {p.id}) FROM MY_TABLE x",
new String[] { "p" },
new Class[] { HbMyTable.class });

Is it possible to use COUNT in createSqlQuery ?
Because I really need to do this in order to win time.


Thank you for your help ! :)

Nicolas

Any idea ?

You cant. Just use session.connection() and use plain old JDBC

Ok thx !