Re: [ebxmlms-general] Database reconnect problem

[Andreas H. <and...@en...>]

Hallo David,
thanks for your answer. However I think my problem description was 
misunderstood. It is not the problem on starting hermes, the problem is 
that hermes cannot reconnect to the database while running.
I just wanted hermes to reconnect correctly (without restaring) to the 
database if the connection was lost (e.g. network problem) and the 
database is available/reachable again.
Restarting hermes is not a good option if such errors occur.

thanks,
Andreas

David RR Webber (XML) wrote:
> Andreas,
>  
> 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.  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.
>  
> DW
>
>
>     -------- Original Message --------
>     Subject: [ebxmlms-general] Database reconnect problem
>     From: Andreas Hausleitner <and...@en...>
>     Date: Fri, September 22, 2006 4:29 am
>     To: General discussions <ebx...@li...>
>
>     Hello,
>     we encountered  a problem with hermes when database connection is
>     lost,
>     e.g. database shutdown or network problems.
>     Hermes reconnects fine if the database is available only if no
>     clients
>     try to send a message in between to the msh.
>
>     If the database is not available and a client tries to send a
>     message it
>     will fail with the error:
>     hk.hku.cecid.phoenix.message.handler.RequestException:
>     Fail to send EbxmlMessage to MessageServiceHandler:
>      HTTP response code = 409
>      HTTP response message = [10008] HTTP POST request failed - [10306]
>     Cannot create DB connection
>
>     If the database is available again later on hermes cannot
>     reconnect to
>     the database. We got this error messages periodically:
>     2006-09-22 10:22:30,181 ERROR [thread-pool-47]: [10303] Cannot get DB
>     connection - give up after 20000 milliseconds
>
>     Has anyone found a workaround for this problem?
>
>     Thanks,
>     Andreas
>
>     -- 
>     ------------------------------------------
>     Andreas Hausleitner, DI
>     Software Developement
>
>     enerbility software gmbh
>     Mariahilferstrasse 113/43
>     A-1070 Wien
>
>     email:  and...@en...
>     http:   www.enerbility.com
>     ------------------------------------------
>
>
>     -------------------------------------------------------------------------
>     Take Surveys. Earn Cash. Influence the Future of IT
>     Join SourceForge.net's Techsay panel and you'll get the chance to
>     share your
>     opinions on IT & business topics through brief surveys -- and earn
>     cash
>     http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>     _______________________________________________
>     ebxmlms-general mailing list
>     ebx...@li...
>     https://lists.sourceforge.net/lists/listinfo/ebxmlms-general 
>
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> ------------------------------------------------------------------------
>
> _______________________________________________
> ebxmlms-general mailing list
> ebx...@li...
> https://lists.sourceforge.net/lists/listinfo/ebxmlms-general
>   


-- 
------------------------------------------
Andreas Hausleitner, DI
Software Developement

enerbility software gmbh
Mariahilferstrasse 113/43
A-1070 Wien

email:  and...@en...
http:   www.enerbility.com
------------------------------------------