Unable to create schema

[sarada bokka]

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]

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]

This doesn't help me.

It help me to create tables automatically but not the schema.

[Ganesh Shirsat]

hi,

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

what is exactly means of schema.?

[sarada bokka]

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

<property name="connection.url">jdbc:mysql://localhost:3306/[b]tricky[/b]</property> 

[sarada bokka]

Does hibernate has this support?