Guys,
I am using JT400 API from IBM to connect to DB2 on AS400 machine. DataSources are created and bounded to JNDI fine. Both 2.4.8 and 3.2.X (X = 1 and/or 2) But When i execute updates to one of the table from 3.2.X it gives an error back says "row or object in "DB NAME " in "LIBRARY NAME" type *FILE in use" But the same code base runs fine in JBoss 2.4.8.
here is my DS confing..
<local-tx-datasource>
<jndi-name>jdbc/LSC</jndi-name>
<connection-url>jdbc:as400://server name/library name;user=userid;password=password</connection-url>
<driver-class>com.ibm.as400.access.AS400JDBCDriver</driver-class>
<connection-property name="char.encoding">UTF-8</connection-property>
<transaction-isolation>TRANSACTION_SERIALIZABLE</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>
never mind hashed it out. <transaction-isolation>TRANSACTION_SERIALIZABLE</transaction-isolation> this sucker was my problem.