[ https://issues.apache.org/jira/browse/TRAFODION-533?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jian Jin updated TRAFODION-533: ------------------------------- Assignee: Kevin Xu (was: Jian Jin) > LP Bug: 1355042 - SPJ w result set failed with ERROR[11220], SQLCODE of > -29261, SQLSTATE of HY000 > ------------------------------------------------------------------------------------------------- > > Key: TRAFODION-533 > URL: https://issues.apache.org/jira/browse/TRAFODION-533 > Project: Apache Trafodion > Issue Type: Bug > Components: sql-exe > Reporter: Chong Hsu > Assignee: Kevin Xu > Priority: Critical > Fix For: 2.0-incubating > > > Tested with Trafodion build, 20140801-0830. > Calling a SPJ that calls another SPJ with result set: > public static void RS363() > throws Exception > { > String str = "jdbc:default:connection"; > > Connection localConnection = DriverManager.getConnection(str); > Statement localStatement = localConnection.createStatement(); > > CallableStatement localCallableStatement = > localConnection.prepareCall("{call RS200()}"); > localCallableStatement.execute(); > } > public static void RS200(ResultSet[] paramArrayOfResultSet) > throws Exception > { > String str1 = "jdbc:default:connection"; > > String str2 = "select * from t1"; > Connection localConnection = DriverManager.getConnection(str1); > Statement localStatement = localConnection.createStatement(); > paramArrayOfResultSet[0] = localStatement.executeQuery(str2); > } > it failed with ERROR: > *** ERROR[11220] A Java method completed with an uncaught > java.sql.SQLException with invalid SQLSTATE. The uncaught exception had a > SQLCODE of -29261 and SQLSTATE of HY000. Details: java.sql.SQLException: No > error message in SQL/MX diagnostics area, but sqlcode is non-zero [2014-08-04 > 22:57:28] > The SPJ Jar file is attached. Here are the steps to produce the error: > > set schema testspj; > create library spjrs file '/<Jar location>/Testrs.jar'; > create procedure RS363() > language java > parameter style java > external name 'Testrs.RS363' > dynamic result sets 0 > library spjrs; > --- SQL operation complete. > create procedure RS200() > language java > parameter style java > external name 'Testrs.RS200' > dynamic result sets 1 > library spjrs; > create table T1 > ( > A INT DEFAULT NULL > , B INT DEFAULT NULL > ) no partitions; > Call RS363(); > *** ERROR[11220] A Java method completed with an uncaught > java.sql.SQLException with invalid SQLSTATE. The uncaught exception had a > SQLCODE of -29261 and SQLSTATE of HY000. Details: java.sql.SQLException: No > error message in SQL/MX diagnostics area, but sqlcode is non-zero [2014-08-04 > 22:57:28] -- This message was sent by Atlassian JIRA (v6.3.4#6332)