-
1. Re: SalesRep updates but not inserts (BMP)
atorres May 13, 2002 2:38 PM (in response to atorres)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?