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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] > http://utenti.tripod.it/lmorandini/index.html > --------------------------------------------- > > > > -----Original Message----- > > From: Luca Morandini [mailto:[EMAIL PROTECTED]] > > Sent: Friday, March 29, 2002 2:48 PM > > To: [EMAIL PROTECTED] > > Subject: RE: oradb esql no connection in pool error! > > > > > > Jerzy, > > > > try renaming classes12.zip to classes.jar > > > > Regards, > > > > --------------------------------------------- > > Luca Morandini > > GIS Consultant > > [EMAIL PROTECTED] > > http://utenti.tripod.it/lmorandini/index.html > > --------------------------------------------- > > > > > > > -----Original Message----- > > > From: Jerzy Kut [mailto:[EMAIL PROTECTED]] > > > Sent: Friday, March 29, 2002 2:13 PM > > > To: [EMAIL PROTECTED] > > > 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: <[EMAIL PROTECTED]> > > > For additional commands, e-mail: <[EMAIL PROTECTED]> > > > > > > > > > --------------------------------------------------------------------- > > 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]> > > > > > --------------------------------------------------------------------- > 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]> --------------------------------------------------------------------- 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]>
