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]>

Reply via email to