[opencms-dev] odbc connection exclusivity

[Jonathan Woods]

Jon -
 
I don't know much about the OpenCms end, but it feels odd that it would ask
for exclusive access.  Are you sure the problem isn't at the Access end?
 
I'd first try getting into the ODBC Control Panel thing and ensuring that
the properties of the ODBC DSN concerned are set appropriately.  You could
also make sure that it isn't something in system.mdw which is causing the
problem - I guess by temporarily removing security constraints.
 
Jon

  _____  

From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of Jon Mayes
Sent: 22 March 2006 09:56
To: The OpenCms mailing list
Subject: [opencms-dev] odbc connection exclusivity



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
<http://www.pegasus-homes.co.uk/> 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/bf8f50ff/attachment.htm>