Creating new database using hibernate

niravpurohit · **Joined:** Tue Oct 09, 2007 1:02 am **Posts:** 5

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!!!
-Nirav

khangharoth · **Joined:** Fri Aug 31, 2007 11:58 am **Posts:** 19

What do you mean by can't find a way to create databases using hibernate.
you have Hibernate tools jar which you can say invoke from your ant task for the Schema Export.
This essentially mean you have Java Classes and Mapping done and want Hibernate to create database according to your mapping meta data.

niravpurohit · **Joined:** Tue Oct 09, 2007 1:02 am **Posts:** 5

My MS SQL Server has no user-created databases .i.e newly installed. I tried creating tables using SchemaExport. But it gives error as the database in which tables are required to be created doesn't exists. Also it doesn't creates that database on its own.

nehagp · **Joined:** Fri Oct 12, 2007 2:58 am **Posts:** 3

Any answers to this? I am stuck up on the same issue.

khangharoth · **Joined:** Fri Aug 31, 2007 11:58 am **Posts:** 19

Generally we just create tables or to say Schema from Hibernate SchemaExport and not the Database.
You should get some "Cannot open connection" as hibernate does not know where to connect to.

Not Sure as how to create database instance from hibernate but this is not a common practise.

Anyway just create a DB instance and then everything should be fine. No need to remain Stuck on this!

khangharoth · **Joined:** Fri Aug 31, 2007 11:58 am **Posts:** 19

Generally we just create tables or to say Schema from Hibernate SchemaExport and not the Database.
You should get some "Cannot open connection" as hibernate does not know where to connect to.

Not Sure as how to create database instance from hibernate but this is not a common practise.

Anyway just create a DB instance and then everything should be fine. No need to remain Stuck on this!

niravpurohit · **Joined:** Tue Oct 09, 2007 1:02 am **Posts:** 5

I have got a solution to it!!!
Get the Connection object from hibernate session object through following code:

Connection con = session.connection();

and u r done :-) Now u can create a Statement object as in JDBC from Connection object and execute that statement. U can execute any DDL query using this statement object.