cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jerzy Kut" <jer...@rzeszow.tiger.com.pl>
Subject Re: oradb esql no connection in pool error!
Date Fri, 29 Mar 2002 14:00:34 GMT
I try classes.jar and classes12.jar and there is no matter.
No change.
I copy classes12.jar from oracle to $CATALINA_HOME/common/lib and to
$CATALINA_HOME/webapps/cocoon/WEB-INF/lib - and this no metter too.

----- Original Message -----
From: "Luca Morandini" <luca.morandini1@tin.it>
To: <cocoon-users@xml.apache.org>; <lmorandini@ieee.org>
Sent: Friday, March 29, 2002 2:52 PM
Subject: RE: oradb esql no connection in pool error!


> Sorry, I meant "classes12.jar" not "classes.jar"  :(
>
>
> ---------------------------------------------
>                Luca Morandini
>                GIS Consultant
>               lmorandini@ieee.org
> http://utenti.tripod.it/lmorandini/index.html
> ---------------------------------------------
>
>
> > -----Original Message-----
> > From: Luca Morandini [mailto:luca.morandini1@tin.it]
> > Sent: Friday, March 29, 2002 2:48 PM
> > To: cocoon-users@xml.apache.org
> > Subject: RE: oradb esql no connection in pool error!
> >
> >
> > Jerzy,
> >
> > try renaming classes12.zip to classes.jar
> >
> > Regards,
> >
> > ---------------------------------------------
> >                Luca Morandini
> >                GIS Consultant
> >               lmorandini@ieee.org
> > http://utenti.tripod.it/lmorandini/index.html
> > ---------------------------------------------
> >
> >
> > > -----Original Message-----
> > > From: Jerzy Kut [mailto:jerzyk@rzeszow.tiger.com.pl]
> > > Sent: Friday, March 29, 2002 2:13 PM
> > > To: cocoon-users@xml.apache.org
> > > Subject: oradb esql no connection in pool error!
> > >
> > >
> > > Hi cocooners!
> > > I have got win2k, tomcat4.0.2, cocoon2.0.1.
> > > I have oracle driver classes12.zip in CLASSPATH.
> > > When I run this snippet I got exception:
> > >
> > > Cocoon 2 - Internal server error
> > >
> > > type internal-server-error
> > > message Exception in ServerPagesGenerator.generate()
> > > 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.
> > > sender org.apache.cocoon.servlet.CocoonServlet
> > > source Cocoon servlet
> > > request-uri
> > > /cocoon/mekka/main
> > > exception
> > > 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.
> > > path-info
> > > mekka/main
> > > stacktrace
> > > 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(ServerP
> > > agesGenera
> > > tor.java:212)
> > >  at
> > > org.apache.cocoon.components.pipeline.CachingEventPipeline.process
> > > (CachingEv
> > > entPipeline.java:210)
> > >  at
> > > org.apache.cocoon.components.pipeline.CachingStreamPipeline.proces
> > > s(CachingS
> > > treamPipeline.java:359)
> > >  at
> > > org.apache.cocoon.www.mekka.sitemap_xmap.wildcardMatchN40004F(site
> > > map_xmap.j
> > > ava:630)
> > >  at
> > >
org.apache.cocoon.www.mekka.sitemap_xmap.process(sitemap_xmap.java:487)
> > >  at
> > >
org.apache.cocoon.www.mekka.sitemap_xmap.process(sitemap_xmap.java:445)
> > >  at org.apache.cocoon.sitemap.Handler.process(Handler.java:163)
> > >  at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114)
> > >  at
> > > org.apache.cocoon.www.sitemap_xmap.wildcardMatchN400209(sitemap_xm
> > > ap.java:31
> > > 22)
> > >  at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2509)
> > >  at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2462)
> > >  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:853)
> > >  at
> > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(A
> > > pplication
> > > FilterChain.java:247)
> > >  at
> > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicati
> > > onFilterCh
> > > ain.java:193)
> > >  at
> > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapp
> > > erValve.ja
> > > va:243)
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 66)
> > >  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(StandardConte
> > > xtValve.ja
> > > va:190)
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 66)
> > >  at
> > > org.apache.catalina.valves.CertificatesValve.invoke(CertificatesVa
> > > lve.java:2
> > > 46)
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 64)
> > >  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(StandardHostValv
> > > e.java:180
> > > )
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 66)
> > >  at
> > > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispat
> > > cherValve.
> > > java:170)
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 64)
> > >  at
> > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValv
> > > e.java:170
> > > )
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 64)
> > >  at
> > >
> >
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 64)
> > >  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(StandardEngine
> > > Valve.java
> > > :174)
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 66)
> > >  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(HttpProce
> > > ssor.java:
> > > 1012)
> > >  at
> > > org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor
> > > .java:1107
> > > )
> > >  at java.lang.Thread.run(Thread.java:484)
> > > 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.www.mekka.main_xml.generate(main_xml.java:366)
> > >  at
> > > org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerP
> > > agesGenera
> > > tor.java:200)
> > >  at
> > > org.apache.cocoon.components.pipeline.CachingEventPipeline.process
> > > (CachingEv
> > > entPipeline.java:210)
> > >  at
> > > org.apache.cocoon.components.pipeline.CachingStreamPipeline.proces
> > > s(CachingS
> > > treamPipeline.java:359)
> > >  at
> > > org.apache.cocoon.www.mekka.sitemap_xmap.wildcardMatchN40004F(site
> > > map_xmap.j
> > > ava:630)
> > >  at
> > >
org.apache.cocoon.www.mekka.sitemap_xmap.process(sitemap_xmap.java:487)
> > >  at
> > >
org.apache.cocoon.www.mekka.sitemap_xmap.process(sitemap_xmap.java:445)
> > >  at org.apache.cocoon.sitemap.Handler.process(Handler.java:163)
> > >  at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114)
> > >  at
> > > org.apache.cocoon.www.sitemap_xmap.wildcardMatchN400209(sitemap_xm
> > > ap.java:31
> > > 22)
> > >  at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2509)
> > >  at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2462)
> > >  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:853)
> > >  at
> > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(A
> > > pplication
> > > FilterChain.java:247)
> > >  at
> > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicati
> > > onFilterCh
> > > ain.java:193)
> > >  at
> > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapp
> > > erValve.ja
> > > va:243)
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 66)
> > >  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(StandardConte
> > > xtValve.ja
> > > va:190)
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 66)
> > >  at
> > > org.apache.catalina.valves.CertificatesValve.invoke(CertificatesVa
> > > lve.java:2
> > > 46)
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 64)
> > >  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(StandardHostValv
> > > e.java:180
> > > )
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 66)
> > >  at
> > > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispat
> > > cherValve.
> > > java:170)
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 64)
> > >  at
> > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValv
> > > e.java:170
> > > )
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 64)
> > >  at
> > >
> >
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 64)
> > >  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(StandardEngine
> > > Valve.java
> > > :174)
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 66)
> > >  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(HttpProce
> > > ssor.java:
> > > 1012)
> > >  at
> > > org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor
> > > .java:1107
> > > )
> > >  at java.lang.Thread.run(Thread.java:484)
> > >
> > > original exception
> > > Original exception : 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.www.mekka.main_xml.generate(main_xml.java:366)
> > >  at
> > > org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerP
> > > agesGenera
> > > tor.java:200)
> > >  at
> > > org.apache.cocoon.components.pipeline.CachingEventPipeline.process
> > > (CachingEv
> > > entPipeline.java:210)
> > >  at
> > > org.apache.cocoon.components.pipeline.CachingStreamPipeline.proces
> > > s(CachingS
> > > treamPipeline.java:359)
> > >  at
> > > org.apache.cocoon.www.mekka.sitemap_xmap.wildcardMatchN40004F(site
> > > map_xmap.j
> > > ava:630)
> > >  at
> > >
org.apache.cocoon.www.mekka.sitemap_xmap.process(sitemap_xmap.java:487)
> > >  at
> > >
org.apache.cocoon.www.mekka.sitemap_xmap.process(sitemap_xmap.java:445)
> > >  at org.apache.cocoon.sitemap.Handler.process(Handler.java:163)
> > >  at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114)
> > >  at
> > > org.apache.cocoon.www.sitemap_xmap.wildcardMatchN400209(sitemap_xm
> > > ap.java:31
> > > 22)
> > >  at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2509)
> > >  at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2462)
> > >  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:853)
> > >  at
> > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(A
> > > pplication
> > > FilterChain.java:247)
> > >  at
> > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicati
> > > onFilterCh
> > > ain.java:193)
> > >  at
> > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapp
> > > erValve.ja
> > > va:243)
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 66)
> > >  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(StandardConte
> > > xtValve.ja
> > > va:190)
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 66)
> > >  at
> > > org.apache.catalina.valves.CertificatesValve.invoke(CertificatesVa
> > > lve.java:2
> > > 46)
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 64)
> > >  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(StandardHostValv
> > > e.java:180
> > > )
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 66)
> > >  at
> > > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispat
> > > cherValve.
> > > java:170)
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 64)
> > >  at
> > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValv
> > > e.java:170
> > > )
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 64)
> > >  at
> > >
> >
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 64)
> > >  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(StandardEngine
> > > Valve.java
> > > :174)
> > >  at
> > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel
> > > ine.java:5
> > > 66)
> > >  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(HttpProce
> > > ssor.java:
> > > 1012)
> > >  at
> > > org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor
> > > .java:1107
> > > )
> > >  at java.lang.Thread.run(Thread.java:484)
> > >
> > > And there are my files:
> > > main.xml
> > >
> > >  <esql:connection>
> > >   <esql:pool>epayroll</esql:pool>
> > >   <esql:execute-query>
> > >    <esql:query>
> > >     select E1.EMPNO, E1.ENAME, E1.JOB, E2.EMPNO MGRNO, E2.ENAME MGR,
> > > E1.HIREDATE, E1.SAL, E1.COMM, D.DEPTNO, D.DNAME
> > >     from EMP E1, EMP E2, DEPT D
> > >     where E1.DEPTNO = D.DEPTNO
> > >     and E1.MGR = E2.EMPNO (+)
> > >    </esql:query>
> > >    <esql:results>
> > >     <esql:row-results>
> > >      <employee>
> > >       <employee-id><esql:get-long column="EMPNO"/></employee-id>
> > >       <employee-name><esql:get-string column="ENAME"/></employee-name>
> > >       <job><esql:get-string column="JOB"/></job>
> > >       <hiredate><esql:get-date column="HIREDATE"/></hiredate>
> > >       <manager-name><esql:get-string column="MGR"/></manager-name>
> > >       <manager-id><esql:get-long column="MGRNO"/></manager-id>
> > >       <salary><esql:get-double column="SAL"/></salary>
> > >       <comm><esql:get-string column="COMM"/></comm>
> > >       <department-id><esql:get-long column="DEPTNO"/></department-id>
> > >       <department-name><esql:get-string
> > column="DNAME"/></department-name>
> > >      </employee>
> > >     </esql:row-results>
> > >    </esql:results>
> > >    <esql:no-results>Brak danych!</esql:no-results>
> > >   </esql:execute-query>
> > >  </esql:connection>
> > >
> > > cocoon.xconf
> > >
> > >     <jdbc name="epayroll">
> > >       <pool-controller min="5" max="10" oradb="true"/>
> > >       <dburl>jdbc:oracle:thin:@10.0.0.100:1521:epayroll</dburl>
> > >       <user>scott</user>
> > >       <password>tiger</password>
> > >     </jdbc>
> > >
> > > web.xml
> > >
> > >     <init-param>
> > >       <param-name>load-class</param-name>
> > >       <param-value>
> > >         <!-- For ORACLE database driver: -->
> > >         oracle.jdbc.driver.OracleDriver
> > >       </param-value>
> > >     </init-param>
> > >
> > > Where is the problem? And what?
> > >
> > > The best regards
> > > Jerzy Kut
> > >
> > >
> > >
> > > ---------------------------------------------------------------------
> > > 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: <cocoon-users-unsubscribe@xml.apache.org>
> > > For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
> > >
> >
> >
> > ---------------------------------------------------------------------
> > 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: <cocoon-users-unsubscribe@xml.apache.org>
> > For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
> >
>
>
> ---------------------------------------------------------------------
> 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: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message