间歇性JDBC错误二任务转换例程

Question

我的 oracle 数据库（在远程 Linux 机器中）间歇性地收到以下 jdbc 错误

java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow

大部分中断的查询（不是唯一的！）看起来像这样，请注意，我正在使用 Groovy Sql

String insertScript =
"""
INSERT INTO data_table (invoke_id , trans_type , trans_from ,  
trans_to , serv_type ,msg_type , man_id , recip_id ,  
trx_id , part_id , msg_orig_time , create_time ,  
action_code , num_ranges , use_trx_id, due_date,owner,route,lsa, 
cl_id,hl_id,requ_type,lnp_type,use_invoke_id) 
VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
"""

def params = [invokeId,transType,transFrom,transTo,servType,msgType,man,recip,portId,owner,
now,now,"W",1,trxId,dueDate,owner," ", "LSA","CCH"," ","Basic","lspp",invokeId]

sql.execute insertScript, params

我不明白的是为什么我的查询有时工作，有时不工作。一般来说，它会在第一次运行期间发生，并且很少在后续运行中出现。

[更新] 当 spring 尝试加载其上下文时，我有时也会在应用程序启动时遇到此错误。我使用 spring 和 dbcp 进行连接池。

Caused by: org.apache.commons.dbcp.SQLNestedException: Error preloading the connection pool
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1238)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
... 46 more

引起原因：java.sql.SQLException：ORA-03120：两任务转换例程：整数溢出

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:406)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:799)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:368)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:508)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:203)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:33)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:510)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:294)
at org.apache.commons.pool.impl.GenericObjectPool.addObject(GenericObjectPool.java:1059)
at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1235)
... 49 more