[jira] [Created] (TRAFODION-532) LP Bug: 1355038 - SPJ w result set failed with ERROR[8841]

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-532:
------------------------------------

             Summary: LP Bug: 1355038 - SPJ w result set failed with ERROR[8841]
                 Key: TRAFODION-532
                 URL: https://issues.apache.org/jira/browse/TRAFODION-532
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Chong Hsu
            Assignee: Selvaganesan Govindarajan
            Priority: Critical
             Fix For: 1.0 (pre-incubation)


SPJ w result set failed with ERROR[8841] 

Tested with Trafodion build, 20140801-0830.

Calling a SPJ with result set:

   public static void RS292(ResultSet[] paramArrayOfResultSet) throws Exception
   {
     String str = "jdbc:default:connection";
 
     Connection localConnection = DriverManager.getConnection(str);
     Statement localStatement = localConnection.createStatement();
     paramArrayOfResultSet[0] = localStatement.executeQuery("select * from(delete from testtab where e_code>20000 return old.*) as t1");
   }


it failed with ERROR[8841]:

*** ERROR[8841] User application committed or aborted a transaction started by SQL.  This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-08-11 04:30:14]

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 RS292()
      language java  parameter style java
      library spjrs
      dynamic result sets 3
      external name 'Testrs.RS292';

Call RS292();

*** ERROR[8841] User application committed or aborted a transaction started by SQL.  This transaction needs to be committed or aborted by calling SQL COMMIT or ROLLBACK WORK. [2014-08-11 04:30:14]



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)