using hibernate sql generator only

hendrik · **Joined:** Wed Mar 17, 2004 7:10 am **Posts:** 1

Hi,

I'm quite new to Hibernate, but think that it's mostly for mapping an Java object graph to SQL. This is very interesting. However not quite what I want to use it for (at this stage).

What I want to know is if it would be possible to use the HQL for generating SQL for different RDBMSs? Our 'problem' is that we need to execute queries on tables that are dynamic, i.e. we will not know the exact table design up front, so we will not be able to generate a Hibernate mapping up front (before starting the application). Because we need to support multiple RDMSs it would be nice if we could constuct a HQL query and have Hibernate spit out the SQL (for the concrete RDBMS). Is it possible to (mis)use Hibernate for this purpose?

I have read through (a lot of) the documentation, but could not find any information on this.

Thanks in advance for your input,

Hendrik

emmanuel · **Posted:** Wed Mar 17, 2004 11:17 am

It should be possible (it's OS) but you'll touch internal APIs
Did you read that one http://www.hibernate.org/171.html

emmanuel · **Posted:** Wed Mar 17, 2004 11:27 am

And rewrite big parts

anand_h · **Joined:** Wed Feb 11, 2004 10:07 am **Posts:** 2

Hendrik,

I am surprised as well, there seems to be no way of trapping the plain SQL gracefully. It sounds weird that Gavin has given way to print it out to console, but not be able to retreive it through an API.

Strange indeed. Still looking for a way to do that.

-Anand

baliukas · **Posted:** Wed Mar 17, 2004 1:54 pm

hendrik wrote:

Is it possible to (mis)use Hibernate for this purpose?

Yes, it is.

emmanuel · **Posted:** Fri Mar 19, 2004 5:45 am

Actually doing that in the JDBC layer (with a JDBC wrapper) is far better I think. You'll get *every* DB access.