This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
The moose likes Object Relational Mapping and the fly likes Hibernate: Creating new database using hibernate Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate: Creating new database using hibernate" Watch "Hibernate: Creating new database using hibernate" New topic

Hibernate: Creating new database using hibernate

Raj Purohit

Joined: Sep 26, 2007
Posts: 10
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!!!
Mark Spritzler

Joined: Feb 05, 2001
Posts: 17271

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.


Perfect World Programming, LLC - Two Laptop Bag - Tube Organizer
How to Ask Questions the Smart Way FAQ
Angel J Gama
Ranch Hand

Joined: Jun 28, 2007
Posts: 36
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.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: Hibernate: Creating new database using hibernate
It's not a secret anymore!