Schema export truncates table

barnti · **Joined:** Mon May 22, 2006 8:32 am **Posts:** 67

Hi there,

i am still working on a strage problem which i don't understand:

Code:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
      "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
      "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <property name="hibernate.connection.driver_class">com.microsoft.jdbc.sqlserver.SQLServerDriver</property>
        <property name="hibernate.connection.password">password</property>
        <property name="hibernate.connection.url">jdbc:microsoft:sqlserver://10.148.7.203;DatabaseName=Reporting;SelectMethod=cursor</property>
        <property name="hibernate.connection.username">user</property>
        <property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>
    </session-factory>
</hibernate-configuration>

When i run schema export on my hibernate configuration all data from the used tabes is gone...! Is this a feature? How to avoid this? I thought i have to use the property

Code:

<property name="hbm2ddl.auto">delete</property>

to achieve this?!

What happened? Can i turn this deletion off?

Thanks for advice,

regards,

a.k.

max · **Posted:** Mon Jun 19, 2006 9:59 am

eh ? schemaexport means *export* the schema to the db ...and that means "put this schema in effect on the db" and no, it does not maintain existing data/tables.

Take a look at schemaupdate for this (but note these two tools is not intended for usage against a production db)

barnti · **Joined:** Mon May 22, 2006 8:32 am **Posts:** 67

Hi Max,

max wrote:

eh ? schemaexport means *export* the schema to the db ...and that means "put this schema in effect on the db" and no, it does not maintain existing data/tables.

Take a look at schemaupdate for this (but note these two tools is not intended for usage against a production db)

Sorry for this misunderstanding.
Ok, so the export did the truncation on my tables not the reverse engeneering process. That is what i wanted to know.

Thank a lot, regards,

a.k.