You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@commons.apache.org by Deepak Vishwanathan <vd...@yahoo.com> on 2004/04/28 21:31:56 UTC
Database Connection Pooling help needed
Hi everyone,
The scenario is like I want to write a class that can be remotely
invoked using JMS / RMI technology. This class will be solely responsible
for fetching the data from the database, with connection pooling
capabilities.
Any component that needs data from the database connects to the above
mentioned class.
If I were to write such a Java class (component), is there any popular
open source project package designed specifically to facilitate such a
class.
The constraint is that package should be free for redistribution.
The application is an enterprise application.
Thanks
Deepak
---------------------------------
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
Re: DBCP POOL -Standard Pool Parameters for users around 500
Posted by raj <ra...@yahoo.com>.
Hello Dirk and Other Experts,
I need help in indentifying stand DBCP POOl parameters
for approxly 200 users(using DB transaction via
connaction pooling ) and other 200 other means of DB
trasactions .
We are using JRUN 3x, Iplanet 4.1 servicepack 5,
Oracle 8.1.7. and
commons-pool-1.1.jar and commons-dbcp-1.1.jar.
The current parameter are ..
connectionPool.setTestOnBorrow(true);
connectionPool.setTestOnReturn(true);
connectionPool.setMaxActive(400);
connectionPool.setMaxIdle(40);
connectionPool.setMinIdle(20);
connectionPool.setWhenExhaustedAction(connectionPool.WHEN_EXHAUSTED_GROW);
connectionPool.setNumTestsPerEvictionRun(20);
connectionPool.setMinEvictableIdleTimeMillis(600000);
connectionPool.setTimeBetweenEvictionRunsMillis(10000);
// 10 sec
Could some one confirm these and also specify any
potential problems as well as specify your
recommendations.
I appreciate your time and help in this regard.
Thanks in Advance.
Regards..RAJ
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org
Re: DBCP POOL -Connection Pool giving nullpointer -->Unable to intialize
-->Crashing
Posted by Dirk Verbeeck <di...@pandora.be>.
First try with WHEN_EXHAUSTED_BLOCK
and maxWait=10000
I still haven't seen the place where the pool exception is catched and
ignored causing a nullpointer. Maybe in the constructor of
DBConnection or in the executeQuery method?
-- Dirk
raj wrote:
> We are using commons-pool-1.1.jar and
> commons-dbcp-1.1.jar
> Do you think I have to change MAX Active to some more
> number like 300 or some thing and add
>
> MAXIdle
> MInIdle
> WHEN_EXHAUSTED_GROW
> and also
> connectionPool.setNumTestsPerEvictionRun(20);
> connectionPool.setMinEvictableIdleTimeMillis(600000);
> connectionPool.setTimeBetweenEvictionRunsMillis(10000);
> // 10 sec
>
> Please let me know...
> Here are the files..
> this jsp calls DBConnection which inturn call
> datasourcefactory function to initialize connection.
> frmTestConnectionPool.jsp START
> **********-----------
> <%@ page import="java.sql.*" %>
> <%@ page import="javax.naming.*" %>
> <%@ page import="javax.sql.*" %>
> <%@ page import="***.***.***.jdbc.*" %>
> <%@ page import="***.***.***.DBConnection" %>
> <%@ page
> import="org.apache.commons.dbcp.PoolingDataSource" %>
> <%@ page
> import="org.apache.commons.dbcp.PoolingDriver" %>
> <%@ page import="org.apache.commons.pool.ObjectPool"
> %>
>
> <title>Support: Connection Pool</title>
> <% try {
> // start Application
> applicationStart( globalContext, log, literal,
> profiler);
> } catch (Exception e) {
> logger.writeError(e.toString());
> }
> %>
> <br><br>
> <table cellSpacing="0" cellPadding="0" border="0">
> <tbody>
> <tr>
> <td>
> <table border="0" cellpadding="2" cellspacing="0">
> <tr><td><font class="pageheader"> Connection
> Pooling Test</td></tr>
> </table>
> </td>
> </tr>
> <tr>
> <td valign="top" align="left" width="533"
> class="largebody">
> <table border="0" cellpadding="2" cellspacing="0">
> <tr><td><img src="/images/2.0/main.jpg" width="533"
> height="150"></td></tr>
> <tr><td> </td></tr>
> </table>
> <%-- Begin body content --%>
> <%
> DBConnection objCase = null;
> ResultSet objCaseRs = null;
> try {
> objCase = new DBConnection();
> int id = 0;
> objCaseRs = objCase.executeQuery("select count(*)
> from sw_case");
> if(objCaseRs != null) {
> if(objCaseRs.next()){
> id = objCaseRs.getInt(1);
> %>
> <%="CASE COUNT: " + id %>
> <%
> }
> }
> }
> catch (Exception e) {
> StackTraceElement[] st = e.getStackTrace();
> StackTraceElement st2 = null;
> log.addEntry(" frmTestConnectionPool.jsp ",
> Log.LOG_SEVERITY_ERROR, e.toString());
> for(int i=0; i< st.length; i++) {
> st2 = st[i];
> log.addEntry(" frmTestConnectionPool.jsp ",
> st2.toString());
> }
> throw e;
> } finally {
> objCase.closeAllIgnoreExceptions();
> }
> %>
> <%-- End body content --%>
> </td>
> <td width="20"><img height=3 alt=""
> src="/images/2.0/px_transparent.gif" width=20
> border=0></td>
> <td width=162 align=left valign="top">
> <%@include file="/include/promos/incExtPromos.jsp"%>
> </td>
> </tr>
> <tr><td colspan="3" height="1"
> valign="top"> </td></tr>
> <tr><td colspan="3" height="1" valign="top"><spacer
> type="block" width="1" height="1"/></td></tr>
> <tr><td colspan="3" height="4"><img
> src="/images/2.0/clearpixel.gif" width="1"
> height="4"></td></tr>
> </table>
> <%@ include file="/include/layout/endLayout.jsp" %>
> ****** frmTestConnectionPool.jsp END -----
>
> ***** DBConnection setup ----
> private void setupEnvironment() throws Exception {
> context = new InitialContext();
> ds =
> ***.***.****.jdbc.DataSourceFactory.getDataSource();
> con = ds.getConnection();
> }
> *******-----
>
>
> DATASOURCEFACTORY java
> public class DataSourceFactory {
> private static DataSource ds = null;
> public static synchronized DataSource
> getDataSource() {
> if (ds == null) {
> setup();
> }
> return ds;
> }
> static void setup() {
> try {
>
> Class.forName("oracle.jdbc.driver.OracleDriver");
> } catch (ClassNotFoundException e) {
> throw new LoggedError(e);
> }
> // read defaults from properties file
> Properties p =
> PropertiesManager.getProperties("jdbc");
> String driver =
> p.getProperty("**.***.***.jdbc.driver");
> String auth =
> p.getProperty("**.***.***.jdbc.auth");
> String server =
> p.getProperty("**.***.***.jdbc.db");
>
> String connectURI = driver + ":" + auth + "@"
> + server;
> // setup data source
> ds = setupDataSource(connectURI);
> }
> private static DataSource setupDataSource(String
> connectURI) {
> String testStr = "SELECT COUNT(*) FROM DUAL";
> GenericObjectPool connectionPool = new
> GenericObjectPool(null);
> ConnectionFactory connectionFactory = new
> DriverManagerConnectionFactory(connectURI,null);
> new
> PoolableConnectionFactory(connectionFactory,connectionPool,null,testStr,false,true);
> // set up pool options
> connectionPool.setTestOnBorrow(true);
> connectionPool.setTestOnReturn(true);
> connectionPool.setMaxActive(50);
>
> connectionPool.setWhenExhaustedAction(connectionPool.WHEN_EXHAUSTED_FAIL);
> PoolingDataSource dataSource = new
> PoolingDataSource(connectionPool);
> return dataSource;
> }
> }
> *****************************END DATASOURCEFACTORY
> ------------
>
> DIrk...Thanks very much for your help in advance.
> Regards..RAJ
>
> --- Dirk Verbeeck <di...@pandora.be> wrote:
>
>>DBCP version? (1.0, 1.1, nightly)
>>
>>Normally you should get a SQLException even when the
>>pool is empty.
>>Can you post your frmTestConnectionPool.jsp?
>>
>>-- Dirk
>>
>>raj wrote:
>>
>>
>>>Hello,
>>>We have been using jakarta pool implementation
>>
>>with
>>
>>>JRUN for past 6 months and worked fine until last
>>>week.
>>>Started giving this error.
>>>
>>>Works fine for couple of hours and starts crashing
>>
>>and
>>
>>>had to restart JRUN every time.
>>>
>>>Explanation from our admin -->
>>>Load on database causing delay in getting
>>
>>connection
>>
>>>from connection pool which is becoming stale after
>>>trying to get connection for long time.
>>>I did not like this explanation as nothing changed
>>
>>and
>>
>>>started suddenly.
>>>ANY HELP WILL BE REALLY APPRECIATED and THANKS FOR
>>>YOUR TIME.
>>>
>>>These are the parameters for connection pool
>>
>>>GenericObjectPool connectionPool = new
>>>GenericObjectPool(null);
>>> ConnectionFactory connectionFactory = new
>>>DriverManagerConnectionFactory(connectURI,null);
>>> new
>>>
>>
> PoolableConnectionFactory(connectionFactory,connectionPool,null,testStr,false,true);
>
>>> // set up pool options
>>>
>>>
>>> connectionPool.setTestOnBorrow(true);
>>> connectionPool.setTestOnReturn(true);
>>> connectionPool.setMaxActive(50);
>>>
>>>
>>
> connectionPool.setWhenExhaustedAction(connectionPool.WHEN_EXHAUSTED_FAIL);
>
>>> PoolingDataSource dataSource = new
>>>PoolingDataSource(connectionPool);
>>>
>>>--> This is stacktrace from the JSP -->
>>>
>>>
>>>05/04/2004 06:03:06 PM
>>>/temp/frmTestConnectionPool.jsp Error 0
>>
>>
>>
>>> Testing
>>>05/04/2004 06:03:06 PM
>>>/temp/frmTestConnectionPool.jsp Error 0
>>
>>
>>
>>> Testing 2
>>>05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>>
>>
>>
>>> Error 0
>>>java.lang.NullPointerException
>>>05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>>
>>
>>
>>> Information 0
>>>
>>
> com.nokia.support.DBConnection.printStackTraceToLog(DBConnection.java:925)
>
>>>05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>>
>>
>>
>>> Information 0
>>>
>>
> com.nokia.support.DBConnection.<init>(DBConnection.java:349)
>
>>> ----->
>>>05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>>
>>
>>
>>> Information 0
>>>
>>
> jrun__temp__frmTestConnectionPool2ejsp1f._jspService(jrun__temp__frmTestConnectionPool2ejsp1f.java:807)
>
>>>05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>>
>>
>>
>>> Information 0
>>>
>>
> allaire.jrun.jsp.HttpJSPServlet.service(HttpJSPServlet.java:39)
>
>>>05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>>
>>
>>
>>> Information 0
>>>
>>
> allaire.jrun.jsp.JSPServlet.service(JSPServlet.java:228)
>
>>>05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>>
>>
>>
>>> Information 0
>>>
>>
> allaire.jrun.jsp.JSPServlet.service(JSPServlet.java:196)
>
>>>05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>>
>>
>>
>>> Information 0
>>>
>>
> allaire.jrun.servlet.JRunSE.service(JRunSE.java:1417)
>
>>>05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>>
>>
>>
>>> Information 0
>>>
>>
> allaire.jrun.session.JRunSessionService.service(JRunSessionService.java:1088)
>
>>>05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>>
>>
>>
>>> Information 0
>>>
>>
> allaire.jrun.servlet.JRunSE.runServlet(JRunSE.java:1271)
>
>>>05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>>
>>
>>
>>> Information 0
>>>
>>
> allaire.jrun.servlet.JRunRequestDispatcher.forward(JRunRequestDispatcher.java:89)
>
>>>05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>>
>>
>>
>>> Information 0
>>>
>>
> allaire.jrun.servlet.JRunSE.service(JRunSE.java:1557)
>
>>>05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>>
>>
>>
>>> Information 0
>>>
>>
> allaire.jrun.servlet.JRunSE.service(JRunSE.java:1547)
>
>>>05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>>
>>
>>
>>> Information 0
>>>
>>
> allaire.jrun.servlet.JvmContext.dispatch(JvmContext.java:364)
>
>>>05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>>
>>
>>
>>> Information 0
>>>
>>
> allaire.jrun.jrpp.ProxyEndpoint.run(ProxyEndpoint.java:388)
>
>>>05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>>
>>
>>
>>> Information 0
>>>allaire.jrun.ThreadPool.run(ThreadPool.java:272)
>>>05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>>
>>
>>
>>> Information 0
>>>
>>
>>allaire.jrun.WorkerThread.run(WorkerThread.java:75)
>>
>>>05/04/2004 06:03:06 PM
>>>/temp/frmTestConnectionPool.jsp Error 0
>>
>>
>>
>>> Testing 7
>>>
>>>
>>>
>>>THANKS very much--
>>>RAJ
>>>
>>>
>>>
>>>
>>>__________________________________
>>>Do you Yahoo!?
>>>Win a $20,000 Career Makeover at Yahoo! HotJobs
>>>
>>
>>http://hotjobs.sweepstakes.yahoo.com/careermakeover
>>
>>>
> ---------------------------------------------------------------------
>
>>>To unsubscribe, e-mail:
>>
>>commons-user-unsubscribe@jakarta.apache.org
>>
>>>For additional commands, e-mail:
>>
>>commons-user-help@jakarta.apache.org
>>
>>>
>>>
>>
>>
>>
> ---------------------------------------------------------------------
>
>>To unsubscribe, e-mail:
>>commons-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail:
>>commons-user-help@jakarta.apache.org
>>
>
>
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Win a $20,000 Career Makeover at Yahoo! HotJobs
> http://hotjobs.sweepstakes.yahoo.com/careermakeover
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org
Re: DBCP POOL -Connection Pool giving nullpointer -->Unable to intialize -->Crashing
Posted by raj <ra...@yahoo.com>.
We are using commons-pool-1.1.jar and
commons-dbcp-1.1.jar
Do you think I have to change MAX Active to some more
number like 300 or some thing and add
MAXIdle
MInIdle
WHEN_EXHAUSTED_GROW
and also
connectionPool.setNumTestsPerEvictionRun(20);
connectionPool.setMinEvictableIdleTimeMillis(600000);
connectionPool.setTimeBetweenEvictionRunsMillis(10000);
// 10 sec
Please let me know...
Here are the files..
this jsp calls DBConnection which inturn call
datasourcefactory function to initialize connection.
frmTestConnectionPool.jsp START
**********-----------
<%@ page import="java.sql.*" %>
<%@ page import="javax.naming.*" %>
<%@ page import="javax.sql.*" %>
<%@ page import="***.***.***.jdbc.*" %>
<%@ page import="***.***.***.DBConnection" %>
<%@ page
import="org.apache.commons.dbcp.PoolingDataSource" %>
<%@ page
import="org.apache.commons.dbcp.PoolingDriver" %>
<%@ page import="org.apache.commons.pool.ObjectPool"
%>
<title>Support: Connection Pool</title>
<% try {
// start Application
applicationStart( globalContext, log, literal,
profiler);
} catch (Exception e) {
logger.writeError(e.toString());
}
%>
<br><br>
<table cellSpacing="0" cellPadding="0" border="0">
<tbody>
<tr>
<td>
<table border="0" cellpadding="2" cellspacing="0">
<tr><td><font class="pageheader"> Connection
Pooling Test</td></tr>
</table>
</td>
</tr>
<tr>
<td valign="top" align="left" width="533"
class="largebody">
<table border="0" cellpadding="2" cellspacing="0">
<tr><td><img src="/images/2.0/main.jpg" width="533"
height="150"></td></tr>
<tr><td> </td></tr>
</table>
<%-- Begin body content --%>
<%
DBConnection objCase = null;
ResultSet objCaseRs = null;
try {
objCase = new DBConnection();
int id = 0;
objCaseRs = objCase.executeQuery("select count(*)
from sw_case");
if(objCaseRs != null) {
if(objCaseRs.next()){
id = objCaseRs.getInt(1);
%>
<%="CASE COUNT: " + id %>
<%
}
}
}
catch (Exception e) {
StackTraceElement[] st = e.getStackTrace();
StackTraceElement st2 = null;
log.addEntry(" frmTestConnectionPool.jsp ",
Log.LOG_SEVERITY_ERROR, e.toString());
for(int i=0; i< st.length; i++) {
st2 = st[i];
log.addEntry(" frmTestConnectionPool.jsp ",
st2.toString());
}
throw e;
} finally {
objCase.closeAllIgnoreExceptions();
}
%>
<%-- End body content --%>
</td>
<td width="20"><img height=3 alt=""
src="/images/2.0/px_transparent.gif" width=20
border=0></td>
<td width=162 align=left valign="top">
<%@include file="/include/promos/incExtPromos.jsp"%>
</td>
</tr>
<tr><td colspan="3" height="1"
valign="top"> </td></tr>
<tr><td colspan="3" height="1" valign="top"><spacer
type="block" width="1" height="1"/></td></tr>
<tr><td colspan="3" height="4"><img
src="/images/2.0/clearpixel.gif" width="1"
height="4"></td></tr>
</table>
<%@ include file="/include/layout/endLayout.jsp" %>
****** frmTestConnectionPool.jsp END -----
***** DBConnection setup ----
private void setupEnvironment() throws Exception {
context = new InitialContext();
ds =
***.***.****.jdbc.DataSourceFactory.getDataSource();
con = ds.getConnection();
}
*******-----
DATASOURCEFACTORY java
public class DataSourceFactory {
private static DataSource ds = null;
public static synchronized DataSource
getDataSource() {
if (ds == null) {
setup();
}
return ds;
}
static void setup() {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
} catch (ClassNotFoundException e) {
throw new LoggedError(e);
}
// read defaults from properties file
Properties p =
PropertiesManager.getProperties("jdbc");
String driver =
p.getProperty("**.***.***.jdbc.driver");
String auth =
p.getProperty("**.***.***.jdbc.auth");
String server =
p.getProperty("**.***.***.jdbc.db");
String connectURI = driver + ":" + auth + "@"
+ server;
// setup data source
ds = setupDataSource(connectURI);
}
private static DataSource setupDataSource(String
connectURI) {
String testStr = "SELECT COUNT(*) FROM DUAL";
GenericObjectPool connectionPool = new
GenericObjectPool(null);
ConnectionFactory connectionFactory = new
DriverManagerConnectionFactory(connectURI,null);
new
PoolableConnectionFactory(connectionFactory,connectionPool,null,testStr,false,true);
// set up pool options
connectionPool.setTestOnBorrow(true);
connectionPool.setTestOnReturn(true);
connectionPool.setMaxActive(50);
connectionPool.setWhenExhaustedAction(connectionPool.WHEN_EXHAUSTED_FAIL);
PoolingDataSource dataSource = new
PoolingDataSource(connectionPool);
return dataSource;
}
}
*****************************END DATASOURCEFACTORY
------------
DIrk...Thanks very much for your help in advance.
Regards..RAJ
--- Dirk Verbeeck <di...@pandora.be> wrote:
> DBCP version? (1.0, 1.1, nightly)
>
> Normally you should get a SQLException even when the
> pool is empty.
> Can you post your frmTestConnectionPool.jsp?
>
> -- Dirk
>
> raj wrote:
>
> > Hello,
> > We have been using jakarta pool implementation
> with
> > JRUN for past 6 months and worked fine until last
> > week.
> > Started giving this error.
> >
> > Works fine for couple of hours and starts crashing
> and
> > had to restart JRUN every time.
> >
> > Explanation from our admin -->
> > Load on database causing delay in getting
> connection
> > from connection pool which is becoming stale after
> > trying to get connection for long time.
> > I did not like this explanation as nothing changed
> and
> > started suddenly.
> > ANY HELP WILL BE REALLY APPRECIATED and THANKS FOR
> > YOUR TIME.
> >
> > These are the parameters for connection pool
>
> > GenericObjectPool connectionPool = new
> > GenericObjectPool(null);
> > ConnectionFactory connectionFactory = new
> > DriverManagerConnectionFactory(connectURI,null);
> > new
> >
>
PoolableConnectionFactory(connectionFactory,connectionPool,null,testStr,false,true);
> >
> > // set up pool options
> >
> >
> > connectionPool.setTestOnBorrow(true);
> > connectionPool.setTestOnReturn(true);
> > connectionPool.setMaxActive(50);
> >
> >
>
connectionPool.setWhenExhaustedAction(connectionPool.WHEN_EXHAUSTED_FAIL);
> >
> > PoolingDataSource dataSource = new
> > PoolingDataSource(connectionPool);
> >
> > --> This is stacktrace from the JSP -->
> >
> >
> > 05/04/2004 06:03:06 PM
> > /temp/frmTestConnectionPool.jsp Error 0
>
> > Testing
> > 05/04/2004 06:03:06 PM
> > /temp/frmTestConnectionPool.jsp Error 0
>
> > Testing 2
> > 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> > Error 0
> > java.lang.NullPointerException
> > 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> > Information 0
> >
>
com.nokia.support.DBConnection.printStackTraceToLog(DBConnection.java:925)
> > 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> > Information 0
> >
>
com.nokia.support.DBConnection.<init>(DBConnection.java:349)
> > ----->
> > 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> > Information 0
> >
>
jrun__temp__frmTestConnectionPool2ejsp1f._jspService(jrun__temp__frmTestConnectionPool2ejsp1f.java:807)
> > 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> > Information 0
> >
>
allaire.jrun.jsp.HttpJSPServlet.service(HttpJSPServlet.java:39)
> > 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> > Information 0
> >
>
allaire.jrun.jsp.JSPServlet.service(JSPServlet.java:228)
> > 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> > Information 0
> >
>
allaire.jrun.jsp.JSPServlet.service(JSPServlet.java:196)
> > 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> > Information 0
> >
>
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1417)
> > 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> > Information 0
> >
>
allaire.jrun.session.JRunSessionService.service(JRunSessionService.java:1088)
> > 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> > Information 0
> >
>
allaire.jrun.servlet.JRunSE.runServlet(JRunSE.java:1271)
> > 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> > Information 0
> >
>
allaire.jrun.servlet.JRunRequestDispatcher.forward(JRunRequestDispatcher.java:89)
> > 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> > Information 0
> >
>
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1557)
> > 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> > Information 0
> >
>
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1547)
> > 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> > Information 0
> >
>
allaire.jrun.servlet.JvmContext.dispatch(JvmContext.java:364)
> > 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> > Information 0
> >
>
allaire.jrun.jrpp.ProxyEndpoint.run(ProxyEndpoint.java:388)
> > 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> > Information 0
> > allaire.jrun.ThreadPool.run(ThreadPool.java:272)
> > 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> > Information 0
> >
> allaire.jrun.WorkerThread.run(WorkerThread.java:75)
> > 05/04/2004 06:03:06 PM
> > /temp/frmTestConnectionPool.jsp Error 0
>
> > Testing 7
> >
> >
> >
> > THANKS very much--
> > RAJ
> >
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Win a $20,000 Career Makeover at Yahoo! HotJobs
> >
> http://hotjobs.sweepstakes.yahoo.com/careermakeover
> >
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> commons-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail:
> commons-user-help@jakarta.apache.org
> >
> >
> >
>
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> commons-user-help@jakarta.apache.org
>
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org
Re: DBCP POOL -Connection Pool giving nullpointer -->Unable to intialize
-->Crashing
Posted by Dirk Verbeeck <di...@pandora.be>.
DBCP version? (1.0, 1.1, nightly)
Normally you should get a SQLException even when the pool is empty.
Can you post your frmTestConnectionPool.jsp?
-- Dirk
raj wrote:
> Hello,
> We have been using jakarta pool implementation with
> JRUN for past 6 months and worked fine until last
> week.
> Started giving this error.
>
> Works fine for couple of hours and starts crashing and
> had to restart JRUN every time.
>
> Explanation from our admin -->
> Load on database causing delay in getting connection
> from connection pool which is becoming stale after
> trying to get connection for long time.
> I did not like this explanation as nothing changed and
> started suddenly.
> ANY HELP WILL BE REALLY APPRECIATED and THANKS FOR
> YOUR TIME.
>
> These are the parameters for connection pool
> GenericObjectPool connectionPool = new
> GenericObjectPool(null);
> ConnectionFactory connectionFactory = new
> DriverManagerConnectionFactory(connectURI,null);
> new
> PoolableConnectionFactory(connectionFactory,connectionPool,null,testStr,false,true);
>
> // set up pool options
>
>
> connectionPool.setTestOnBorrow(true);
> connectionPool.setTestOnReturn(true);
> connectionPool.setMaxActive(50);
>
> connectionPool.setWhenExhaustedAction(connectionPool.WHEN_EXHAUSTED_FAIL);
>
> PoolingDataSource dataSource = new
> PoolingDataSource(connectionPool);
>
> --> This is stacktrace from the JSP -->
>
>
> 05/04/2004 06:03:06 PM
> /temp/frmTestConnectionPool.jsp Error 0
> Testing
> 05/04/2004 06:03:06 PM
> /temp/frmTestConnectionPool.jsp Error 0
> Testing 2
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
> Error 0
> java.lang.NullPointerException
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
> Information 0
> com.nokia.support.DBConnection.printStackTraceToLog(DBConnection.java:925)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
> Information 0
> com.nokia.support.DBConnection.<init>(DBConnection.java:349)
> ----->
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
> Information 0
> jrun__temp__frmTestConnectionPool2ejsp1f._jspService(jrun__temp__frmTestConnectionPool2ejsp1f.java:807)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
> Information 0
> allaire.jrun.jsp.HttpJSPServlet.service(HttpJSPServlet.java:39)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
> Information 0
> allaire.jrun.jsp.JSPServlet.service(JSPServlet.java:228)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
> Information 0
> allaire.jrun.jsp.JSPServlet.service(JSPServlet.java:196)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
> Information 0
> allaire.jrun.servlet.JRunSE.service(JRunSE.java:1417)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
> Information 0
> allaire.jrun.session.JRunSessionService.service(JRunSessionService.java:1088)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
> Information 0
> allaire.jrun.servlet.JRunSE.runServlet(JRunSE.java:1271)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
> Information 0
> allaire.jrun.servlet.JRunRequestDispatcher.forward(JRunRequestDispatcher.java:89)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
> Information 0
> allaire.jrun.servlet.JRunSE.service(JRunSE.java:1557)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
> Information 0
> allaire.jrun.servlet.JRunSE.service(JRunSE.java:1547)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
> Information 0
> allaire.jrun.servlet.JvmContext.dispatch(JvmContext.java:364)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
> Information 0
> allaire.jrun.jrpp.ProxyEndpoint.run(ProxyEndpoint.java:388)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
> Information 0
> allaire.jrun.ThreadPool.run(ThreadPool.java:272)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
> Information 0
> allaire.jrun.WorkerThread.run(WorkerThread.java:75)
> 05/04/2004 06:03:06 PM
> /temp/frmTestConnectionPool.jsp Error 0
> Testing 7
>
>
>
> THANKS very much--
> RAJ
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Win a $20,000 Career Makeover at Yahoo! HotJobs
> http://hotjobs.sweepstakes.yahoo.com/careermakeover
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org
Re: R: DBCP POOL -Connection Pool giving nullpointer -->Unable to intialize -->Crashing
Posted by raj <ra...@yahoo.com>.
We are using Oracle DB8.1.3 and server is Iplanet 4.1
service pack5 and Jrun 3.1
Thanks..
--- daniele rizzi <da...@essellesse.net>
wrote:
>
> HI raj,
> may I ask you what db server are you using?
>
> bye
> daniele rizzi
>
>
> -----Messaggio originale-----
> Da: raj [mailto:rajshiri@yahoo.com]
> Inviato: mercoledi 5 maggio 2004 7.54
> A: Jakarta Commons Users List
> Oggetto: DBCP POOL -Connection Pool giving
> nullpointer -->Unable to
> intialize -->Crashing
>
>
> Hello,
> We have been using jakarta pool implementation with
> JRUN for past 6 months and worked fine until last
> week.
> Started giving this error.
>
> Works fine for couple of hours and starts crashing
> and
> had to restart JRUN every time.
>
> Explanation from our admin -->
> Load on database causing delay in getting connection
> from connection pool which is becoming stale after
> trying to get connection for long time.
> I did not like this explanation as nothing changed
> and
> started suddenly.
> ANY HELP WILL BE REALLY APPRECIATED and THANKS FOR
> YOUR TIME.
>
> These are the parameters for connection pool
> GenericObjectPool connectionPool = new
> GenericObjectPool(null);
> ConnectionFactory connectionFactory = new
> DriverManagerConnectionFactory(connectURI,null);
> new
>
PoolableConnectionFactory(connectionFactory,connectionPool,null,testStr,false,true);
>
> // set up pool options
>
>
> connectionPool.setTestOnBorrow(true);
> connectionPool.setTestOnReturn(true);
> connectionPool.setMaxActive(50);
>
>
connectionPool.setWhenExhaustedAction(connectionPool.WHEN_EXHAUSTED_FAIL);
>
> PoolingDataSource dataSource = new
> PoolingDataSource(connectionPool);
>
> --> This is stacktrace from the JSP -->
>
>
> 05/04/2004 06:03:06 PM
> /temp/frmTestConnectionPool.jsp Error 0
>
> Testing
> 05/04/2004 06:03:06 PM
> /temp/frmTestConnectionPool.jsp Error 0
>
> Testing 2
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> Error 0
> java.lang.NullPointerException
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> Information 0
>
com.nokia.support.DBConnection.printStackTraceToLog(DBConnection.java:925)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> Information 0
>
com.nokia.support.DBConnection.<init>(DBConnection.java:349)
> ----->
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> Information 0
>
jrun__temp__frmTestConnectionPool2ejsp1f._jspService(jrun__temp__frmTestConnectionPool2ejsp1f.java:807)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> Information 0
>
allaire.jrun.jsp.HttpJSPServlet.service(HttpJSPServlet.java:39)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> Information 0
>
allaire.jrun.jsp.JSPServlet.service(JSPServlet.java:228)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> Information 0
>
allaire.jrun.jsp.JSPServlet.service(JSPServlet.java:196)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> Information 0
>
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1417)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> Information 0
>
allaire.jrun.session.JRunSessionService.service(JRunSessionService.java:1088)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> Information 0
>
allaire.jrun.servlet.JRunSE.runServlet(JRunSE.java:1271)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> Information 0
>
allaire.jrun.servlet.JRunRequestDispatcher.forward(JRunRequestDispatcher.java:89)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> Information 0
>
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1557)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> Information 0
>
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1547)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> Information 0
>
allaire.jrun.servlet.JvmContext.dispatch(JvmContext.java:364)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> Information 0
>
allaire.jrun.jrpp.ProxyEndpoint.run(ProxyEndpoint.java:388)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> Information 0
> allaire.jrun.ThreadPool.run(ThreadPool.java:272)
> 05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
>
> Information 0
> allaire.jrun.WorkerThread.run(WorkerThread.java:75)
> 05/04/2004 06:03:06 PM
> /temp/frmTestConnectionPool.jsp Error 0
>
> Testing 7
>
>
>
> THANKS very much--
> RAJ
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Win a $20,000 Career Makeover at Yahoo! HotJobs
> http://hotjobs.sweepstakes.yahoo.com/careermakeover
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail:
> commons-user-help@jakarta.apache.org
>
>
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org
R: DBCP POOL -Connection Pool giving nullpointer -->Unable to intialize -->Crashing
Posted by daniele rizzi <da...@essellesse.net>.
HI raj,
may I ask you what db server are you using?
bye
daniele rizzi
-----Messaggio originale-----
Da: raj [mailto:rajshiri@yahoo.com]
Inviato: mercoledi 5 maggio 2004 7.54
A: Jakarta Commons Users List
Oggetto: DBCP POOL -Connection Pool giving nullpointer -->Unable to
intialize -->Crashing
Hello,
We have been using jakarta pool implementation with
JRUN for past 6 months and worked fine until last
week.
Started giving this error.
Works fine for couple of hours and starts crashing and
had to restart JRUN every time.
Explanation from our admin -->
Load on database causing delay in getting connection
from connection pool which is becoming stale after
trying to get connection for long time.
I did not like this explanation as nothing changed and
started suddenly.
ANY HELP WILL BE REALLY APPRECIATED and THANKS FOR
YOUR TIME.
These are the parameters for connection pool
GenericObjectPool connectionPool = new
GenericObjectPool(null);
ConnectionFactory connectionFactory = new
DriverManagerConnectionFactory(connectURI,null);
new
PoolableConnectionFactory(connectionFactory,connectionPool,null,testStr,false,true);
// set up pool options
connectionPool.setTestOnBorrow(true);
connectionPool.setTestOnReturn(true);
connectionPool.setMaxActive(50);
connectionPool.setWhenExhaustedAction(connectionPool.WHEN_EXHAUSTED_FAIL);
PoolingDataSource dataSource = new
PoolingDataSource(connectionPool);
--> This is stacktrace from the JSP -->
05/04/2004 06:03:06 PM
/temp/frmTestConnectionPool.jsp Error 0
Testing
05/04/2004 06:03:06 PM
/temp/frmTestConnectionPool.jsp Error 0
Testing 2
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Error 0
java.lang.NullPointerException
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
com.nokia.support.DBConnection.printStackTraceToLog(DBConnection.java:925)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
com.nokia.support.DBConnection.<init>(DBConnection.java:349)
----->
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
jrun__temp__frmTestConnectionPool2ejsp1f._jspService(jrun__temp__frmTestConnectionPool2ejsp1f.java:807)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.jsp.HttpJSPServlet.service(HttpJSPServlet.java:39)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.jsp.JSPServlet.service(JSPServlet.java:228)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.jsp.JSPServlet.service(JSPServlet.java:196)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1417)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.session.JRunSessionService.service(JRunSessionService.java:1088)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.servlet.JRunSE.runServlet(JRunSE.java:1271)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.servlet.JRunRequestDispatcher.forward(JRunRequestDispatcher.java:89)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1557)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1547)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.servlet.JvmContext.dispatch(JvmContext.java:364)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.jrpp.ProxyEndpoint.run(ProxyEndpoint.java:388)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.ThreadPool.run(ThreadPool.java:272)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.WorkerThread.run(WorkerThread.java:75)
05/04/2004 06:03:06 PM
/temp/frmTestConnectionPool.jsp Error 0
Testing 7
THANKS very much--
RAJ
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org
DBCP POOL -Connection Pool giving nullpointer -->Unable to intialize -->Crashing
Posted by raj <ra...@yahoo.com>.
Hello,
We have been using jakarta pool implementation with
JRUN for past 6 months and worked fine until last
week.
Started giving this error.
Works fine for couple of hours and starts crashing and
had to restart JRUN every time.
Explanation from our admin -->
Load on database causing delay in getting connection
from connection pool which is becoming stale after
trying to get connection for long time.
I did not like this explanation as nothing changed and
started suddenly.
ANY HELP WILL BE REALLY APPRECIATED and THANKS FOR
YOUR TIME.
These are the parameters for connection pool
GenericObjectPool connectionPool = new
GenericObjectPool(null);
ConnectionFactory connectionFactory = new
DriverManagerConnectionFactory(connectURI,null);
new
PoolableConnectionFactory(connectionFactory,connectionPool,null,testStr,false,true);
// set up pool options
connectionPool.setTestOnBorrow(true);
connectionPool.setTestOnReturn(true);
connectionPool.setMaxActive(50);
connectionPool.setWhenExhaustedAction(connectionPool.WHEN_EXHAUSTED_FAIL);
PoolingDataSource dataSource = new
PoolingDataSource(connectionPool);
--> This is stacktrace from the JSP -->
05/04/2004 06:03:06 PM
/temp/frmTestConnectionPool.jsp Error 0
Testing
05/04/2004 06:03:06 PM
/temp/frmTestConnectionPool.jsp Error 0
Testing 2
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Error 0
java.lang.NullPointerException
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
com.nokia.support.DBConnection.printStackTraceToLog(DBConnection.java:925)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
com.nokia.support.DBConnection.<init>(DBConnection.java:349)
----->
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
jrun__temp__frmTestConnectionPool2ejsp1f._jspService(jrun__temp__frmTestConnectionPool2ejsp1f.java:807)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.jsp.HttpJSPServlet.service(HttpJSPServlet.java:39)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.jsp.JSPServlet.service(JSPServlet.java:228)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.jsp.JSPServlet.service(JSPServlet.java:196)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1417)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.session.JRunSessionService.service(JRunSessionService.java:1088)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.servlet.JRunSE.runServlet(JRunSE.java:1271)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.servlet.JRunRequestDispatcher.forward(JRunRequestDispatcher.java:89)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1557)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.servlet.JRunSE.service(JRunSE.java:1547)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.servlet.JvmContext.dispatch(JvmContext.java:364)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.jrpp.ProxyEndpoint.run(ProxyEndpoint.java:388)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.ThreadPool.run(ThreadPool.java:272)
05/04/2004 06:03:06 PM frmTestConnectionPool.jsp
Information 0
allaire.jrun.WorkerThread.run(WorkerThread.java:75)
05/04/2004 06:03:06 PM
/temp/frmTestConnectionPool.jsp Error 0
Testing 7
THANKS very much--
RAJ
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs
http://hotjobs.sweepstakes.yahoo.com/careermakeover
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org
Re: Database Connection Pooling help needed
Posted by Dirk Verbeeck <di...@pandora.be>.
DBCP - http://jakarta.apache.org/commons/dbcp/
is a database connection pool component.
AltRMI - http://incubator.apache.org/projects/altrmi/
can help you writing the RMI layer
or go for a SOAP based remove invoke system
http://ws.apache.org/axis/
-- Dirk
Deepak Vishwanathan wrote:
> Hi everyone,
>
> The scenario is like I want to write a class that can be remotely
> invoked using JMS / RMI technology. This class will be solely responsible
> for fetching the data from the database, with connection pooling
> capabilities.
>
> Any component that needs data from the database connects to the above
> mentioned class.
>
> If I were to write such a Java class (component), is there any popular
> open source project package designed specifically to facilitate such a
> class.
>
> The constraint is that package should be free for redistribution.
>
> The application is an enterprise application.
>
> Thanks
> Deepak
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-user-help@jakarta.apache.org