File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Object Relational Mapping and the fly likes Unable to create schema Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Unable to create schema" Watch "Unable to create schema" New topic

Unable to create schema

sarada bokka
Ranch Hand

Joined: Jan 13, 2010
Posts: 80

Hi all,

i am using mysql as database .If i try to run my program it is not able to create tricky schema.

i need to create the schema manually . is there any solution to create schema automaticallyy like tables???

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"


<property name="connection.characterEncoding">UTF-8</property>
<property name="connection.driver_class">com.mysql.jdbc.Driver</property>
<property name="connection.url">jdbc:mysql://localhost:3306/tricky</property>
<property name="connection.username">root</property>
<property name="connection.password">admin</property>

<property name="dialect">org.hibernate.dialect.MySQLDialect</property>
<!-- <property name="current_session_context_class">thread</property> -->
<mapping resource="com/tricky/vo/User.hbm.xml"/>
Pradeep Kumar
Ranch Hand

Joined: Sep 08, 2006
Posts: 108
Yes. Include the following property in the hibernate.cfg.xml file.

<property name="">create</property>

Once the schema is created you can change this property to update as below to avoid overriting the schema every time.

<property name="">update</property>

Thanks and Regards, Pradeep Kumar
SCJP 1.6, SCWCD 5.0
sarada bokka
Ranch Hand

Joined: Jan 13, 2010
Posts: 80
This doesn't help me.

It help me to create tables automatically but not the schema.
Ganesh Shirsat
Ranch Hand

Joined: Jan 10, 2010
Posts: 33


pradip kumar has given you the right way to create table .

what is exactly means of schema.?

sarada bokka
Ranch Hand

Joined: Jan 13, 2010
Posts: 80

schema is where it contains group of tables,views

in the below code tricky is the schema

if i have not mentioned tricky below ,all the tables will be created under MySQL directly

sarada bokka
Ranch Hand

Joined: Jan 13, 2010
Posts: 80
Does hibernate has this support?
I agree. Here's the link:
subject: Unable to create schema
It's not a secret anymore!