Re: [enhydra] Postgres driver kills MySQL communication

["Michael Strapp" <mstrapp@xxxxxxxxxxxxx>]

Hi Petr,
  It sounds like you have multiple Enhydra apps running under the same 
multiserver with different database configurations.  Under DODS 5.x, some of 
the database settings are shared between applications (and declaring 
different values for them in different .conf files results in the value 
being used from whatever application happened to initialize last) - I found 
that this was the case for the DatabaseManager.ConfigurationSetting a couple 
months back (see 
http://mail-archive.objectweb.org/dods/2004-07/msg00000.html) and I have 
since found that the DatabaseManager.ObjectIdColumnName and 
DatabaseManager.VersionColumnName settings are similarly affected.
   If you are using these settings for some apps and not others (e.g. your 
MySQL apps, but not your Postgres apps?) then I'm willing to bet that that's 
the source of the problem.  Why it doesn't happen when you remove the 
postgres.jar from the lib folder (which I guess would be in the classpath?) 
I'm not sure - since the Postgres-based Enhydra app(s) presumably would not 
initialize, it might be aborting the initializing prior to reading/updating 
these settings, or simply finish before the MySQL app(s) get to that point 
in the initialization.

   As a test, try going into the Enhydra Admin Console, and stopping the 
MySQL app that is giving the error, and starting it up again (which 
reinitializes the database manager settings for the app).  If it starts 
working (and/or any of your Postgres apps stop working with a similar 
exception), then I'd say that's definitely your problem.  Unfortunately, the 
only workaround I came up with (other than running two separate 
multiservers) was to have all apps use the same objectid and version column 
names.

Hope that helps...
Mike.

----- Original Message ----- 
From: "Petr Stehlik" <pstehlik@xxxxxxxxxx>
To: <enhydra@xxxxxxxxxxx>
Sent: Monday, October 25, 2004 3:13 AM
Subject: [enhydra] Postgres driver kills MySQL communication


> Hi all,
>
> when I put both mysql.jar and postgres.jar (JDBC drivers) into enhydra's
> lib folder then applications using the MySQL stop working with sql
> exception "'objectid' column not found". When the postgres.jar is
> removed mysql apps work correclty again. Any idea?
>
> Petr


--------------------------------------------------------------------------------


> --
> You receive this message as a subscriber of the enhydra@xxxxxxxxxxxxx
> mailing list.
> To unsubscribe: mailto:enhydra-unsubscribe@xxxxxxxxxxxxx
> For general help: mailto:sympa@xxxxxxxxxxxxx?subject=help
> ObjectWeb mailing lists service home page: http://www.objectweb.org/wws