Also, you could try this from the Tomcat 4.1x docs
IT SAYS IT CAN LOG A STACK TRACE OF THE CODE THAT ABANDONED THE DB
CONNECTION RESOURCE. I HAVE NEVER USED IT BUT...
Preventing dB connection pool leaks
To configure a DBCP DataSource so that abandoned dB connections are
removed and recycled add the following paramater to the ResourceParams
configuration for your DBCP DataSource Resource:
[image]
[image]
[image]
[image]
<parameter>
<name>removeAbandoned</name>
<value>true</value>
</parameter>
[image]
[image]
[image]
[image]
When available db connections run low DBCP will recover and recyle any
abandoned dB connections it finds. The default is false.
Use the removeAbandonedTimeout parameter to set the number of seconds a
dB connection has been idle before it is considered abandoned.
[image]
[image]
[image]
[image]
<parameter>
<name>removeAbandonedTimeout</name>
<value>60</value>
</parameter>
[image]
[image]
[image]
[image]
The default timeout for removing abandoned connections is 300 seconds.
The logAbandoned parameter can be set to true if you want DBCP to log a
stack trace of the code which abandoned the dB connection resources.
[image]
[image]
[image]
[image]
<parameter>
<name>logAbandoned</name>
<value>true</value>
</parameter>
[image]
[image]
[image]
[image]
The default is false.
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/jndi-datasource-examples-howto.html#Database%20Connection%20Pool%20(DBCP)%20Configurations
On Thu, 2003-01-30 at 22:50, McBrayer, Roy wrote:
> Yes, 1.1.3pr is the only jar in the lib and I have verified the
> corresponding tld. I will make the changes to log4j and see what is logged.
>
> Thanks,
> Roy
>
> -----Original Message-----
> From: shawn [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 29, 2003 7:05 PM
> To: McBrayer, Roy
> Subject: Re: [dbforms] Maximum number of Oracle Processes Exceeded (150)
>
>
> Dear Roy,
>
> I just want to confirm that you 1.1.3pr is the only dbforms jar in your
> lib and that you were sure to use the corresponding taglib.
>
> If so, remember log4j. Please set it to debug and send the output.
>
> Do something like:
> #begin log4j.props
> > #IMPORTANT - Watch for trailing whitespaces after each statement!!!
> >
> > log4j.rootCategory=debug, stdout, logFile
> >
> > log4j.category.org.dbforms=debug, logFile
> >
> >
> ALSO SET this line
> log4j.appender.logFile.MaxFileSize=100KB
> SET IT TO A BIG VALUE AND THEN ACCESS SEVERAL PAGES UNTIL YOU GET THE
> ERROR AND THEN SEND ME THE WHOLE FILE. 100KB FILLS UP PRETTY QUICKLY SO
> MAYBE TRY 1000 OR WHATEVER JUST MAKE SURE I GET IT ALL IN ONE FILE.
> >
> >
> >
> >
> > In my log file I get this (among other things):
>
>
> DEBUG [Thread-3] (SqlUtil.java:314) - About to close connection -
> com.mysql.jdbc.jdbc2.Connection@19e09a4
> DEBUG [Thread-3] (SqlUtil.java:314) - About to close connection -
> com.mysql.jdbc.jdbc2.Connection@
> DEBUG [Thread-3] (SqlUtil.java:316) - Connection closed
> DEBUG [Thread-3] (SqlUtil.java:316) - Connection closed
>
> I don't have Oracle on my system or would do it myself, but have been
> looking for an excuse to install and play with it....
>
>
> Shawn
>
>
> On Thu, 2003-01-30 at 06:32, McBrayer, Roy wrote:
> > Are there any known bugs in DBforms related to a failure to close
> > connections? I am now running on 1.1.3pr with a Tomcat datasource. As
> the
> > only user of the app, I can, after clicking on various DBforms tables
> > several times over a period of time, exceed the maximum number of Oracle
> > processes (in this case 150).
> >
> > This occurs whether or not I am using a datasource connection or using a
> > direct connection string in DBforms.
> >
> >
> >
> > -------------------------------------------------------
> > This SF.NET email is sponsored by:
> > SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
> > http://www.vasoftware.com
> > _______________________________________________
> > DbForms Mailing List
> >
> > http://www.wap-force.net/dbforms
--
shawn <[EMAIL PROTECTED]>
-------------------------------------------------------
This SF.NET email is sponsored by:
SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
http://www.vasoftware.com
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
