Re: [eclipselink-users] connection management

[James Sutherland <jamesssss@xxxxxxxxx>]

If you are using EclipseLink with a DataSource, then most DataSources allow
you to configure a threshold number of connections or timeouts.  Most JEE
servers provide such DataSources, as well as their being several third party
DataSource implementations that also run in JSE.

If you are using EclipseLink connection pooling, then only a min and max
connections are supported.  You can set the max to a sufficiently high
number and the min to the number of connections you wish use went not busy.

You could also log an enhancement request for a threshold or timeout setting
for EclipseLink's connection pooling.



vrmerlin wrote:
> 
>  
> 
> Hi folks,
> 
>  
> 
> We are looking at using EclipseLink/JPA for a large distributed
> environment
> (1,500+ processes). Many of the processes will need to get to the database
> (Oracle), but not that frequently. So. is there a way to have EclipseLink
> "give up" its connections, after a timeout period, then automatically
> reestablish them as needed?
> 
>  
> 
> Thanks,
> John
> 
> 


-----
---
http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland 
http://www.eclipse.org/eclipselink/
 EclipseLink ,  http://www.oracle.com/technology/products/ias/toplink/
TopLink 
Wiki:  http://wiki.eclipse.org/EclipseLink EclipseLink , 
http://wiki.oracle.com/page/TopLink TopLink 
Forums:  http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink , 
http://www.nabble.com/EclipseLink-f26430.html EclipseLink 
Book:  http://en.wikibooks.org/wiki/Java_Persistence Java Persistence 
-- 
View this message in context: http://www.nabble.com/connection-management-tp20217228p20227276.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.