hbm2ddl.auto

[Prem Khan]

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]

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

<property name="connection.url">jdbc:jtds:sqlserver://localhost</property>

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

[Prem Khan]

yeah i did that and it still is the same error

[Prem Khan]

Its not even echoing any DDL to the stdout
[ September 06, 2005: Message edited by: Shawn DeSarkar ]

[Prem Khan]

I am an idiot! My db user did not have create table rights !

Thanks for your time everyone.