Geoff Marshall ([EMAIL PROTECTED]) wrote:
> Hello all!
>
> I've got an application-level object that grabs a pool of database
> connections (MySQL using the mm.mysql JDBC driver). All works well until
> there is not activity for some extended period of time (overnight) and then
> all attempts to access the database get "communication link failure" errors.
>
> Is there any way to configure Orion or MySQL to not give up on a database
> connection. Or do I have to move the connections to some other level.
>
> I know the app objects are surviving because I can query them, but just
> can't reestablish with the db.
>
> Anyone else have similar problems or any ideas???
I was just reading the mm documentation the other day, and as I recall
there's a parameter that can be set in the jdbc URL that tells it to
retry opening the connection to mysql if the connection has closed.
The parameter defaults to false, i.e., not retrying.
Gary
> --
>
> -Geoff Marshall, Director of Development
>
> .......................................................
> t e r r a s c o p e (415) 951-4944
> 54 Mint Street, Suite 110 direct (415) 625-0349
> San Francisco, CA 94103 fax (415) 625-0306
> .......................................................
>
>
>
