Hello,
I am not able to connect to Oracle8i database.
Error creating the resource
Exception in ServerPagesGenerator.generate()
details
from
source org.apache.cocoon.ProcessingException
description org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate():
java.lang.RuntimeException: Could not get the datasource java.sql.SQLException:
There are no connections in the pool, check your settings.
extra info
org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate():
java.lang.RuntimeException: Could not get the datasource java.sql.SQLException:
There are no connections in the pool, check your settings.
org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate():
java.lang.RuntimeException: Could not get the datasource java.sql.SQLException:
There are no connections in the pool, check your settings.
at
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:212)
at
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEventPipeline.java:210)
at
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:359)
at
org.apache.cocoon.www.sitemap_xmap.wildcardMatchN400421(sitemap_xmap.java:6911)
at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2919)
at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2469)
at org.apache.cocoon.sitemap.Handler.process(Handler.java:163)
at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114)
at org.apache.cocoon.Cocoon.process(Cocoon.java:514)
at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:647)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:1264)
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:215)
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:2366)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462)
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:163)
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:1005)
at
org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1098)
at java.lang.Thread.run(Unknown Source)
java.lang.RuntimeException: Could not get the datasource java.sql.SQLException:
There are no connections in the pool, check your settings.
Sitemap.xmap
<!-- Prova Prova Prova Prova Prova Prova Prova Prova Prova -->
<map:match pattern="visualizza/*">
<map:generate type="serverpages" src="visualizza/{1}.xsp"/>
<map:transform type="sql">
<map:parameter name="use-connection" value="test_oracle_pool"/>
</map:transform>
<!-- <map:transform src="visualizza/dynamica-page2html.xsl">
<map:parameter name="view-source" value="visualizza/{1}.xsp"/>
</map:transform>
-->
<map:serialize/>
</map:match>
<!-- Prova Prova Prova Prova Prova Prova Prova Prova Prova -->
Coccon.xconf
<datasources>
<jdbc name="personnel" logger="core.datasources.personnel">
<!--
If you have an Oracle database, and are using the the
pool-controller below, you should add the attribute
"oradb" and set it to true.
<pool-controller min="5" max="10" oradb="true"/>
That way the test to see if the server has disconnected
the JdbcConnection will function properly.
-->
<pool-controller min="5" max="10"/>
<!--
If you need to ensure an autocommit is set to true or
false, then create the "auto-commit" element below.
<auto-commit>false</auto-commit>
The default is true.
-->
<dburl>jdbc:hsqldb:hsql://localhost:9002</dburl>
<user>sa</user>
<password></password>
</jdbc>
<!-- <component-instance name="test_oracle_pool"
class="org.apache.avalon.util.datasource.JdbcDataSource">
-->
<jdbc name="test_oracle_pool">
<!-- Don't forget the oradb parameter for Oracle!!! -->
<pool-controller min="5" max="10" oradb="true"/>
<dburl>jdbc:oracle:thin:@server:1521:oras</dburl>
<user>d</user>
<password>g</password>
</jdbc>
<!-- </component-instance> -->
</datasources>
web.xml
<init-param>
<param-name>load-class</param-name>
<param-value>
<!-- For IBM WebSphere:
com.ibm.servlet.classloader.Handler -->
<!-- For Database Driver: -->
org.hsqldb.jdbcDriver
<!-- For ORACLE Database Driver: -->
oracle.jdbc.driver.OracleDriver
<!-- For parent ComponentManager sample:
org.apache.cocoon.samples.parentcm.Configurator
-->
</param-value>
</init-param>
The database driver is classes102.zip and I am able to connect to the same
database with same driver with standalone java application.
Environment is Tomcat 4, C2 & windows2000
Any help on this will be highly appreciated
Thanks
__________________________________________________________________
Abbonati a Tiscali!
Con Tiscali By Phone puoi anche ascoltare ed inviare email al telefono.
Chiama Tiscali By Phone all' 892 800 http://byphone.tiscali.it
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
