java.sql.sqlrecover,java.sql.SQLException: Numeric Overflow — oracle-tech

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,[email protected]]

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,[email protected]]

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,[email protected]]

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,[email protected]]

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