[
https://issues.apache.org/jira/browse/TRAFODION-533?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Selvaganesan Govindarajan updated TRAFODION-533:
------------------------------------------------
Fix Version/s: (was: 2.3)
2.4
> 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.4
>
>
> 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
(v8.3.4#803005)
