Home » Developer & Programmer » JDeveloper, Java & XML » java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow
java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow [message #91606] |
Fri, 06 December 2002 14:31 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Doug Campbell
Messages: 2 Registered: December 2002
|
Junior Member |
|
|
Environment is Oracle9.2/W2K with oracle9 jdbc drivers.
Executing preparedStatment.setCharacterStream(int i, Reader, int length) throws this stackTrace
---- code
stmt.setCharacterStream(1, reader, data.length());
stmt.setDate(2, date); // recd time
stmt.setInt(3, INBOUND);
stmt.setNull(4, Types.CLOB);
stmt.setCharacterStream(4, reader2, reply.length);
stmt.setInt(5, NEW_STAT); // process stat
stmt.setInt(6, 0); // RETRY COUNT
stmt.setInt(7, RETRY_MAX); // retry max
-- end code
java.sql.SQLException: ORA-03120: two-task conversion routine: integer overflow
[[13:03:00,864,Default]] at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
[[13:03:00,864,Default]]
[[13:03:00,864,Default]] at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
[[13:03:00,864,Default]]
[[13:03:00,864,Default]] at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
[[13:03:00,864,Default]]
[[13:03:00,864,Default]] at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
[[13:03:00,864,Default]]
[[13:03:00,864,Default]] at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
[[13:03:00,874,Default]]
[[13:03:00,874,Default]] at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
[[13:03:00,874,Default]]
[[13:03:00,874,Default]] at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
[[13:03:00,874,Default]]
[[13:03:00,874,Default]] at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
[[13:03:00,874,Default]]
[[13:03:00,874,Default]] at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
[[13:03:00,874,Default]]
[[13:03:00,874,Default]] at org.jboss.pool.jdbc.PreparedStatementInPool.executeUpdate(Unknown Source)
Anybody come up against this?
The column type is long which the character stream is being set on
|
|
|
|
|
|
Goto Forum:
Current Time: Mon Sep 09 09:16:33 CDT 2024
|