You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Kevin Xu (JIRA)" <ji...@apache.org> on 2016/05/04 02:47:12 UTC
[jira] [Commented] (TRAFODION-532) LP Bug: 1355038 - SPJ w result
set failed with ERROR[8841]
[ https://issues.apache.org/jira/browse/TRAFODION-532?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15269944#comment-15269944 ]
Kevin Xu commented on TRAFODION-532:
------------------------------------
Selva, Sure, i'll take a look.
> 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: Kevin Xu
> 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)