Hello,

Is there a way for me to turn a criteria to any one of these formats:
* hibernate hql.
* hibernate org.hibernate.Query
* sql

Any one of these would do...

I want to use of the formats above and change the query then submit it to the db.

For example I'd like to do something like this

String sql = "SELECT COUNT(*) FROM (" + transformCriteria(myCriteria) + ")"

Thanks

Not clear with ur question. Can you please elaborate.

As far as I am aware there is no way to do what you want. I know there is no way to convert criteria to HQL and vice versa. A co-worker of mine and I had a lengthy discussion about how convenient that would be. It might be possible with SQL, but as I said, I don't think so.

Sure, let me clarify:
I'm constructing a complicated criteria, and I'd like to convert it to a sql or hql string.

Then I'd like to manipulate the string and submit the query to the db for execution.

Schevus - is there a way to turn it to sql? sounds like you're saying no way to turn it to hql.

Thanks again!

I'm not seeing any provided API that allows you to change it to SQL. You can put SQL into criteria, but it doesn't look like you can get SQL out of criteria (without writing your own code to do so obviously). Good luck!