Hey,

Is it possible to generate SQL code using Hibernate without modifying the database? I know I can capture the SQL code with a logger but I want Hibernate to generate a bunch of SQL insert statements without needing the database installed.

The reason I want to do this is so I can generate the SQL on a different machine to the database (I don't currently have access to the computer running the database).

All the mapping files have been set up and work correctly.

Any help would be appreciated.


Kind Regards,


Jack Nickle

You are not talking about create table and co (the Schema Export tool would help with those) but you are talking about insert, update and delete, right?

You could write your own jdbc driver that just logs the statements and returns some dummy values.

you could use a realy simple local database so that hibernate has the database as normal and simply log the statements. This should be way easier and more stable. But it doesn't fit your initial riquirements.

I'm not sure but I've seen this method on Eclipse.I haven't tried but it might be useful:

I think I will try this. :)



True I thought about doing this it just seems such a pain. I was hoping that Hibernate would provide an easy way. E.g. A fake mode where it would generate the insert statements etc without needing a database.

Have you tried using HSQLDB (http://hsqldb.org/)? It is a pure Java database engine that can be run in-process and with all tables in memory. Very useful for testing since everything goes away at the end of the test program. Don't forget to put the following line in your hibernate.properties file.