[opencms-dev] odbc connection exclusivity

[Jon Mayes]

Dear list,

 

I'm using a couple of access databases in addition to the main MySQL
database on our intranet for various bits of HR information. We have a
Sage personnel system in place, and have a separate company information
database with general non-confidential bits and pieces.

 

The problem I'm having seems to be related to OpenCms's connection pool
wanting to have an exclusive connection to each of these 2 databases,
such that if I reboot Tomcat while someone is updating the files, the
system fails on initialisation of the connection pool. Also, if the
system is initialised ok, once someone opens up the sage database
OpenCms is unable to retrieve information for the duration that the file
is in use.

Similarly, if I try to open the other access database while OpenCms is
loaded, I can only open it as read-only, which is no good for day-to-day
updating.

 

The OpenCms system & MySQL are running on a dedicated webserver, whereas
the access databases are located on our fileserver. I have granted read
& execute permissions to the machine running OpenCms on the necessary
directories, and am trying to specify read-only, non-exclusive database
connections in the OpenCms connection pool string.

 

I wonder if anyone has encountered this problem before, or knows more
about the internal working of the connection pool and hence how I might
be able to remedy the situation?

 

I suppose we could get round the problem by duplicating the databases,
specifying a daily/weekly publishing period and making sure people know
the appropriate validity times for the data, but it would be preferable,
if possible, to render all changes in real time.

 

Do you know if it's possible to do this using access databases?

 

By the way, the databases are initialised using the following strings:

 

db.pool.access.jdbcUrl=jdbc:odbc:Driver={Microsoft Access Driver
(*.mdb)};DBQ=\\\\pegasus02\\Company\\Business System Development\\BSD
Shared Info\\CompanyInfo.mdb;Exclusive=No;READONLY=true

 

db.pool.sage.jdbcUrl=jdbc:odbc:Driver={Microsoft Access Driver
(*.mdb)};DBQ=\\\\pegasus02\\sage
personnel\\DATA\\Perdata.mdb;SystemDB=\\\\Pegasus02\\sage
personnel\\secure.mdw;Exclusive=No;READONLY=true

 

Thanks in advance,

 

Jon 
 
Jon Mayes
Marketing & Business Systems
Pegasus Retirement Homes plc
Tel: 
Fax: 
Email: jon.mayes at pegasus-homes.co.uk 
 
For more information on Pegasus please visit our web site at www.pegasus-homes.co.uk 

 
Privileged/Confidential information may be contained in this message.  If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone.  In such case, you should destroy this message and kindly notify the sender by reply email.  Please advise immediately if you or your employer does not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of my firm shall be understood as neither given nor endorsed by it.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20060322/33d8d35a/attachment.htm>