Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Unable to create schema

 
sarada bokka
Ranch Hand
Posts: 80
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


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
Posts: 109
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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>

 
sarada bokka
Ranch Hand
Posts: 80
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This doesn't help me.

It help me to create tables automatically but not the schema.
 
Ganesh Shirsat
Ranch Hand
Posts: 33
Google Web Toolkit Java Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,

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

what is exactly means of schema.?

 
sarada bokka
Ranch Hand
Posts: 80
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 80
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does hibernate has this support?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic