You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Anuradha Hegde (JIRA)" <ji...@apache.org> on 2016/05/12 20:09:12 UTC
[jira] [Updated] (TRAFODION-533) LP Bug: 1355042 - SPJ w result set
failed with ERROR[11220], SQLCODE of -29261, SQLSTATE of HY000
[ https://issues.apache.org/jira/browse/TRAFODION-533?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Anuradha Hegde updated TRAFODION-533:
-------------------------------------
Fix Version/s: (was: 2.0-incubating)
2.1-incubating
> 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.1-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)