Duplicated notification of procedure completion in the RequestManager for
executeUpdate Callable Statements
-----------------------------------------------------------------------------------------------------------
Key: SEQUOIA-1032
URL: https://forge.continuent.org/jira/browse/SEQUOIA-1032
Project: Sequoia
Type: Bug
Components: Core
Versions: Sequoia 3.0 beta2, Sequoia 2.9
Reporter: Matthieu Dalstein
When calling a callable statement with the JDBC executeUpdate method, a
DriverSQLException is raised and no reply can be retrieved.
A sample client code which raises this exception is:
CallableStatement cst = connection.prepareCall("{call mySP}");
cst.executeUpdate();
The exception in the client is:
org.continuent.sequoia.common.exceptions.driver.DriverSQLException: Message of
cause: Query 1 is not in the list of currently scheduled queries
>From the Sequoia server side, the error is:
controller.virtualdatabase.myvdb Stored procedure 1 failed (Query 1 is not in
the list of currently scheduled queries)
The issue seems to be due to the callableStatementExecuteUpdate method of the
RequestManager. There seems to be a double notification of completion in the
RequestManager with the following code (starting line 1305 for sequoia 2.10.9)
// Notify scheduler of completion
scheduler.storedProcedureCompleted(proc)
...
}
finally
{
if (hasBeenScheduled)
scheduler.storedProcedureCompleted(proc);
I am probably missing something, but I don't see the point in the first
notification.
Cheers
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
