File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/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: 32

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?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Unable to create schema
 
Similar Threads
Could not parse mapping document hbm.xml
Trying Out Hiberbate:Error "Cannot resolve the NoCacheProvider", when configuring hibernate.cfg.xml
Doubt in Hibernate Sample Application
"hibernate.hbm2ddl.auto">create - to generate DB Tables
Really strange error: Could not initialize class net.sf.hibernate.impl.SessionFactoryImpl