You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Jerzy Kut <je...@rzeszow.tiger.com.pl> on 2002/03/29 14:12:34 UTC
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(ServerPagesGenera
tor.java:212)
at
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv
entPipeline.java:210)
at
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS
treamPipeline.java:359)
at
org.apache.cocoon.www.mekka.sitemap_xmap.wildcardMatchN40004F(sitemap_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_xmap.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(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:243)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardContextValve.ja
va:190)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
46)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardHostValve.java:180
)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardEngineValve.java
:174)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(HttpProcessor.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(ServerPagesGenera
tor.java:200)
at
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv
entPipeline.java:210)
at
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS
treamPipeline.java:359)
at
org.apache.cocoon.www.mekka.sitemap_xmap.wildcardMatchN40004F(sitemap_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_xmap.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(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:243)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardContextValve.ja
va:190)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
46)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardHostValve.java:180
)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardEngineValve.java
:174)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(HttpProcessor.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(ServerPagesGenera
tor.java:200)
at
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv
entPipeline.java:210)
at
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS
treamPipeline.java:359)
at
org.apache.cocoon.www.mekka.sitemap_xmap.wildcardMatchN40004F(sitemap_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_xmap.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(Application
FilterChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
ain.java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
va:243)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardContextValve.ja
va:190)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
46)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardHostValve.java:180
)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
66)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
java:170)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
64)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardEngineValve.java
:174)
at
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(HttpProcessor.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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
RE: oradb esql no connection in pool error!
Posted by Vadim Gritsenko <va...@verizon.net>.
> > > I have oracle driver classes12.zip in CLASSPATH.
It better be JAR!!! Rename to JAR or re-jar it.
Vadim
> From: Jerzy Kut [mailto:jerzyk@rzeszow.tiger.com.pl]
>
> Sorry - I have
>
> java version "1.3.1"
> Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1-b24)
> Java HotSpot(TM) Client VM (build 1.3.1-b24, mixed mode)
>
>
> ----- Original Message -----
> From: "Andrey Demchenko" <de...@kyivstar.net>
> To: <co...@xml.apache.org>
> Sent: Friday, March 29, 2002 2:31 PM
> Subject: Re: oradb esql no connection in pool error!
>
>
> > I have the same problem with JDK 1.4
> > With JDK 1.3.1 it works well.
> >
> > ----- Original Message -----
> > From: "Jerzy Kut" <je...@rzeszow.tiger.com.pl>
> > To: <co...@xml.apache.org>
> > Sent: Friday, March 29, 2002 3:12 PM
> > 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.
...
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: oradb esql no connection in pool error!
Posted by Jerzy Kut <je...@rzeszow.tiger.com.pl>.
Sorry - I have
java version "1.3.1"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.3.1-b24)
Java HotSpot(TM) Client VM (build 1.3.1-b24, mixed mode)
----- Original Message -----
From: "Andrey Demchenko" <de...@kyivstar.net>
To: <co...@xml.apache.org>
Sent: Friday, March 29, 2002 2:31 PM
Subject: Re: oradb esql no connection in pool error!
> I have the same problem with JDK 1.4
> With JDK 1.3.1 it works well.
>
> ----- Original Message -----
> From: "Jerzy Kut" <je...@rzeszow.tiger.com.pl>
> To: <co...@xml.apache.org>
> Sent: Friday, March 29, 2002 3:12 PM
> 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(ServerPagesGenera
> > tor.java:212)
> > at
> >
>
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv
> > entPipeline.java:210)
> > at
> >
>
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS
> > treamPipeline.java:359)
> > at
> >
>
org.apache.cocoon.www.mekka.sitemap_xmap.wildcardMatchN40004F(sitemap_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_xmap.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(Application
> > FilterChain.java:247)
> > at
> >
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> > ain.java:193)
> > at
> >
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
> > va:243)
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardContextValve.ja
> > va:190)
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> > 66)
> > at
> >
>
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
> > 46)
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardHostValve.java:180
> > )
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> > 66)
> > at
> >
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
> > java:170)
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> > 64)
> > at
> >
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
> > )
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> > 64)
> > at
> >
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardEngineValve.java
> > :174)
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(HttpProcessor.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(ServerPagesGenera
> > tor.java:200)
> > at
> >
>
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv
> > entPipeline.java:210)
> > at
> >
>
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS
> > treamPipeline.java:359)
> > at
> >
>
org.apache.cocoon.www.mekka.sitemap_xmap.wildcardMatchN40004F(sitemap_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_xmap.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(Application
> > FilterChain.java:247)
> > at
> >
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> > ain.java:193)
> > at
> >
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
> > va:243)
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardContextValve.ja
> > va:190)
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> > 66)
> > at
> >
>
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
> > 46)
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardHostValve.java:180
> > )
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> > 66)
> > at
> >
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
> > java:170)
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> > 64)
> > at
> >
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
> > )
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> > 64)
> > at
> >
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardEngineValve.java
> > :174)
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(HttpProcessor.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(ServerPagesGenera
> > tor.java:200)
> > at
> >
>
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv
> > entPipeline.java:210)
> > at
> >
>
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS
> > treamPipeline.java:359)
> > at
> >
>
org.apache.cocoon.www.mekka.sitemap_xmap.wildcardMatchN40004F(sitemap_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_xmap.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(Application
> > FilterChain.java:247)
> > at
> >
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> > ain.java:193)
> > at
> >
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
> > va:243)
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardContextValve.ja
> > va:190)
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> > 66)
> > at
> >
>
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
> > 46)
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardHostValve.java:180
> > )
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> > 66)
> > at
> >
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
> > java:170)
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> > 64)
> > at
> >
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
> > )
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> > 64)
> > at
> >
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardEngineValve.java
> > :174)
> > at
> >
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(HttpProcessor.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: <co...@xml.apache.org>
> > For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: oradb esql no connection in pool error!
Posted by Andrey Demchenko <de...@kyivstar.net>.
I have the same problem with JDK 1.4
With JDK 1.3.1 it works well.
----- Original Message -----
From: "Jerzy Kut" <je...@rzeszow.tiger.com.pl>
To: <co...@xml.apache.org>
Sent: Friday, March 29, 2002 3:12 PM
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(ServerPagesGenera
> tor.java:212)
> at
>
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv
> entPipeline.java:210)
> at
>
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS
> treamPipeline.java:359)
> at
>
org.apache.cocoon.www.mekka.sitemap_xmap.wildcardMatchN40004F(sitemap_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_xmap.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(Application
> FilterChain.java:247)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> ain.java:193)
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
> va:243)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardContextValve.ja
> va:190)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 66)
> at
>
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
> 46)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardHostValve.java:180
> )
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 66)
> at
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
> java:170)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 64)
> at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
> )
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 64)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardEngineValve.java
> :174)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(HttpProcessor.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(ServerPagesGenera
> tor.java:200)
> at
>
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv
> entPipeline.java:210)
> at
>
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS
> treamPipeline.java:359)
> at
>
org.apache.cocoon.www.mekka.sitemap_xmap.wildcardMatchN40004F(sitemap_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_xmap.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(Application
> FilterChain.java:247)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> ain.java:193)
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
> va:243)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardContextValve.ja
> va:190)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 66)
> at
>
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
> 46)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardHostValve.java:180
> )
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 66)
> at
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
> java:170)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 64)
> at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
> )
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 64)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardEngineValve.java
> :174)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(HttpProcessor.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(ServerPagesGenera
> tor.java:200)
> at
>
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv
> entPipeline.java:210)
> at
>
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS
> treamPipeline.java:359)
> at
>
org.apache.cocoon.www.mekka.sitemap_xmap.wildcardMatchN40004F(sitemap_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_xmap.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(Application
> FilterChain.java:247)
> at
>
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh
> ain.java:193)
> at
>
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja
> va:243)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardContextValve.ja
> va:190)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 66)
> at
>
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:2
> 46)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardHostValve.java:180
> )
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 66)
> at
>
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.
> java:170)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 64)
> at
>
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170
> )
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:5
> 64)
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(StandardEngineValve.java
> :174)
> at
>
org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.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(HttpProcessor.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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: oradb esql no connection in pool error!
Posted by Jerzy Kut <je...@rzeszow.tiger.com.pl>.
Hi - I have resolve of my trouble!
In web.xml file I had got:
<init-param>
<param-name>load-class</param-name>
<param-value>
<!-- For ORACLE database driver: -->
oracle.jdbc.driver.OracleDriver
</param-value>
</init-param>
<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 parent ComponentManager sample:
org.apache.cocoon.samples.parentcm.Configurator
-->
</param-value>
</init-param>
And it WAS a trouble - sorry all for mistake.
It MUST be in ONE <init-param> tag:
<init-param>
<param-name>load-class</param-name>
<param-value>
<!-- For ORACLE database driver: -->
oracle.jdbc.driver.OracleDriver
<!-- For IBM WebSphere:
com.ibm.servlet.classloader.Handler -->
<!-- For Database Driver: -->
org.hsqldb.jdbcDriver
<!-- For parent ComponentManager sample:
org.apache.cocoon.samples.parentcm.Configurator
-->
</param-value>
</init-param>
and then all works good.
Sorry again.
And thank You.
----- Original Message -----
From: "Jerzy Kut" <je...@rzeszow.tiger.com.pl>
To: <co...@xml.apache.org>; <lm...@ieee.org>
Sent: Friday, March 29, 2002 3:00 PM
Subject: Re: oradb esql no connection in pool error!
> 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" <lu...@tin.it>
> To: <co...@xml.apache.org>; <lm...@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: <co...@xml.apache.org>
> > > > For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
> > > For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
> > For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: oradb esql no connection in pool error!
Posted by Jerzy Kut <je...@rzeszow.tiger.com.pl>.
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" <lu...@tin.it>
To: <co...@xml.apache.org>; <lm...@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: <co...@xml.apache.org>
> > > For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
> > For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
RE: oradb esql no connection in pool error!
Posted by Luca Morandini <lu...@tin.it>.
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: <co...@xml.apache.org>
> > For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
RE: oradb esql no connection in pool error!
Posted by Luca Morandini <lu...@tin.it>.
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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>