aspose file tools*
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
Author

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"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<session-factory>

<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"/>
</session-factory>
</hibernate-configuration>
Pradeep Kumar
Ranch Hand

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

<property name="hibernate.hbm2ddl.auto">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="hibernate.hbm2ddl.auto">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

hi,

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
Hi,

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?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Unable to create schema