SPJ w result set failed with ERROR[11220], SQLCODE of -29261, SQLSTATE of HY000
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Trafodion |
New
|
High
|
Weiqing Xu |
Bug Description
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 localConnection = DriverManager.
Statement localStatement = localConnection
CallableSt
localCalla
}
public static void RS200(ResultSet[] paramArrayOfRes
throws Exception
{
String str1 = "jdbc:default:
String str2 = "select * from t1";
Connection localConnection = DriverManager.
Statement localStatement = localConnection
paramArray
}
it failed with ERROR:
*** ERROR[11220] A Java method completed with an uncaught java.sql.
The SPJ Jar file is attached. Here are the steps to produce the error:
set schema testspj;
create library spjrs file '/<Jar location>
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.
Changed in trafodion: | |
assignee: | nobody → Pavani Puppala (pavani-puppala) |
Changed in trafodion: | |
assignee: | Pavani Puppala (pavani-puppala) → Justin Du (justin-du-2) |
Changed in trafodion: | |
milestone: | none → r1.1 |
Changed in trafodion: | |
milestone: | r1.1 → r1.2 |
Changed in trafodion: | |
assignee: | Justin Du (justin-du-2) → Weiqing Xu (wei-qing-xu) |
importance: | Medium → High |
The problem happens with stored procedure calling another. We noticed that the procedure RS200 used result sets.
Can you try a test that the inner one without the result sets?