I am unable to connect to Oracle Database from a xsp file. I made necessary changes in web.xml and cocoon.xconf. I also kept classes12.jar in appropriate directory.
My log file says "Excalibur could not create any connections". What might be the problem.
My error.log.0001 file:
-----------------------------------------------------------------------------------------------------------------------
FATAL_E (2002-03-01) 19:23.32:498 [core] (Unknown-URI) Unknown-thread/LogKitLogger: Excalibur could not create any connections. Examine your settings to make sure they are correct. Make sure you can connect with the same settings on your machine.
ERROR (2002-03-01) 19:26.35:655 [sitemap.generator.velocity] (/cocoon/) HttpProcessor[8080][3]/VelocityGenerator: ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader.
ERROR (2002-03-01) 19:26.35:826 [sitemap.generator.velocity] (/cocoon/) HttpProcessor[8080][3]/VelocityGenerator: ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader.
ERROR (2002-03-01) 19:26.36:655 [sitemap.generator.xmldb] (/cocoon/) HttpProcessor[8080][3]/XMLDBGenerator: There was a problem setting up the connection
ERROR (2002-03-01) 19:26.36:655 [sitemap.generator.xmldb] (/cocoon/) HttpProcessor[8080][3]/XMLDBGenerator: Make sure that your driver is available
ERROR (2002-03-01) 19:26.36:655 [sitemap.generator.xmldb] (/cocoon/) HttpProcessor[8080][3]/XMLDBGenerator: There was a problem setting up the connection
ERROR (2002-03-01) 19:26.36:670 [sitemap.generator.xmldb] (/cocoon/) HttpProcessor[8080][3]/XMLDBGenerator: Make sure that your driver is available
ERROR (2002-03-01) 19:26.36:701 [sitemap.generator.xmldbcollection] (/cocoon/) HttpProcessor[8080][3]/XMLDBCollectionGenerator: There was a problem setting up the connection
ERROR (2002-03-01) 19:26.36:701 [sitemap.generator.xmldbcollection] (/cocoon/) HttpProcessor[8080][3]/XMLDBCollectionGenerator: Make sure that your driver is available
ERROR (2002-03-01) 19:26.36:701 [sitemap.generator.xmldbcollection] (/cocoon/) HttpProcessor[8080][3]/XMLDBCollectionGenerator: There was a problem setting up the connection
ERROR (2002-03-01) 19:26.36:701 [sitemap.generator.xmldbcollection] (/cocoon/) HttpProcessor[8080][3]/XMLDBCollectionGenerator: Make sure that your driver is available
ERROR (2002-03-01) 19:28.23:701 [sitemap.generator.serverpages] (/cocoon/xsp/esql) HttpProcessor[8080][3]/esql_xsp: Could not get the datasource
org.apache.avalon.excalibur.datasource.NoAvailableConnectionException: There are no connections in the pool, check your settings.
at org.apache.avalon.excalibur.datasource.JdbcDataSource.getConnection(JdbcDataSource.java:220)
at org.apache.cocoon.www.docs.samples.xsp.esql_xsp.generate(esql_xsp.java:273)
at org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:226)
at org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEventPipeline.java:209)
at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:355)
at org.apache.cocoon.www.sitemap_xmap.matchN104AD(sitemap_xmap.java:6239)
at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:3001)
at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2426)
at org.apache.cocoon.sitemap.Handler.process(Handler.java:180)
at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:127)
at org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:144)
at org.apache.cocoon.Cocoon.process(Cocoon.java:582)
at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:795)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:190)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943)
at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1012)
at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1107)
at java.lang.Thread.run(Thread.java:484)
---------------------------------------------------------------------------------------------------------------------------
Regards,
Srinivas Chervirala
