[jboss-jira] [JBoss JIRA] Commented: (JBCACHE-802) NonManagedConnectionFactory does not place new connections in ThreadLocal (JDBCCacheLoader)

[Galder Zamarreno (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBCACHE-802?page=comments#action_12347649 ] 
            
Galder Zamarreno commented on JBCACHE-802:
------------------------------------------

Anthony Patricio has previous experience with connection pool libraries.
C3P0 is apparently the more robust one and it's still active (there hasn't been 
any dev in dbcp for 2 yeas).

Talking to Manik, any dependencies on external libraries should be dynamic. 
Unless you actually set C3P0 settings in the CacheLoader, there shouldn't be 
a need to have the C3P0 library in the lib directory. This could be achieved isolating 
the usage to a single class and loading this class via reflection. The class would 
be specified inside the properties of the CacheLoader.

> NonManagedConnectionFactory does not place new connections in ThreadLocal (JDBCCacheLoader)
> -------------------------------------------------------------------------------------------
>
>                 Key: JBCACHE-802
>                 URL: http://jira.jboss.com/jira/browse/JBCACHE-802
>             Project: JBoss Cache
>          Issue Type: Feature Request
>      Security Level: Public(Everyone can see) 
>          Components: Cache loaders
>    Affects Versions: 1.4.0.SP1
>            Reporter: Manik Surtani
>         Assigned To: Galder Zamarreno
>             Fix For: 2.0.0.GA
>
>
> In NonManagedConnectionFactory.getConnection():
>  public Connection getConnection()
> {
> Connection con = (Connection) connection.get();
> if(con == null)
> {
> try
> {
> con = DriverManager.getConnection(url, usr, pwd);
> // CODE ADDED HERE
> connection.set(con);
> // END CODE MODIFICATION
> }
> catch(SQLException e)
> ...

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira