I just closed the issue. We had this discussion before, and my feeling is
that Cayenne PoolManager is pretty robust and simple, but we shouldn't
spend time building in more advanced features into it, as it will give
zero benefit over using DBCP (unless of course there are volunteers
inclined to do so). Instead 1.2 provides support for selecting DBCP pool
in the Modeler.
Andrus
> jira-norepl..bjectstyle.org wrote:
>> Reporter: Diego Iņigo wrote,
>> In the DataBase (Oracle 8.1.7.4), the timeout (expired) is the 20
>> minutes.
>
>> When inactivity time is more than 20 minutes in aplication web
>> (session
> time is 40 minutes), the pool connection of cayenne, canīt reconnect to
> the database and drop exception (Error connection Time out ...)
>> Please tell me, How to generate the reconnection to the DataBase, or
>> if
> exist the other solution for this problem.
>>
>> I wait for your response, thank
>
> There's a couple of things you could do.
>
> One would be to submit a patch to change
> org.objectstyle.cayenne.conn.PoolManager to handle that particular
> exception condition better by reconnecting. Just attach it to CAY-307.
>
> Another would be to use a different connection pool class to handle your
> connection pool.
> For instance, you might try using
> oracle.jdbc.pool.OracleConnectionCacheImpl, which is included in the
> Oracle driver jar file as it should already handle oracle-specific
> errors. You could also look at http://jakarta.apache.org/commons/dbcp/
> as another alternative, although I've never used it -- I use
> PoolManager for local development and OracleConnectionCacheImpl in
> production.
>
> If you decide to use an alternate connection pool, let us know and we'll
> close the issue.
>
> Thanks,
>
> -Mike
This archive was generated by hypermail 2.0.0 : Wed Apr 20 2005 - 05:08:31 EDT