Guillaume Smet wrote [05/24/2007 12:10 PM]:
Gérard,
On 5/24/07, Gérard BUNEL <[EMAIL PROTECTED]> wrote:
Doing some tests on constraints violations, using mysql DB, I've got a
ClassNotFoundException about a MySQL Exception class (see below).
I've checked the jar in the drivers directory and this class exists in
the jar.
What's wrong here ? It seems that's appia that generates this exception.
Any help should be welcome
IIRC, it's a classloader problem. I don't remember exactly what the
problem was but it's a common problem with Sequoia/PostgreSQL
installations.
IIANM, the problem happens e.g. when a remote backend fails, for instance on
constraint violation: the group comm sends the db-specific Exception over as
part of the reply, and the receiver fails to load the alien class when
de-serializing the message. This is so because the group-comm class-loader does
not see the drivers directory. Similar ClassNotFoundException can happen with
forwarded select queries that return db-specific objects, e.g. postgresql
PGObjects, and that go through the group-comm.
We used to add the PostgreSQL driver jar in the classpath of the
controller to fix the problem. You have a CLASSPATH_XTRA environment
variable to do that (not sure about the name, check it in the
controller.sh script).
This is the simplest fix and the env var name is correct.
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
