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

    transaction support with sap/hibernate/jboss : error in prev

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