Here's what I think you need:
<connection-pool maxActive="20"
>>> validationQuery="SELECT COUNT(*) FROM someSmallTable"/>
I think the validationQuery is used to check whether a connection is still valid, if
an error is thrown, then the broken connection is removed from the pool.
> -----Original Message-----
> From: Andreas Novak [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 08, 2003 6:46 AM
> To: [EMAIL PROTECTED]
> Subject: connection pool reconnect
>
>
> Dear list,
>
> I have the following problem with ojb:
>
> We've developed a document management system for IBM AS/400.
> It consists of a server process and various client processes.
> The server process performs all necessary database actions
> and instantiates a connection pool on startup. Every night
> the AS/400 machine is shutdown for backup purposes. So the
> next day, the ojb connection pool is invalid (of course). I
> didn't find any hints to solve this problem so far.
>
> Thanks in advance
> Regards
>
> --
>
> ______________________________
> Andreas Novak
> D.O.M. Datenverarbeitung GmbH
> Bahnhofstr. 41, 90402 N�rnberg
> Tel.: +49(0)911-99462-0
> Fax: +49(0)911-99462-11
> Email: [EMAIL PROTECTED]
> Internet: www.domdv.de
> ______________________________
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
