Hi, I am currently developing a admin console for my project. For that I am required to create databases and tables in that databases. I am using JavaServerFaces with Hibernate to achieve the task. My problem is that I can't find a way to create databases using hibernate. As I have read, I can certainly create tables in the (already created) database using SchemaExport utility, but I didn't find any material to create database using hibernate. Please help!!! -Raj
Using SQLQuery objects you should be able to pass DDL statements through Hibernate to the database, or you can get the JDBC connection directly from your Session object, or just use straight JDBC.
You're right Raj, Hibernate just creates tables over an existing database. If you need to create the database too, you should think on a work around, may be call a stored procedure from your DBA, do it manually or something like that.
Hey, sticks and stones baby. And maybe a wee mention of my stuff:
a bit of art, as a gift, the permaculture playing cards