Here is more detailed information surrounding the issue.
Thanks
==================================================================
03/10 13:49:14 error SQLException occurred in JDBCPool while attempting to
connect, please check your username, password, URL, and other connectivity
info.
java.sql.SQLException: SQLException occurred in JDBCPool while attempting to
connect, please check your username, password, URL, and other connectivity
info.
at jrun.sql.pool.JDBCPool.createPhysicalConnection(Unknown Source)
at jrun.sql.pool.JDBCPool.create(Unknown Source)
at jrun.sql.pool.JDBCPool.checkOut(Unknown Source)
at jrun.sql.pool.JDBCPool.requestConnection(Unknown Source)
at jrun.sql.pool.JDBCManager.requestConnection(JDBCManager.java:125)
at jrun.sql.JRunDataSource.getConnection(JRunDataSource.java:232)
at jrun.sql.JRunDataSource.getConnection(JRunDataSource.java:172)
at coldfusion.sql.DataSrcImpl.getCachedConnection(Unknown Source)
at coldfusion.sql.DataSrcImpl.getConnection(Unknown Source)
at coldfusion.sql.SqlImpl.execute(Unknown Source)
at coldfusion.tagext.sql.QueryTag.doEndTag(Unknown Source)
at
cfsitelist2ecfm452663090.runPage(/home/httpd/public_html/admin/sitelist.cfm:
13)
at coldfusion.runtime.CfJspPage.invoke(Unknown Source)
at coldfusion.tagext.lang.IncludeTag.doStartTag(Unknown Source)
at coldfusion.filter.CfincludeFilter.invoke(Unknown Source)
at coldfusion.filter.ApplicationFilter.invoke(Unknown Source)
at coldfusion.filter.PathFilter.invoke(Unknown Source)
at coldfusion.filter.ExceptionFilter.invoke(Unknown Source)
at coldfusion.filter.BrowserDebugFilter.invoke(Unknown Source)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(Unknown Source)
at coldfusion.filter.BrowserFilter.invoke(Unknown Source)
at coldfusion.filter.GlobalsFilter.invoke(Unknown Source)
at coldfusion.filter.DatasourceFilter.invoke(Unknown Source)
at coldfusion.CfmServlet.service(Unknown Source)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at
jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)
at
jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at
jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:198)
at
jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:
348)
at
jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451
)
at
jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:29
4)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
03/10 13:53:18 user FlashGatewayServlet: destroy
03/10 13:53:18 info 1 session(s) persisted
03/10 13:53:31 info JRunDataSource bound to JNDI under name ipaulsites
03/10 13:53:31 info JRun DataSourceService: Created JDBC XA Connection Pool
named ipaulsites
03/10 13:53:31 info Bound a LinkRef from "DefaultDataSource" to the default
DataSource "ipaulsites"
03/10 13:53:32 info JRun Web Server listening on *:8500
03/10 13:53:32 info JRun Proxy Server listening on *:51010
03/10 13:53:32 info Deploying enterprise application "Macromedia ColdFusion
MX" from: file:/usr/local/coldfusionmx/
03/10 13:53:32 info Deploying web application "ColdFusion Web Application"
from: file:/usr/local/coldfusionmx/
03/10 13:53:32 info Web Services in coldfusionmx#wwwroot:
03/10 13:53:32 info CFCProcessor
03/10 13:53:32 user JSPServlet: init
03/10 13:53:33 info Recovering 1 session(s)
03/10 13:53:33 info Deploying enterprise application "Flash Remoting EAR"
from: file:/usr/local/coldfusionmx/runtime/servers/default/flashgateway.ear
03/10 13:53:33 info Deploying web application "Flash Remoting" from:
file:/usr/local/coldfusionmx/runtime/servers/default/flashgateway.ear
03/10 13:53:33 user JSPServlet: init
03/10 13:53:33 user FlashGatewayServlet: init
-----Original Message-----
From: Paul Hassinger [mailto:[EMAIL PROTECTED]
Sent: Friday, March 07, 2003 1:26 PM
To: CF-Talk
Subject: CFMX Linux JDBCPool Timeout
Hello,
Running Cold Fusion MX Updater 1 with Apache 2.0.40-11, everything run
fine... except:
After 20 minutes (or the timeout specified in the CF Administrator for the
datasource), the datasource will no longer work and I will receive the
standard SQLException with JDBCPool... check username, password, etc.
If I go to the Administrator and verify the datasource, it will work for
another 20 minutes. Also, if I uncheck maintain connections it will not work
at all. I am using the included MySQL driver.
Just wondering if anyone else has run into this error before and might be
able to help me out.
I have not updated to Updater 2 because of the required Apache upgrade.
Any help is appreciated.
Thank you,
Paul Hassinger,
ipaul.com, Inc.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
