<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2838" name=GENERATOR>
<STYLE>@font-face {
font-family: Wingdings;
}
@font-face {
font-family: PMingLiU;
}
@font-face {
font-family: @PMingLiU;
}
@page Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt 90.0pt; }
P.MsoNormal {
FONT-SIZE: 10pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: Arial
}
LI.MsoNormal {
FONT-SIZE: 10pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: Arial
}
DIV.MsoNormal {
FONT-SIZE: 10pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: Arial
}
H1 {
FONT-SIZE: 14pt; MARGIN: 0cm 0cm 0pt; TEXT-INDENT: -1cm; FONT-FAMILY: Arial; mso-list: l0 level1 lfo2
}
H2 {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; TEXT-INDENT: -1cm; FONT-FAMILY: Arial; mso-list: l0 level2 lfo2
}
H3 {
FONT-SIZE: 11pt; MARGIN: 0cm 0cm 0pt; TEXT-INDENT: -1cm; FONT-FAMILY: Arial; mso-list: l0 level3 lfo2
}
H4 {
FONT-SIZE: 10pt; MARGIN: 0cm 0cm 0pt 1cm; TEXT-INDENT: -1cm; FONT-FAMILY: Arial; mso-list: l0 level4 lfo2
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle18 {
COLOR: windowtext; FONT-FAMILY: Arial; mso-style-type: personal-compose
}
DIV.Section1 {
page: Section1
}
OL {
MARGIN-BOTTOM: 0cm
}
UL {
MARGIN-BOTTOM: 0cm
}
</STYLE>
</HEAD>
<BODY lang=EN-GB vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=685191210-22032006><FONT face=Arial
color=#0000ff size=2>Jon -</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=685191210-22032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=685191210-22032006><FONT face=Arial
color=#0000ff size=2>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?</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=685191210-22032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=685191210-22032006><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=685191210-22032006><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=685191210-22032006><FONT face=Arial
color=#0000ff size=2>Jon</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> opencms-dev-bounces@opencms.org
[mailto:opencms-dev-bounces@opencms.org] <B>On Behalf Of </B>Jon
Mayes<BR><B>Sent:</B> 22 March 2006 09:56<BR><B>To:</B> The OpenCms mailing
list<BR><B>Subject:</B> [opencms-dev] odbc connection
exclusivity<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV>
<DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt">Dear
list,<O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt">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.<O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt">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.<O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt">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.<O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt">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.<O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt">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?<O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt">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.<O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt">Do you
know if it’s possible to do this using access
databases?<O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt">By the
way, the databases are initialised using the following
strings:<O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">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<O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face="Courier New" size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Courier New'">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<O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN style="FONT-SIZE: 10pt">Thanks
in advance,<O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt"><O:P></O:P></SPAN></FONT></P>
<P class=MsoNormal><FONT face=Arial size=2><SPAN
style="FONT-SIZE: 10pt">Jon<O:P></O:P></SPAN></FONT></P></DIV></DIV>
<DIV> </DIV>
<DIV>
<DIV><FONT face=Arial size=1>Jon Mayes</FONT> </DIV>
<DIV><FONT face=Arial size=1>Marketing & Business Systems</FONT> </DIV>
<DIV><FONT face=Arial size=1>Pegasus Retirement Homes plc</FONT> </DIV>
<DIV><FONT face=Arial size=1>Tel: </FONT></DIV>
<DIV><FONT face=Arial size=1>Fax: </FONT></DIV>
<DIV><FONT size=1><FONT
face=Arial>Email: jon.mayes@pegasus-homes.co.uk</FONT> </FONT> </DIV>
<DIV> </DIV>
<DIV>
<P class=MsoNormal><FONT face=Arial color=navy size=2><SPAN
style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">For more information on
Pegasus please visit our web site at </SPAN></FONT><FONT color=navy><SPAN
style="COLOR: navy"><A href="http://www.pegasus-homes.co.uk/"><FONT face=Arial
size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">www.pegasus-homes.co.uk</SPAN></FONT></A></SPAN></FONT>
</P></DIV>
<DIV> </DIV>
<DIV><SPAN
style="FONT-SIZE: 7.5pt; COLOR: navy; FONT-FAMILY: Arial">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.
</SPAN></DIV></DIV></DIV></BODY></HTML>