db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deepa Remesh (JIRA)" <derby-...@db.apache.org>
Subject [jira] Created: (DERBY-639) Statements in stored procedures with holdable cursor should not be allowed to execute in xa global transaction
Date Fri, 21 Oct 2005 19:49:20 GMT
Statements in stored procedures with holdable cursor should not be allowed to execute in xa
global transaction
--------------------------------------------------------------------------------------------------------------

         Key: DERBY-639
         URL: http://issues.apache.org/jira/browse/DERBY-639
     Project: Derby
        Type: Bug
  Components: JDBC  
    Versions: 10.2.0.0    
    Reporter: Deepa Remesh


Execution of statements with HOLD_CURSORS_OVER_COMMIT must not be allowed in a global transaction.
Currently, this is allowed when the statement is inside a stored procedure. 

e.g: The following procedure should throw an error when executed inside a global transaction.
However, no error is thrown when running with embedded or client drivers. 

	//Java method for stored procedure with HOLD_CURSORS_OVER_COMMIT
	public static void testHoldCursorsProc(ResultSet[] rs) throws Exception
	{
		Connection conn = DriverManager.getConnection("jdbc:default:connection");

		//HOLD_CURSORS_OVER_COMMIT
		Statement st = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE ,
					ResultSet.CONCUR_READ_ONLY, ResultSet.HOLD_CURSORS_OVER_COMMIT);
		rs[0] = st.executeQuery("select * from testtable1");
	}



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


Mime
View raw message