In this blog post, let’s learn about the error message “11220 A Java method completed with an uncaught java.sql.SQLException with invalid SQLSTATE. The uncaught exception had a SQLCODE of SQLCODE-value and SQLSTATE of SQLSTATE-value. Details: string.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
11220 A Java method completed with an uncaught java.sql.SQLException with invalid SQLSTATE. The uncaught exception had a SQLCODE of SQLCODE-value and SQLSTATE of SQLSTATE-value. Details: string.
Reason for the Error
During execution of a CALL statement, an SQL error occurred and a Java exception was thrown.
Solution
Review the Java method. Determine whether it is appropriate in your application for this exception to be thrown or whether it should be caught and handled by your user-defined routine. Retry the SQL/MX statement