aspose file tools*
The moose likes Object Relational Mapping and the fly likes hbm2ddl.auto Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "hbm2ddl.auto" Watch "hbm2ddl.auto" New topic
Author

hbm2ddl.auto

Prem Khan
Ranch Hand

Joined: May 30, 2005
Posts: 189
Please let me know if i am doing something wrong. My SQL server tables are not being created. And I get an Exception table dont exist.


<hibernate-configuration>

<session-factory>

<!-- Database connection settings -->
<property name="connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>
<property name="connection.url">jdbc:jtds:sqlserver://localhost</property>
<property name="connection.username">sks</property>
<property name="connection.password">sks</property>

<!-- JDBC connection pool (use the built-in) -->
<property name="connection.pool_size">1</property>

<!-- SQL dialect -->
<property name="dialect">org.hibernate.dialect.SQLServerDialect</property>

<!-- Echo all executed SQL to stdout -->
<property name="show_sql">true</property>

<!-- Drop and re-create the database schema on startup -->
<property name="hbm2ddl.auto">create</property>

<mapping resource="sks/datamodel/InventoryItem.xml"/>

</session-factory>

</hibernate-configuration>
[ September 06, 2005: Message edited by: Shawn DeSarkar ]
Pierre Sugar
Ranch Hand

Joined: Dec 08, 2002
Posts: 62

Are you sure you have your database directly under localhost situated like stated in



I asume it should be something like ...//localhost/sks where sks is your database.


Pierre
Prem Khan
Ranch Hand

Joined: May 30, 2005
Posts: 189
yeah i did that and it still is the same error
Prem Khan
Ranch Hand

Joined: May 30, 2005
Posts: 189
Its not even echoing any DDL to the stdout
[ September 06, 2005: Message edited by: Shawn DeSarkar ]
Prem Khan
Ranch Hand

Joined: May 30, 2005
Posts: 189
I am an idiot! My db user did not have create table rights !

Thanks for your time everyone.
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: hbm2ddl.auto
 
Similar Threads
Cannot connect to MySQL server ...
Hibernate App Issue
Hibernate Without Transactions
hibernate with struts
using multiple datasources in hibernate app