0 Replies Latest reply on Nov 12, 2003 10:47 AM by arnaudb35

    transaction support with sap/hibernate

    arnaudb35 Newbie

      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=FNACDBDS
      <!-- 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>