Re: [ebxmlms-general] Database reconnect problem

[David RR W. \(XML\) <da...@dr...>]

<div>Andreas,</div>
<div>&nbsp;</div>
<div>Our stock "workaround" for any startup problems with Hermes is to
flush the local database tables that Hermes uses for its internal
tracking and then restart.&nbsp; We're using DerbyDB for those tables -
and then Oracle for our main processing - so it makes it easy to flush
those DerbyDB tables by just deleting the local directory.</div>
<div>&nbsp;</div>
<div>DW<BR></div>
<DIV id=wmMessageComp name="wmMessageComp"><BR><BR>
<BLOCKQUOTE style="PADDING-LEFT: 8px; MARGIN-LEFT: 8px; BORDER-LEFT:
blue 2px solid">-------- Original Message --------<BR>Subject:
[ebxmlms-general] Database reconnect problem<BR>From: Andreas
Hausleitner &lt;and...@en...&gt;<BR>Date: Fri,
September 22, 2006 4:29 am<BR>To: General discussions
&lt;ebx...@li...&gt;<BR><BR>Hello,<BR>we
encountered &nbsp;a problem with hermes when database connection is
lost, <BR>e.g. database shutdown or network problems.<BR>Hermes
reconnects fine if the database is available only if no clients <BR>try
to send a message in between to the msh.<BR><BR>If the database is not
available and a client tries to send a message it <BR>will fail with
the
error:<BR>hk.hku.cecid.phoenix.message.handler.RequestException:<BR>Fail
to send EbxmlMessage to MessageServiceHandler:<BR>&nbsp;HTTP response
code = 409<BR>&nbsp;HTTP response message = [10008] HTTP POST request
failed - [10306] <BR>Cannot create DB connection<BR><BR>If the database
is available again later on hermes cannot reconnect to <BR>the database.
We got this error messages periodically:<BR>2006-09-22 10:22:30,181
ERROR [thread-pool-47]: [10303] Cannot get DB <BR>connection - give up
after 20000 milliseconds<BR><BR>Has anyone found a workaround for this
problem?<BR><BR>Thanks,<BR>Andreas<BR><BR>--
<BR>------------------------------------------<BR>Andreas Hausleitner,
DI<BR>Software Developement<BR><BR>enerbility software
gmbh<BR>Mariahilferstrasse 113/43<BR>A-1070 Wien<BR><BR>email:
&nbsp;and...@en...<BR>http: &nbsp;
www.enerbility.com<BR>------------------------------------------<BR><BR><BR>-------------------------------------------------------------------------<BR>Take
Surveys. Earn Cash. Influence the Future of IT<BR>Join SourceForge.net's
Techsay panel and you'll get the chance to share your<BR>opinions on IT
&amp; business topics through brief surveys -- and earn
cash<BR>http://www.techsay.com/default.php?page=join.php&amp;p=sourceforge&amp;CID=DEVDEV<BR>_______________________________________________<BR>ebxmlms-general
mailing
list<BR>ebx...@li...<BR>https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
</BLOCKQUOTE></DIV>