1 Reply Latest reply on May 13, 2002 2:38 PM by Alexandre Torres

    SalesRep updates but not inserts (BMP)

    Alexandre Torres Newbie

      Hi!
      I ported the Sun J2EE example "salesrep" to the JBoss enviroment and MS-SQLSERVER database. After some changes on the naming and xml, the example worked fine for selects and updates. But the insert was not working. I can´t figure out why. The Insert command is executed, so, by some strange power beyond my own, the "insert transaction" was not commited. But the update is executed.
      I´m using autocommit=false.
      I will try it with other database and post if it worked.

        • 1. Re: SalesRep updates but not inserts (BMP)
          Alexandre Torres Newbie

          With HSQL it works when I close the connection only in the unsetContext of the component (or when I don´t close it at all). If I change the code to close the connection after each operation (releasing it to the Pool) it doesn´t work. That´s obscure for me, but it works at least.
          But on MS-SQLServer I can´t make it work at all. The update works, the insert is never commited and the table becames locked until I close JBoss.
          My transaction isolation is READ_UNCOMMITED. The default trans. isol hangs JBoss. Here is the jcml conf:


          org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl
          DefaultDS
          jdbc:microsoft:sqlserver://apyondb:1433;SelectMethod=cursor;user=sa;password=trust2001
          DataBaseName=sales


          1200000
          1000
          false
          false
          false
          true
          120000
          1800000
          false
          false
          1.0
          0
          TRANSACTION_READ_UNCOMMITTED


          What I´m doing wrong?