Hi Victor,
Now I have a SELECT stored procedure working and I would like to test
the other three types (UPDATE, INSERT, DELETE).
I'm currenlty using UPDATE:
UPDATE logs SET logs = 'hola' WHERE logs = 'amigo'
but I get this exception:
15:11:08,794 WARN controller.virtualdatabase.mySqlServerDB Request
{call spDstUpdate()}/ failed, transaction has been aborted (Query 1 is
not in the list of currently scheduled queries)
in the controller.
There could be 2 explanations for this:
1. A query already failed in the transaction before executing this
stored procedure call. No query will be successfully executed until you
rollback the transaction and start a new one.
2. There is a bug in Sequoia. If you use the same code directly against
MS SQL without going through Sequoia, does it work?
The database is SQL Server 2000, I'm using RAIDb-1 load balancer, jdk
1.4,
Which version of Sequoia are you using?
Thanks for your feedback,
Emmanuel
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
