Hello,

i have to adapt a MS Access database in a spring application with hibernate. Reading from and writing to the database works. But when i stop tomcat the newly written records are delted. Seems like a transaction gets rolled back. What can i do?

Here is my hibernate configuration:

<bean id="hibernateSessionFactoryMSAccess"
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

<property name="mappingResources">
<list>
<value>de/kraemerit/msl/repository/Article.hbm.xml</value>
<value>de/kraemerit/msl/repository/Customer.hbm.xml</value>
<value>de/kraemerit/msl/repository/Order.hbm.xml</value>
<value>de/kraemerit/msl/repository/OrderPosition.hbm.xml</value>
<value>de/kraemerit/msl/repository/TestDomain.hbm.xml</value>
</list>
</property>

<!-- <property name="dataSource" ref="dataSourceMySQL" /> -->
<property name="hibernateProperties">
<props>

<prop key="hiberante.show_sql">true</prop>

<prop key="hibernate.connection.username" />
<prop key="hibernate.connection.password" />
<prop key="hibernate.dialect">com.hxtt.support.hibernate.HxttAccessDialect</prop>
<prop key="hibernate.connection.url">jdbc:access:///d:/database.mdb?delayedClose=0</prop>
<prop key="hibernate.connection.driver_class">com.hxtt.sql.access.AccessDriver</prop>

<!-- <prop key="hibernate.show_sql">false</prop> -->
<prop key="hibernate.format_sql">false</prop>
<prop key="hibernate.use_sql_comments">false</prop>
<prop key="hibernate.hbm2ddl.auto">update</prop>

</props>
</property>
</bean>

Hi Friend,

Can you please provide your java file snippets

looks like you're not committing the transaction