hi

im using sapdb with hibernate mapping on an Session stateless EJB

when im trying to save an object who contains some objects, the query crash after 5 sql insert : this is my own business
but normally, all sql query may be roolbacked
they dont !!!

i dont understand




ejb-jar.xml :

<container-transaction>

<ejb-name>ElementManager</ejb-name>
<method-name>*</method-name>

<trans-attribute>Required</trans-attribute>
</container-transaction>


hibernate-service.xml :


<!--jboss.jca:service=RARDeployer-->
jboss.jca:service=LocalTxCM,name=MYDBDS
<!-- Make it deploy ONLY after DataSource had been started -->
hibernate.mapping.xml
java:/hibernate/HibernateFactory
java:/MYDBDS
net.sf.hibernate.dialect.SAPDBDialect
net.sf.hibernate.transaction.JTATransactionFactory
net.sf.hibernate.transaction.JBossTransactionManagerLookup
true
false
java:/UserTransaction



sap-ds.xml :

<local-tx-datasource>

<jndi-name>MYDBDS</jndi-name>
<connection-url>jdbc:sapdb://host/database</connection-url>
<driver-class>com.sap.dbtech.jdbc.DriverSapDB</driver-class>
<user-name>my</user-name>
my
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>

<min-pool-size>5</min-pool-size>
<max-pool-size>100</max-pool-size>
<blocking-timeout-millis>5000</blocking-timeout-millis>
<idle-timeout-minutes>15</idle-timeout-minutes>

</local-tx-datasource>