[JBoss JIRA] Created: (JBCACHE-802) NonManagedConnectionFactory does not place new connections in ThreadLocal (JDBCCacheLoader)
6:31 p.m.
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: 1.4.0.SP2, 2.0.0
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
6:37 p.m.
New subject: [JBoss JIRA] Closed: (JBCACHE-802) NonManagedConnectionFactory does not place new connections in ThreadLocal (JDBCCacheLoader)
[ http://jira.jboss.com/jira/browse/JBCACHE-802?page=all ]
Manik Surtani closed JBCACHE-802.
---------------------------------
Resolution: Done
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: 1.4.0.SP2, 2.0.0
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
4:15 p.m.
New subject: [JBoss JIRA] Reopened: (JBCACHE-802) NonManagedConnectionFactory does not place new connections in ThreadLocal (JDBCCacheLoader)
[ http://jira.jboss.com/jira/browse/JBCACHE-802?page=all ]
Manik Surtani reopened JBCACHE-802:
-----------------------------------
The problem here though is that when using transactions that span multiple calls, this
breaks things.
A proper solution would be to use a rudimentary internal pool (HashMap of open conns) for
the non-managed factory.
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
2:37 p.m.
New subject: [JBoss JIRA] Commented: (JBCACHE-802) NonManagedConnectionFactory does not place new connections in ThreadLocal (JDBCCacheLoader)
[ 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
2:40 p.m.
New subject: [JBoss JIRA] Updated: (JBCACHE-802) NonManagedConnectionFactory does not place new connections in ThreadLocal (JDBCCacheLoader)
[ http://jira.jboss.com/jira/browse/JBCACHE-802?page=all ]
Manik Surtani updated JBCACHE-802:
----------------------------------
Complexity: Medium (was: Low)
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: Manik Surtani
Fix For: 2.0.0
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
2:40 p.m.
New subject: [JBoss JIRA] Updated: (JBCACHE-802) NonManagedConnectionFactory does not place new connections in ThreadLocal (JDBCCacheLoader)
[ http://jira.jboss.com/jira/browse/JBCACHE-802?page=all ]
Manik Surtani updated JBCACHE-802:
----------------------------------
Issue Type: Feature Request (was: Bug)
Workaround Description: Use the cache in an environment that provides DB connection
pooling.
Fix Version/s: (was: 1.4.0.SP2)
Workaround: [Workaround Exists]
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: Manik Surtani
Fix For: 2.0.0
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
6:26 p.m.
New subject: [JBoss JIRA] Assigned: (JBCACHE-802) NonManagedConnectionFactory does not place new connections in ThreadLocal (JDBCCacheLoader)
[ http://jira.jboss.com/jira/browse/JBCACHE-802?page=all ]
Galder Zamarreno reassigned JBCACHE-802:
----------------------------------------
Assignee: Galder Zamarreno (was: Manik Surtani)
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
1:43 p.m.
New subject: [JBoss JIRA] Commented: (JBCACHE-802) NonManagedConnectionFactory does not place new connections in ThreadLocal (JDBCCacheLoader)
[ 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
4:48 p.m.
New subject: [JBoss JIRA] Resolved: (JBCACHE-802) NonManagedConnectionFactory does not place new connections in ThreadLocal (JDBCCacheLoader)
[ http://jira.jboss.com/jira/browse/JBCACHE-802?page=all ]
Galder Zamarreno resolved JBCACHE-802.
--------------------------------------
Resolution: Done
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
4:48 p.m.
New subject: [JBoss JIRA] Updated: (JBCACHE-802) NonManagedConnectionFactory does not place new connections in ThreadLocal (JDBCCacheLoader)
[ http://jira.jboss.com/jira/browse/JBCACHE-802?page=all ]
Galder Zamarreno updated JBCACHE-802:
-------------------------------------
Fix Version/s: 2.0.0.BETA1
(was: 2.0.0.GA)
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.BETA1
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
4:50 p.m.
New subject: [JBoss JIRA] Updated: (JBCACHE-802) NonManagedConnectionFactory does not place new connections in ThreadLocal (JDBCCacheLoader)
[ http://jira.jboss.com/jira/browse/JBCACHE-802?page=all ]
Galder Zamarreno updated JBCACHE-802:
-------------------------------------
Fix Version/s: 2.0.0.GA
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, 2.0.0.BETA1
Time Spent: 2 days, 2 hours
Remaining Estimate: 0 minutes
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
2:24 p.m.
New subject: [JBoss JIRA] Commented: (JBCACHE-802) NonManagedConnectionFactory does not place new connections in ThreadLocal (JDBCCacheLoader)
[ http://jira.jboss.com/jira/browse/JBCACHE-802?page=comments#action_12385518 ]
gmeroz commented on JBCACHE-802:
--------------------------------
i still get the same error as in
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3976403#... with the
2.0.0GA version.
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, 2.0.0.BETA1
Time Spent: 2 days, 2 hours
Remaining Estimate: 0 minutes
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
2:45 p.m.
New subject: [JBoss JIRA] Commented: (JBCACHE-802) NonManagedConnectionFactory does not place new connections in ThreadLocal (JDBCCacheLoader)
[ http://jira.jboss.com/jira/browse/JBCACHE-802?page=comments#action_12385522 ]
gmeroz commented on JBCACHE-802:
--------------------------------
sorry, i gave the wrong link. it should be
http://www.jboss.com/index.html?module=bb&op=viewtopic&t=100235
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, 2.0.0.BETA1
Time Spent: 2 days, 2 hours
Remaining Estimate: 0 minutes
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
4:40 p.m.
New subject: [JBoss JIRA] Commented: (JBCACHE-802) NonManagedConnectionFactory does not place new connections in ThreadLocal (JDBCCacheLoader)
[ http://jira.jboss.com/jira/browse/JBCACHE-802?page=comments#action_12389814 ]
Galder Zamarreno commented on JBCACHE-802:
------------------------------------------
This is not a forum. Please enter a user forum entry with your issue.
Btw, read the JIRA and the documentation :)
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, 2.0.0.BETA1
Time Spent: 2 days, 2 hours
Remaining Estimate: 0 minutes
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
6265
days inactive
6681
days old
13 comments
4 participants
participants (4)
-
Galder Zamarreno (JIRA) -
Galder Zamarreno (JIRA) -
gmeroz (JIRA)
-
Manik Surtani (JIRA)