1 Reply Latest reply on Aug 15, 2003 12:45 PM by tatvamasi12

    AS400 Connection problem in 3.2.X

    tatvamasi12 Newbie

      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>