[ 
https://issues.apache.org/jira/browse/TRAFODION-533?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Suresh Subbiah updated TRAFODION-533:
-------------------------------------
    Fix Version/s:     (was: 2.2.0)
                   2.3

> 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.3
>
>
> 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
(v7.6.3#76005)

Reply via email to