I am closing ResultSet, Statements and
Connections in my .java files.
I am calling a method from another method using Resultset. So
the connection is opened during method invocation. At the end of caller
method i am closing it. Is the problem because of this?
Template of a part of my code looks like :
public ArrayList method1(String s1, String s2)
{
try
{
//getting connection , statement here
// Getting Resultset
rs = stmt.executeQuery();
ArrayList as = method2(rs);
return as;
}catch(Exception sqle){
sqle.printStackTrace();
}
finally
{
try
{
rs.close();
//connection closed here
}
catch(Exception sqle){
sqle.printStackTrace();
}
}
return null;
}
//method2 continues here
I am also trying with Jboss-3.0.4_tomcat-4.1.12. I'll let you know the result
Thanks
Prema
David Jencks wrote:
On 2002.12.27 02:14:31 -0500 prema wrote:
>
> I am using Oracle8 and I set the connectionpool initial size as 50 in
> oracle-service.xml.
> I have checked the DB connections being opened from the Database Machine,
> after shutting down the server. Connections opened are 280 .
>
> While i am deploying my application in Red HatLinux 7.2, it says JDBC
> Wrapper
> doesn't implement any service methods. Do I need to set that to close the
> connections? If so, how to do that ? Please.The warnings about service methods are irrelevant and have been removed
from some later versions of jboss.Are you closing all connections and statements and result sets in finally
blocks?what does a standalone program that opens and closes Oracle connections
result in?Finally you might want to try a more recent JBoss version.
david jencks
>
>
>
> David Jencks wrote:
>
> > On 2002.12.26 23:31:06 -0500 prema wrote:
>
> > Hi All,
> > >
> > > Loadtesting my application for 100 users takes more
> > > than 175 threads. I am using JBoss3_0_0-tomcat_4_0_3. I could see
> > > 100's of background threads (other than my minProcessors) running
> after
> > > stopping the execution. Is there any settings in jboss to release
> > > threads? I am getting Out of memory Error because of too many
> background
> > > threads.
> > >
> > > And also lots of (more than my initial pool size)database connections
> > > are in use at the and of execution.
> >
> > How do you know? What database? Does closing a plain, non-pooled jdbc
> > connection reduce whatever it is you are counting? If you start say 50
> > plain jdbc connections, does what you are measuring correspond?
> >
> > Thanks
> >
> > david jencks
> > >
> > > Anybody has an idea of how to solve this problem? Please
> > >
> > > Thanks
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > This sf.net email is sponsored by:ThinkGeek
> > > Welcome to geek heaven.
> > > http://thinkgeek.com/sf
> > > _______________________________________________
> > > JBoss-user mailing list
> > > [EMAIL PROTECTED]
> > > https://lists.sourceforge.net/lists/listinfo/jboss-user
> > >
> > >
> >
> > -------------------------------------------------------
> > This sf.net email is sponsored by:ThinkGeek
> > Welcome to geek heaven.
> > http://thinkgeek.com/sf
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > https://lists.sourceforge.net/lists/listinfo/jboss-user
>
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by:ThinkGeek
> Welcome to geek heaven.
> http://thinkgeek.com/sf
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>
>-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
