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

[Manik Surtani (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBCACHE-802?page=comments#action_12345500 ] 
            
Manik Surtani commented on JBCACHE-802:
---------------------------------------

Probably a better idea to use a 'proper' connection pooling library like c3p0 or Apache's commons-dbcp.  Deferring this to 2.0.0 since this will introduce new library dependencies, which cannot be done in an SP for 1.4.0.

> 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: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Cache loaders
>    Affects Versions: 1.4.0.SP1
>            Reporter: Manik Surtani
>         Assigned To: Manik Surtani
>             Fix For: 2.0.0, 1.4.0.SP2
>
>
> 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