Java Database Connectivity (JDBC)

Greetings!

i have WLS8 SP5 with two connection pool in the domain both are having XA thin drivers(oracle.jdbc.xa.client.OracleXADataSource).

Also for both datasources honor global transaction is enabled and 2PC also are true.

but so many times, i m getting the SQL exception.
here are the loggers for that,
1)
DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
registerDriver: driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDriver@546169]
SQLException: SQLState(null) vendor code(17026)
java.sql.SQLException: Numeric Overflow
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)


2)
DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
registerDriver: driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDriver@52c6f]
SQLException: SQLState(42000) vendor code(904)
java.sql.SQLException: ORA-00904: invalid column name

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)

3)
DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
registerDriver: driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDriver@546169]
SQLException: SQLState(65000) vendor code(6550)
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'SYS.DBMS_SYSTEM' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
at oracle.jdbc.driver.T4CStatement.execute_for_rows(T4CStatement.java:561)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1081)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1548)
at oracle.jdbc.xa.OracleXAResource.recover(OracleXAResource.java:503)
at weblogic.jdbc.wrapper.VendorXAResource.recover(VendorXAResource.java:82)
at weblogic.jdbc.jta.DataSource.recover(DataSource.java:1241)
at weblogic.transaction.internal.XAServerResourceInfo.recover(XAServerResourceInfo.java:897)
at weblogic.transaction.internal.ServerSCInfo.recover(ServerSCInfo.java:515)
at weblogic.transaction.internal.XAResourceDescriptor.getXidsToBeRolledBack(XAResourceDescriptor.java:1310)
at weblogic.transaction.internal.XAResourceDescriptor.recover(XAResourceDescriptor.java:1247)
at weblogic.transaction.internal.XAResourceDescriptor.access$100(XAResourceDescriptor.java:57)
at weblogic.transaction.internal.XAResourceDescriptor$1.execute(XAResourceDescriptor.java:957)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)
SQLException: SQLState(null) vendor code(17026)
java.sql.SQLException: Numeric Overflow
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:162)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:227)
at oracle.jdbc.driver.NumberCommonAccessor.throwOverflow(NumberCommonAccessor.java:6797)

4)
DriverManager.initialize: jdbc.drivers = null
JDBC DriverManager initialized
registerDriver: driver[className=oracle.jdbc.driver.OracleDriver,oracle.jdbc.driver.OracleDriver@1c737be]
SQLException: SQLState(65000) vendor code(6550)
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00201: identifier 'SYS.DBMS_SYSTEM' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)

these exception especially comes when i m trying to get object from state by findbyprimarykey(key).

is there any leak in the drivers.
please help me in this.

Regards,
Ashish