|
Problem IT41535
|
Status: Closed |
JDBC THROWS -79716 SYSTEM OR INTERNAL ERROR WHEN CALLING A STORED PROCEDURE THAT USES RAISE EXCEPTION
|
| product: |
IBM CSDK / 5724C2381 / 450 - CSDK 4.50 |
| Problem description: |
When calling a stored procedure that raises and exception, a
-79716 System or internal error exception is thrown.
With Informix JDBC version 4.10.JC10, the proper exception is
returned.
$ cat spl_java.sql
CREATE PROCEDURE sp_raiseException(ai_exception INT);
RAISE EXCEPTION ai_exception, 0, "Exception handling test
procedure of " || ai_exception;
END PROCEDURE;
$ java test
Driver version=4.10.JC10
-20000
java.sql.SQLException: Exception handling test procedure of
-20000
java.sql.SQLException: Exception handling test procedure of
-20000
at
com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3190)
at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3474)
at
com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2381)
at
com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2306)
at
com.informix.jdbc.IfxSqli.sendStatementExecute(IfxSqli.java:1360
)
at
com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2234)
at
com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2187)
at
com.informix.jdbc.IfxResultSet.executeExecute(IfxResultSet.java:
372)
at
com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:114
2)
at
com.informix.jdbc.IfxPreparedStatement.execute(IfxPreparedStatem
ent.java:421)
at
com.informix.jdbc.IfxCallableStatement.execute(IfxCallableStatem
ent.java:315)
at test.main(test.java:34)
Caused by: java.sql.SQLException
at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:480)
at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:449)
at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:400)
at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3479)
... 10 more
$ java test
Driver version=4.10.JC15
-79716
java.sql.SQLException: System or internal error
java.sql.SQLException: System or internal error
at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:445)
at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:417)
at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:385)
at
com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3136)
at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3458)
at
com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2324)
at
com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2249)
at
com.informix.jdbc.IfxSqli.sendStatementExecute(IfxSqli.java:1331
)
at
com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2177)
at
com.informix.jdbc.IfxResultSet.executeExecute(IfxResultSet.java:
307)
at
com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:111
5)
at
com.informix.jdbc.IfxPreparedStatement.execute(IfxPreparedStatem
ent.java:421)
at
com.informix.jdbc.IfxCallableStatement.execute(IfxCallableStatem
ent.java:315)
at test.main(test.java:34)
$ java test
Driver version=4.50.JC8
-79716
java.sql.SQLException: System or internal error
java.sql.SQLException: System or internal error
at
com.informix.util.IfxErrMsg.buildException(IfxErrMsg.java:445)
at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:417)
at
com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:385)
at
com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3136)
at
com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3458)
at
com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2324)
at
com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2249)
at
com.informix.jdbc.IfxSqli.sendStatementExecute(IfxSqli.java:1331
)
at
com.informix.jdbc.IfxSqli.executeExecute(IfxSqli.java:2177)
at
com.informix.jdbc.IfxResultSet.executeExecute(IfxResultSet.java:
307)
at
com.informix.jdbc.IfxStatement.executeImpl(IfxStatement.java:111
5)
at
com.informix.jdbc.IfxPreparedStatement.execute(IfxPreparedStatem
ent.java:421)
at
com.informix.jdbc.IfxCallableStatement.execute(IfxCallableStatem
ent.java:315)
at test.main(test.java:34) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix JDBC prior to 4.50.JC9. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix JDBC 4.50.JC9. *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix JDBC prior to 4.50.JC9. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix JDBC 4.50.JC9. *
**************************************************************** |
| Comment |
Fixed in Informix JDBC 4.50.JC9. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 15.07.2022
05.10.2022
05.10.2022 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
