Sure I will
For time being I used DBCP.
Anjib
On 12/8/2010 12:54 PM, adam pinder wrote:
Anjib,
i'd certainly take a look at hibernate, i've been using it for a while now and
find it easy enough and functionally rich enough for most things.
adam
Date: Tue, 7 Dec 2010 14:36:01 -0500
From:
Anjib,
i'd certainly take a look at hibernate, i've been using it for a while now and
find it easy enough and functionally rich enough for most things.
adam
> Date: Tue, 7 Dec 2010 14:36:01 -0500
> From: [email protected]
> To: [email protected]
> Subject: Connection Pooling with
ate: Tue, 7 Dec 2010 16:19:48 -0600
> Subject: Re: Connection Pooling with Struts
> From: [email protected]
> To: [email protected]
>
> Dude, I can't sit quietly any longer! How you connect to a database has
> NOTHING WHATSOEVER to do with the Struts/2 Framework. I woul
Then you should be asking on the appropriate list.
http://www.catb.org/~esr/faqs/smart-questions.html#forum
On Tue, Dec 7, 2010 at 6:15 PM, Anjib wrote:
>
> Dude
> I am asking about ORM tool not Struts framework itself.
>
> Please see the reply from Johannes.
>
> Thanks
> Anjib
>
>
> On 12/7/2
On Tue, Dec 7, 2010 at 6:15 PM, Anjib wrote:
> I am asking about ORM tool not Struts framework itself.
>
I think the point was more along the lines of "why are you asking here,"
since you're not asking about the Struts framework.
Dave
Dude
I am asking about ORM tool not Struts framework itself.
Please see the reply from Johannes.
Thanks
Anjib
On 12/7/2010 5:19 PM, [email protected] wrote:
Dude, I can't sit quietly any longer! How you connect to a database has
NOTHING WHATSOEVER to do with the Struts/2 Framework. I woul
Dude, I can't sit quietly any longer! How you connect to a database has
NOTHING WHATSOEVER to do with the Struts/2 Framework. I would advise you to
keep the two separated in your mind. Much like you wouldn't look to a
Database connection to serve a web page, neither should you look to Struts/2
a
So I can use this DBCP Componenet instead of framework?
Anjib
E.g -. http://commons.apache.org/dbcp/
On Tue, Dec 7, 2010 at 4:27 PM, Dave Newton wrote:
A connection pooling library?
On Tue, Dec 7, 2010 at 4:25 PM, Anjib Mulepati
wrote:
Ok now I get confuse. I was thinking simple JDBC can'
E.g -. http://commons.apache.org/dbcp/
On Tue, Dec 7, 2010 at 4:27 PM, Dave Newton wrote:
> A connection pooling library?
>
> On Tue, Dec 7, 2010 at 4:25 PM, Anjib Mulepati
> wrote:
>
> > Ok now I get confuse. I was thinking simple JDBC can't (or complex to )
> > handle connection pooling. So
A connection pooling library?
On Tue, Dec 7, 2010 at 4:25 PM, Anjib Mulepati wrote:
> Ok now I get confuse. I was thinking simple JDBC can't (or complex to )
> handle connection pooling. So framework make work easy. If framework is not
> used what are other alternatives to handle connection poo
Ok now I get confuse. I was thinking simple JDBC can't (or complex to )
handle connection pooling. So framework make work easy. If framework is
not used what are other alternatives to handle connection pooling beside
JDBC itself?
Anjib
On 12/7/2010 4:20 PM, Arthur Neves wrote:
Nop,
You don
Is the question about connection pooling, as the subject line indicates, or
is the question about generic DB handling and JDBC v. ORMs?
Dave
On Tue, Dec 7, 2010 at 4:20 PM, Arthur Neves wrote:
> Nop,
>
> You dont need using a framework... if you pick one just will make your life
> easier!
> If
Nop,
You dont need using a framework... if you pick one just will make your life
easier!
If you`re starting a new project I`d get one framework, however if the
project it`s already ready, just keep doing in the same way!
On Tue, Dec 7, 2010 at 3:36 PM, Anjib Mulepati wrote:
> I was thinking for
I was thinking for Hibernate.
So only way for struts is use one of these framework?
Anjib
On 12/7/2010 3:26 PM, Johannes Geppert wrote:
in java you have the choose which way is the best for your project to handle
databases.
there exists several frameworks for this job like hibernate, myBatis,
in java you have the choose which way is the best for your project to handle
databases.
there exists several frameworks for this job like hibernate, myBatis, spring
jdbc tempalate, ... .
google for it and look which framework is the best for your project.
Johannes
anjibman wrote:
>
> I have t
That won't use the pool.
Take a look at some of the code snippets at [1]
Nils-H
[1] -
http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html
On Mon, Dec 1, 2008 at 8:09 AM, Adam Ruggles <[EMAIL PROTECTED]> wrote:
>
> You can use this little snippet to get a connection:
>
>
You can use this little snippet to get a connection:
public Connection getConnection(String url, String driverClassName,
String
username, String password) throws SQLException {
try {
Class.forName(driverClassName);
} catch (ClassNot
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jasdeep,
jasdeep wrote:
> Yes this is peek load actually .. The requests are through SMS's which
> is forwarded by kannel server to my application . actually we are in
> development phase and we are testing it as per client specifications.
>
> So thi
Hi Christropher ..
Yes this is peek load actualy ..
The requests are through SMS's which is forwarded by kannel server to my
application .
actually we are in development phase and we are testing it as per client
specifications.
So this was the load client specified ...
i had s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jasdeep,
jasdeep wrote:
> 2. Configuring Jboss's Internal Container Level Connection pooling simply
> creating the datasources
This is the right way to do things.
> The application works OK with Second method but When it is being hit with
> 200 r
Hi,
Struts way (not good)
Connection pooling is not available in latest version of struts
1 and
struts 2. So if you upgrade your application to latest struts
then you
will be in trouble.
Server (JNDI) very good
All application servers provide it
e-
> From: Mon Cab [mailto:[EMAIL PROTECTED]
> Sent: Thursday, March 01, 2007 12:35 PM
> To: Struts Users Mailing List
> Subject: RE: Connection, pool exhausted error
>
>
> I thought that closing the connection was unnecessary when using a
> connection pool. I was under
event is fired which will actually return the database
connection to the pool.
-Original Message-
From: Mon Cab [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 01, 2007 12:35 PM
To: Struts Users Mailing List
Subject: RE: Connection, pool exhausted error
I thought that closing the
I thought that closing the connection was unnecessary when using a
connection pool. I was under the impression that one would just close
the context, which would return the connectin to the connection pool.
Is this not the case?
--- "Kalra, Ashwani" <[EMAIL PROTECTED]> wrote:
>
> Where are
Where are you closing the connection?
-Original Message-
From: Mon Cab [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 01, 2007 12:23 PM
To: Struts User Group
Subject: Connection, pool exhausted error
I am getting a connection, pool exhausted error, in the action class
below.
The
Rauf Khan ha scritto:
java.lang.NoClassDefFoundError:
org/apache/commons/pool/impl/GenericObjectPool
You need Jakarta Commons Pool:
http://jakarta.apache.org/commons/pool/
Anyway notice that Struts DataSource support has been removed since 1.2
version (correct me if I am wrong), so you probab
That sounds like you are closing the stable door after the horse has bolted.
Why not wrap a _try_ and _finally_ block around the code areas that
create/open connections to prevent this?
Connections are a strange fruit and should always be closed; otherwise your
app could run out of memory not ju
Shailender
You can configure your connection pool to close resources after a period of
time with the following options:
GenericObjectPool genericObjectPool = new GenericObjectPool(null);
genericObjectPool.setMaxActive(value);
genericObjectPool.setMaxIdle(value);
genericObjectPool.setMaxWait(value
Uma,
Do you make a new pool for every request? That takes up a lot of resources.
Are you positive you are shutting down the pool and the connection when you
are done with them? Ideally, you setup your pool once, store it in serlet
or application context, then use that on instance to hand you off
On Wed, 19 Jan 2005 16:43:25 +0530, Kalluru Uma. Maheswar
<[EMAIL PROTECTED]> wrote:
> Hi,
> I am looking for an example using org.apache.commons.dbcp.BasicDataSource and
> more over, I cant use a .war file to deploy my app (there are some problems)
If I understand you right, you need to set up y
PROTECTED]
> Inviato: mercoledì 19 gennaio 2005 11.42
> A: Struts Users Mailing List
> Oggetto: Re: Connection Pool best practice
>
>
> Kalluru Uma. Maheswar wrote:
>
> >Hi,
> >
> >I am using org.apache.commons.dbcp.BasicDataSource to implement a
> >co
-
From: Pavel Kolesnikov [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 19, 2005 4:12 PM
To: Struts Users Mailing List
Subject: Re: Connection Pool best practice
On Wed, 19 Jan 2005 15:52:20 +0530, Kalluru Uma. Maheswar
<[EMAIL PROTECTED]> wrote:
> And in the classes where I need
On Wed, 19 Jan 2005 15:52:20 +0530, Kalluru Uma. Maheswar
<[EMAIL PROTECTED]> wrote:
> And in the classes where I need database connection, I am saying
>
> DBPool dbPool = new DBPool();
>
> dbPool.getDataSource();
>
> By doing this, my application is getting slower. Initially I configured
> db
Kalluru Uma. Maheswar wrote:
Hi,
I am using org.apache.commons.dbcp.BasicDataSource to implement a
connection pooling and this is my class.
If you're using Tomcat, you're better-off using JNDI Datasource:
http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html#Databas
Tomcat can provide a connection pool, you just have to configure the
pool and look up the resource in your application. The details can be
found here :
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/jndi-datasource-examples-howto.html
Tushar Agrawal wrote:
Hi Freinds,
I am using struts-config d
Hibernate (it has a Struts plugIn) can set those up automatically for you
and connect to both using the same API.
http://www.hibernate.org
Regards,
David
-Original Message-
From: Tushar Agrawal [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 04, 2004 11:08 PM
To: Struts Mailing List
Su
I have 4 excellent questions for you, of which #1 could be of EXTREME
importance to you...
1. Have you changed your password YET since you posted all of your JDBC
oracle details in the below message?
2. Have you logged into your Oracle database on the host chd4.sbc.com and
verified that the conne
> -Original Message-
> From: Jignesh Patel [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 17, 2004 7:18 AM
> To: Struts Users Mailing List
> Subject: RE: connection pooling
>
>
> Suppose I will put following code in my struts-config.xml instead of
> tomca
nal Message-
> > From: Saurabh Bhatla [mailto:[EMAIL PROTECTED]
> > Sent: Monday, August 16, 2004 3:16 PM
> > To: Struts Users Mailing List
> > Subject: RE: connection pooling
> >
> >
> > Jim,
> > I understand most part of it now. the only thing th
I can say, this is purely a connection closing problem.
That's the reason when you restart the tomcat it works fine till the
time all the connection in the connection pool utilize and then after it
hangs.
Are u closing your connection in finally block?
-Jignesh
On Mon, 2004-08-16 at 02:14, Rajes
> -Original Message-
> From: Saurabh Bhatla [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 16, 2004 3:16 PM
> To: Struts Users Mailing List
> Subject: RE: connection pooling
>
>
> Jim,
> I understand most part of it now. the only thing that i dont
&
:45, Jim Barrows wrote:
> > -Original Message-
> > From: Saurabh Bhatla [mailto:[EMAIL PROTECTED]
> > Sent: Monday, August 16, 2004 2:42 PM
> > To: Struts Users Mailing List
> > Subject: RE: connection pooling
> >
> >
> > Jim,
> >I a
,
org.apache.struts.webapp.example.memory.MemoryDatabasePlugIn.java for
more details.
Regards,
Sridhar
-Original Message-
From: Saurabh Bhatla [mailto:[EMAIL PROTECTED]
Sent: Monday, August 16, 2004 2:24 PM
To: Struts Users Mailing List
Subject: Re: connection pooling
David,
But i want to make a business layer and call the DAO from there. I
yeah, I am planning to use OJB for persistence. Thankx for your advice.
regards
saurabh
On Mon, 2004-08-16 at 16:43, David Durham wrote:
> Jim Barrows wrote:
>
> > Ah, okay.. I also posted a link to the struts way to do the JNDI data
> > source stuff in that case.. you follow your web app s
> -Original Message-
> From: Saurabh Bhatla [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 16, 2004 2:42 PM
> To: Struts Users Mailing List
> Subject: RE: connection pooling
>
>
> Jim,
>I am sorry but I am confused now. Just correct me if I am
> w
Jim Barrows wrote:
Ah, okay.. I also posted a link to the struts way to do the JNDI data
source stuff in that case.. you follow your web app servers guide
on how to setup a data source, then you follow the destructions for a
normal jndi data source. Something like:
Additionally, Saurabh, hav
PM
> > To: Struts Users Mailing List
> > Subject: Re: connection pooling
> >
> >
> > David,
> > But i want to make a business layer and call the DAO from there. I
> > think that the links that you have sent me couple
> > presentation layer and
> -Original Message-
> From: Saurabh Bhatla [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 16, 2004 2:24 PM
> To: Struts Users Mailing List
> Subject: Re: connection pooling
>
>
> David,
> But i want to make a business layer and call the DAO from there
David,
But i want to make a business layer and call the DAO from there. I
think that the links that you have sent me couple presentation layer and
database tightly. I know i can use EJB for presentation layer but I dont
want that as it would be overkill for the small project I am working on.
I w
> -Original Message-
> From: David Durham [mailto:[EMAIL PROTECTED]
> Sent: Monday, August 16, 2004 2:01 PM
> To: Struts Users Mailing List
> Subject: Re: connection pooling
>
>
> Saurabh Bhatla wrote:
>
> > Now i want to
> > know how to initia
David Durham wrote:
I think you want to look at a piece of technology called JNDI.
Here's a link to Tomcat's JNDI Datasource How-To:
http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html
Considering the list topic, I guess I should post this link instead:
http://st
Saurabh Bhatla wrote:
Now i want to
know how to initialize the connection pool object and how to pass that
object to all Action classes.
I think you want to look at a piece of technology called JNDI.
Here's a link to Tomcat's JNDI Datasource How-To:
http://jakarta.apache.org/tomcat/tomcat-5.0-do
Hi Shashank
There are lots of freeware tools available in net like Bugfix...you can
also use JProbe for a better analysis of all the memory and connection
leakages.
regards
Gnanavel M | Accenture India Delivery Center MDC2B |
[EMAIL PROTECTED] | 91.22.5500 3409 Direct Voice | mgnanavel
AIM
Check
http://jakarta.apache.org/commons/dbcp/configuration.html
's abandanded something parameters.
I am not sure about how to apply this to Struts Datasource.
I've just replaced Struts Datasouce with tomcat JNDI datasource with DBCP.
to decouple Struts and DAOs.
Masashi
At 12:55 04/06/09 +0530,
Thanks for your attention.
"Abandand connection management" can you give more details on how to do this.
Masashi Nakane wrote:
> And if you have a chance to try DBCP , Abandand connection management
> function will tell you exactly where the unclosed connections are . You
> will love th
Thanks for the response.
I am using the "getConnection(request)" method to get the connection
and then "connection.close()" to close the connection.
"getConnection()" and "close()" both are in library files provided by struts
(DBCP).
Therefore it is difficult to put the counter in these methods.
And if you have a chance to try DBCP , Abandand connection management
function will tell you exactly where the unclosed connections are . You
will love this.
Masashi
At 23:33 04/06/08 -0700, you wrote:
"And Some other guy says the set the max number of connectons to 1."
Yes this is another
"And Some other guy says the set the max number of connectons to 1."
Yes this is another good way, thank you for bringing that up. I had a
fairly big app that was throwing away connections and when I set the
max connections to 1 it became almost immediately aparent where the
problem was.
Good sug
I'm using Oracle and when I meet that situation,
i check the DB session (v$session) and operate GUI .
When number of DB sessions increase, that is the timing .
And Some other guy says the set the max number of connectons to 1.
hope this help
At 22:49 04/06/08 -0700, you wrote:
This may seem to simp
This may seem to simplistic, but you could do a search for whichever
method you call to open a connection and then do a search for
connection.close() (or whatever you named the variable) and see if the
numbers add up... if they don't, this might help you narrow down which
file the two aren't syncro
If 5 users are simultaneously using
the database connections then you need to create more connections.
Brati Sankar Ghosh
Tata Consultancy Services
Mailto: [EMAIL PROTECTED]
Website: http://www.tcs.com
Lokanath <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/20/2004 10:11 AM
Please re
If your pool max is 4, then you will see 4 and your 5th user will wait
until someone returns their connection to the pool.
Lokanath wrote:
hi all
i have a doubt over connection pooling.When 5 users are using a project in
struts and if i have defined the maximumnumber of connection to 4 .Then how
Depends on your situation.
If the SQL Exceptions are expected (i.e., a trigger could fail) then
yes, you will want to catch that and send the message back to the user.
However, if you are thinking JDBC is the way to go, you really should
use something like iBATIS that hides this kind of stuff fr
ED]>
> Data: Wed, 07 Apr 2004 09:00:16 -0400
> Para: Struts Users Mailing List <[EMAIL PROTECTED]>
> Assunto: Re: Connection Pooling (How i use...)
>
> So, are there implied catches in there for SQLException (I assume there
> are)?
> In the innermost try block, does t
So, are there implied catches in there for SQLException (I assume there
are)?
In the innermost try block, does the catch rethrow the SQLException so that
it cascades to the outer blocks?
Just trying to understand the model.
Dean Hoover
Larry Meadors wrote:
Yes.
You really might want to consi
See this
Connection conn = null;
try{
conn = ds.getConnection();
...whatever you wish to do with conn..
catch(SQLException sqle)
{
action of exception
}
finally{
try{
if(nul != conn) conn.close();
}
catch(SQLException sqle){ action of except
Uhh, yeah, I never did that, no, I just heard about it...yeah, that's
it...
;-)
>>> [EMAIL PROTECTED] 04/06/04 11:45 AM >>>
*Quite* right: there was one time we had set the autoCommit on the
connection object to false, forgotten to change it back before releasing
it
to the pool andwell,all
gt;
> Data: Tue, 6 Apr 2004 10:54:06 -0700 (PDT)
> Para: Struts Users Mailing List <[EMAIL PROTECTED]>
> Assunto: Re: Connection Pooling - Monitor
>
> Marcelo,
> The # of connections is determined by the value you
> set when you defined your datasource. What is th
00
> > Para: "Struts Users Mailing List"
> <[EMAIL PROTECTED]>
> > Assunto: Re: Connection Pooling (How i use...)
> >
> > Now I am closing the connection in the finally
> block.
> > The exemple provided by:
> >
>
http://jakarta.
*Quite* right: there was one time we had set the autoCommit on the
connection object to false, forgotten to change it back before releasing it
to the pool andwell,all I can say is we spent some "interesting" hours
trying to debug that one!
Geeta
Larry Meadors wrote:
> Yes.
>
> So be careful
Oh yeah, that reminds me: Be careful not to double close your
connections - with some implementations, that closes the pool.
So do not close the connectionin the try *and* in the finally - do it
*only* in the finally!
Larry
>>> [EMAIL PROTECTED] 04/06/04 11:25 AM >>>
well, you are right...! Wh
Ah, well, you didn't read the fine print:
-->>Note: this code isn't anywhere near production ready - it's only supposed to be
used as a simple test :-)
Believe me, you should close connections/return them to the pool in a finally block if
you want to avoid major
problems.. As I said before, thi
I have yet to see a *good* example of how to do jdbc on the net.
Most are very simple one-off "throws SQLException" examples that don't
seem to take into consideration little things like stability and
releasing resources. :)
That is why I think tools like iBATIS are so powerful - you get all the
Yes.
So be careful if you tweak the connection (like changing transaction
isolation, etc) because that connection may be used elsewhere, and your
change will persist. :)
Larry
>>> [EMAIL PROTECTED] 04/06/04 11:17 AM >>>
What happens when i do conn.close()? does it go back to the pool?
---
To: Struts Users Mailing List
> Cc:
> Subject: Re: Connection Pooling (How i use...)
>
>
>
> This your problem: closing the connection in your try block. Move it to a
> finally block..
>
> Marcelo Epstein wrote:
>
>
g getFoo() { return foo; }
public int getBar() { return bar;}
}
On Tue, 06 Apr 2004 12:50:29 -0400, "Geeta Ramani"
<[EMAIL PROTECTED]> escreveu:
De: "Geeta Ramani" <[EMAIL PROTECTED]>
Data: Tue, 06 Apr 2004 12:50:29 -0400
Para: Struts Users Mailing List <[EMAIL PROTE
}
public String getFoo() { return foo; }
public int getBar() { return bar;}
}
On Tue, 06 Apr 2004 12:50:29 -0400, "Geeta Ramani" <[EMAIL PROTECTED]> escreveu:
> De: "Geeta Ramani" <[EMAIL PROTECTED]>
> Data: Tue, 06 Apr 2004 12:50:29 -0400
> Para:
]
Sent: Tue 4/6/2004 10:20 PM
To: Struts Users Mailing List
Cc:
Subject: Re: Connection Pooling (How i use...)
This your problem: closing the connection in your try block. Move it to a
finally block..
Marcelo Epstein wrote
System.out.println(ex.toString());
> }
>
> On Tue, 06 Apr 2004 10:19:15 -0600, "Larry Meadors" <[EMAIL PROTECTED]> escreveu:
>
> > De: "Larry Meadors" <[EMAIL PROTECTED]>
> > Data: Tue, 06 Apr 2004 10:19:15 -0600
> >
From: Marcelo Epstein [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 9:31 AM
To: Struts Users Mailing List
Subject: Re: Connection Pooling (How i use...)
I use the pool like this: (IS IT WRONG??) I think the connection is being
closed..
try {
Context ctx = new InitialContext();
Yes.
You really might want to consider a tool like iBATIS, but if you want to
do it yourself, here is the pattern:
Connection c = null;
try{
//get connection
try{
// get statement
try{
// get result set
// process result set
}finally{
// close result set if not
) and always in a
finally block.
Brian McClung
Senior Programmer
Belo Interactive
-Original Message-
From: Marcelo Epstein [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 11:31 AM
To: Struts Users Mailing List
Subject: Re: Connection Pooling (How i use...)
I use the pool like
ks...
On Tue, 6 Apr 2004 18:20:29 +0200, Mark Lowe <[EMAIL PROTECTED]>
escreveu:
De: Mark Lowe <[EMAIL PROTECTED]>
Data: Tue, 6 Apr 2004 18:20:29 +0200
Para: "Struts Users Mailing List" <[EMAIL PROTECTED]>
Assunto: Re: Connection Pooling
If your using the version 3 m
http://proxool.sourceforge.net/
Avinash
-Original Message-
From: Marcelo Epstein [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 06, 2004 9:31 AM
To: Struts Users Mailing List
Subject: Re: Connection Pooling (How i use...)
I use the pool like this: (IS IT WRONG??) I think the connection is being
closed..
s" <[EMAIL PROTECTED]> escreveu:
De: "Larry Meadors" <[EMAIL PROTECTED]>
Data: Tue, 06 Apr 2004 10:19:15 -0600
Para: <[EMAIL PROTECTED]>
Assunto: Re: Connection Pooling
My bet is on a connection leak - you open one in a try block and don't close it in the fina
ECTED]>
> Data: Tue, 6 Apr 2004 18:20:29 +0200
> Para: "Struts Users Mailing List" <[EMAIL PROTECTED]>
> Assunto: Re: Connection Pooling
>
> If your using the version 3 mysql driver don't.. Use version 2 and
> never look back.
>
> There also a ?aut
}
} catch (Exception ex) {
System.out.println(ex.toString());
}
On Tue, 06 Apr 2004 10:19:15 -0600, "Larry Meadors" <[EMAIL PROTECTED]> escreveu:
> De: "Larry Meadors" <[EMAIL PROTECTED]>
> Data: Tue, 06 Apr 2004 10:19:
If your using the version 3 mysql driver don't.. Use version 2 and
never look back.
There also a ?autoReconnect=true parameter to pass through with the
url, but i think thats bollocks or at least didn't work with version3
mysql drivers.
On 6 Apr 2004, at 18:08, Marcelo Epstein wrote:
Hi,
I h
My bet is on a connection leak - you open one in a try block and don't close it in the
finally block.
>>> [EMAIL PROTECTED] 04/06/04 10:08 AM >>>
Hi,
I have just started using Connection Pooling in my app (Tomcat, Struts, DBCP, Mysql) .
It woks for about 20 hours and stop working until tomcat r
These are the main 2 reasons that come to me:
(1) You are not "closing" the connection once you've finished using it.
This signals the pool's manager when to re-assign that connection (i.e.
you've finished, so it can be used by someone else).
(2) Your connection pool is not big enough.
HTH,
Fred
Marcelo;
You are probably exhausting all your connections in the pool. Make sure all your
connections
are returned back to the pool at the end of a "finally" block. That way the connection
is
returned to the pool regardless of whether your database work was a success or not.
Also, while
you ar
91 matches
Mail list logo
