<HTML >
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:PMingLiU;
panose-1:2 2 3 0 0 0 0 0 0 0;}
@font-face
{font-family:"\@PMingLiU";
panose-1:2 2 3 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:Arial;}
h1
{margin:0cm;
margin-bottom:.0001pt;
text-indent:-1.0cm;
page-break-after:avoid;
mso-list:l0 level1 lfo2;
font-size:14.0pt;
font-family:Arial;}
h2
{margin:0cm;
margin-bottom:.0001pt;
text-indent:-1.0cm;
page-break-after:avoid;
mso-list:l0 level2 lfo2;
font-size:12.0pt;
font-family:Arial;}
h3
{margin:0cm;
margin-bottom:.0001pt;
text-indent:-1.0cm;
page-break-after:avoid;
mso-list:l0 level3 lfo2;
font-size:11.0pt;
font-family:Arial;}
h4
{margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:1.0cm;
margin-bottom:.0001pt;
text-indent:-1.0cm;
page-break-after:avoid;
mso-list:l0 level4 lfo2;
font-size:10.0pt;
font-family:Arial;}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle18
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:176237795;
mso-list-template-ids:818167478;}
@list l0:level1
{mso-level-style-link:"Heading 1";
mso-level-text:%1;
mso-level-tab-stop:0cm;
mso-level-number-position:left;
margin-left:0cm;
text-indent:-1.0cm;
mso-ansi-font-size:14.0pt;
mso-bidi-font-size:14.0pt;
font-family:Arial;
mso-bidi-font-family:"Times New Roman";
mso-ansi-font-weight:bold;
mso-ansi-font-style:normal;}
@list l0:level2
{mso-level-style-link:"Heading 2";
mso-level-text:"%1\.%2";
mso-level-tab-stop:0cm;
mso-level-number-position:left;
margin-left:0cm;
text-indent:-1.0cm;}
@list l0:level3
{mso-level-style-link:"Heading 3";
mso-level-text:"%1\.%2\.%3";
mso-level-tab-stop:0cm;
mso-level-number-position:left;
margin-left:0cm;
text-indent:-1.0cm;}
@list l0:level4
{mso-level-style-link:"Heading 4";
mso-level-text:"%1\.%2\.%3\.%4";
mso-level-tab-stop:1.0cm;
mso-level-number-position:left;
margin-left:1.0cm;
text-indent:-1.0cm;}
@list l0:level5
{mso-level-text:"%1\.%2\.%3\.%4\.%5";
mso-level-tab-stop:155.95pt;
mso-level-number-position:left;
margin-left:155.95pt;
text-indent:-2.0cm;}
@list l0:level6
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6";
mso-level-tab-stop:6.0cm;
mso-level-number-position:left;
margin-left:6.0cm;
text-indent:-70.85pt;}
@list l0:level7
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7";
mso-level-tab-stop:184.3pt;
mso-level-number-position:left;
margin-left:184.3pt;
text-indent:-3.0cm;}
@list l0:level8
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8";
mso-level-tab-stop:7.0cm;
mso-level-number-position:left;
margin-left:7.0cm;
text-indent:-99.2pt;}
@list l0:level9
{mso-level-text:"%1\.%2\.%3\.%4\.%5\.%6\.%7\.%8\.%9";
mso-level-tab-stop:212.65pt;
mso-level-number-position:left;
margin-left:212.65pt;
text-indent:-4.0cm;}
@list l1
{mso-list-id:884097832;
mso-list-template-ids:-812771672;
mso-list-style-name:"Style Bulleted1";}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:14.2pt;
mso-level-number-position:left;
margin-left:14.2pt;
text-indent:-14.2pt;
font-family:Wingdings;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
margin-left:54.0pt;
text-indent:-18.0pt;
mso-ascii-font-family:"Courier New";
mso-hansi-font-family:"Courier New";}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
</HEAD>
<BODY lang=EN-GB link=blue vlink=purple>
<DIV>
<DIV>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt'>Dear
list,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt'>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 size=2 face=Arial><span style='font-size:10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt'>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 size=2 face=Arial><span style='font-size:10.0pt'>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 size=2 face=Arial><span style='font-size:10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt'>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 size=2 face=Arial><span style='font-size:10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt'>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 size=2 face=Arial><span style='font-size:10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt'>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 size=2 face=Arial><span style='font-size:10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt'>Do you
know if it’s possible to do this using access databases?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt'>By
the way, the databases are initialised using the following strings:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
lang=EN-US style='font-size:10.0pt;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 size=2 face=Arial><span lang=EN-US style='font-size:
10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
lang=EN-US style='font-size:10.0pt;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 size=2 face=Arial><span style='font-size:10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt'>Thanks
in advance,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt'>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><BODY lang=EN-GB link=blue vlink=purple>
<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>
</BODY></DIV>
<DIV> </DIV>
<DIV><BODY lang=EN-GB link=blue vlink=purple><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></BODY></DIV>
</DIV>
</DIV></BODY></HTML>