RE: java.lang.RuntimeException: Could not get the datasource

["Sullivan, Sean C - MWT" <su...@menloworldwide.com>]

I found more information in the core.log file.

How can I fix this error?


WARN    (2005-08-01) 10:47.43:266   [core.datasources.edi_central]
(/foobar/label_select_asn.html)
Servlet.Engine.Transports:10/ResourceLimitingJdbcDataSource: Could not
return Connection
org.apache.avalon.excalibur.datasource.NoValidConnectionException: No
valid JdbcConnection class available
	at
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(Cach
ingStreamPipeline.java:420)
	at
org.apache.cocoon.www.sitemap_xmap.matchN102B8(www\sitemap_xmap.java:258
6)
	at
org.apache.cocoon.www.sitemap_xmap.process(www\sitemap_xmap.java:1919)
	at
org.apache.cocoon.www.sitemap_xmap.process(www\sitemap_xmap.java:1737)
	at org.apache.cocoon.sitemap.Handler.process(Handler.java:227)
	at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:181)
	at
org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:154
)
	at org.apache.cocoon.Cocoon.process(Cocoon.java:587)
	at
org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1134)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:854)
	at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletMan
ager.java:850)
	at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLife
cycleServlet.java:199)
	at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleSe
rvlet.java:298)
	at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifec
ycleServlet.java:111)
	at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.jav
a:511)
	at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(Servle
tManager.java:1013)
	at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletM
anager.java:914)
	at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispat
ch(WebAppRequestDispatcher.java:815)
	at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppReq
uestDispatcher.java:536)
	at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequ
estDispatcher.java:161)
	at
com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:20
5)
	at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvo
ker.java:337)
	at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(Cach
edInvocation.java:68)
	at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(Servlet
RequestProcessor.java:157)
	at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEList
ener.java:400)
	at
com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnectio
n.java:61)
	at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:
571)
	at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:431)
	at com.ibm.ws.util.CachedThread.run(ThreadPool.java:169)
	at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:431)
	at com.ibm.ws.util.CachedThread.run(ThreadPool.java:169)
	at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvo
ker.java:337)
	at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(Cach
edInvocation.java:68)
	at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(Servlet
RequestProcessor.java:157)
	at com.ibm.ws.util.CachedThread.run(ThreadPool.java:169)



-----Original Message-----
From: Sullivan, Sean C - MWT [mailto:sullivan.sean@menloworldwide.com] 
Sent: Friday, July 29, 2005 4:49 PM
To: users@cocoon.apache.org
Subject: java.lang.RuntimeException: Could not get the datasource



I inherited a Cocoon application that was written by another developer.

The developer left our company and nobody has touched this application 
in 2 years.

The application uses cocoon-2.0.3.jar and runs on JDK 1.3.1

The application connects to an Oracle database and an Informix database.

The driver jar files are located in WEB-INF/lib and I am using the
"load-class" parameter in the web.xml file.

When I try to browse one of the pages in the application, I observe 
a NoValidConnectionException.

How can I troubleshoot this?

It appears that the NoValidConnectionException 
is thrown in
org.apache.avalon.excalibur.datasource.JdbcConnectionFactory

I downloaded the source code for JdbcConnectionFactory from apache.org 
but the source file / line numbers do not appear to match the line
numbers 
in the jar that I am using.

WEB-INF/lib contains this file:  avalon-excalibur-vm12-20020705.jar

This appears to be a custom-built jar. 

(Another roadblock is the LogKit framework.  This application uses
LogKit but I am having trouble finding suitable documentation for LogKit
configuration. I want to be able to enable full DEBUG output for all
logger's.)

Here's the full stack trace:

Original exception : java.lang.RuntimeException: Could not get the
datasource
org.apache.avalon.excalibur.datasource.NoValidConnectionException: No
valid JdbcConnection class available 
at
org.apache.cocoon.www.documents.ucc.label_select_asn_xsp.generate(ucc\la
bel_select_asn_xsp.java:3398) 
at
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGe
nerator.java:258) 
at
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(Cachi
ngEventPipeline.java:250) 
at
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(Cach
ingStreamPipeline.java:399) 
at
org.apache.cocoon.www.sitemap_xmap.matchN102B8(www\sitemap_xmap.java:257
6) 
at
org.apache.cocoon.www.sitemap_xmap.process(www\sitemap_xmap.java:1835) 
at
org.apache.cocoon.www.sitemap_xmap.process(www\sitemap_xmap.java:1731) 
at org.apache.cocoon.sitemap.Handler.process(Handler.java:224) 
at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:179) 
at
org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:154
) 
at org.apache.cocoon.Cocoon.process(Cocoon.java:575) 
at
org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:999) 
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) 
at
com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletMan
ager.java:827) 
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLife
cycleServlet.java:167) 
at
com.ibm.servlet.engine.webapp.IdleServletState.service(StrictLifecycleSe
rvlet.java:297) 
at
com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifec
ycleServlet.java:110) 
at
com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.jav
a:472) 
at
com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(Servle
tManager.java:1012) 
at
com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletM
anager.java:913) 
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.handleWebAppDispat
ch(WebAppRequestDispatcher.java:721) 
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppReq
uestDispatcher.java:374) 
at
com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequ
estDispatcher.java:118) 
at
com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java:13
4) 
at
com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvo
ker.java:239) 
at
com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(Cach
edInvocation.java:67) 
at
com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(Servlet
RequestProcessor.java:151) 
at
com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEList
ener.java:317) 
at
com.ibm.servlet.engine.http11.HttpConnection.handleRequest(HttpConnectio
n.java:60) 
at
com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:
477) 
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:341) 
at com.ibm.ws.util.CachedThread.run(ThreadPool.java:144)



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org