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

Reply via email to