Paul Mackay wrote [01/26/2007 11:57 AM]:
Hi,
Hi Paul,
In a Raidb-1 configuration with 2 backends, if only one backend fails on
a stored procedure prepared call, is there a way to detect this at the
Java JDBC level ?
No. If the call succeeded on at least one backend,
it is a "cluster-wide" success.
Also, in such case, any backend that does not succeed
will be automatically disabled - i.e. "in your back".
If you want to detect these events, you'll have to either scan the logs
or handle the JMX notifications sent out by the controller.
[see DatabaseBackend.notifyJMXStateChanged()]
It seems indeed that if only one backend fails, no
JDBC exception is thrown. I I thought that setting the WaitForCompletion
to "all" would make that the exception is thrown even if the error
occurred only on one backend, but apparently it is not the case.
WaitForCompletion="all" just makes Sequoia wait for all backends to
complete execution before it returns to the client, independently
of the actual outcome.
Cheers,
Olivier.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
