Informix - Problem description
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) |