Hi,
I am testing the use of sequoia as a middleware component between a web application running on Apache Tomcat5.5.7 and MSSQL Server using a single db configuration.(load balancer and scheduler). (BackEndDriver- Microsoft's JDBC Type 4 driver-- SQLServerDriver)
The rest of the configuration has the default values intact
When running the above setup,In storedprocedure calls, i am getting errors of this kind..
...Error during command execution: Stored Procedure <id>failed Query <queryid> is not in the list of currently scheduled queries..
I have inspected the sourcecode and found that in VirtualDatabaseWorkerThread.java, for procedures that are not read-only, a method call "setRequestParameters" is repeated in 2 places
if(!proc.isReadOnly)
logTransactionBegin(proc)
...
and later in setRequestParametersAndTransactionStarted(proc)
However the scheduler re-assigns an id incremented only by one..
I feel that this could be the cause of the mismatch..
Can u give me probable reasons for this behavior?
Regards,
Mythreyi
_______________________________________________ Sequoia mailing list [email protected] https://forge.continuent.org/mailman/listinfo/sequoia
