SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Trigger, UDR Server, and Language Manager
Messages (11000 through 11399)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
13-28
SQL 11239
Where method-name is the Java method name specified in the EXTERNAL NAME
clause of a CREATE PROCEDURE statement.
class-name is the Java class name specified in the EXTERNAL NAME clause of a
CREATE PROCEDURE statement.
Cause. During the execution of a CREATE PROCEDURE statement that includes a
DYNAMIC RESULT SETS clause that specifies a value greater than 0 (zero), an SPJ
method having one or more trailing result sets could not be found in the specified Java
class. The SPJ method must be named class-name.method-name and must have
a Java type signature that matches the declared SQL parameter types. If the
DYNAMIC RESULT SETS clause specifies a value greater than zero, the SPJ method
must also have one or more trailing java.sql.ResultSet[] parameters.
Effect. The operation fails.
Recovery. Ensure that the SPJ method exists in the specified class file, and resubmit.
SQL 11240
Where index is the ordinal position of the parameter specified in the EXTERNAL
NAME clause of a CREATE PROCEDURE statement.
Cause. The parameter at position index is not java.sql.ResultSet[].
Effect. The operation fails.
Recovery. Ensure that the specified signature trailing parameters are specified as
Java type java.sql.ResultSet[], and resubmit.
SQL 11241
Where procedure-name is the ANSI name of a stored procedure.
Where ver1 and ver2 are the SPJ RS interface version numbers of the JDBC/MX
driver.
11239 No compatible methods method-name were found in Java
class class-name.
11240 Specified signature is invalid. Reason: Parameter at
position index is not java.sql.ResultSet[].
11241 Stored procedure procedure-name attempted to return
result sets but the JDBC/MX driver in the SPJ environment has
an incompatible version of stored procedure result sets
interface. The JDBC/MX driver's interface version is ver2 and
the expected version is ver1 or lower.