Hi! I had got similar (I think) trouble last time. Read this below in forwarded mail. Sorry if I misunderstand :) Regards Jerzy Kut
----- Original Message ----- From: "Jerzy Kut" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 29, 2002 4:24 PM Subject: Re: oradb esql no connection in pool error! > 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" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > 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" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > > Sent: Friday, March 29, 2002 2:52 PM > > Subject: RE: oradb esql no connection in pool error! > > > > > > > Sorry, I meant "classes12.jar" not "classes.jar" :( > > > > > > > > > --------------------------------------------- > > > Luca Morandini > > > GIS Consultant > > > [EMAIL PROTECTED] > > > http://utenti.tripod.it/lmorandini/index.html > > > --------------------------------------------- > > > > > > > > > > -----Original Message----- > > > > From: Luca Morandini [mailto:[EMAIL PROTECTED]] > > > > Sent: Friday, March 29, 2002 2:48 PM > > > > To: [EMAIL PROTECTED] > > > > Subject: RE: oradb esql no connection in pool error! > > > > > > > > > > > > Jerzy, > > > > > > > > try renaming classes12.zip to classes.jar > > > > > > > > Regards, > > > > > > > > --------------------------------------------- > > > > Luca Morandini > > > > GIS Consultant > > > > [EMAIL PROTECTED] > > > > http://utenti.tripod.it/lmorandini/index.html > > > > --------------------------------------------- > > > > > > > > > > > > > -----Original Message----- > > > > > From: Jerzy Kut [mailto:[EMAIL PROTECTED]] > > > > > Sent: Friday, March 29, 2002 2:13 PM > > > > > To: [EMAIL PROTECTED] > > > > > Subject: oradb esql no connection in pool error! > > > > > > > > > > > > > > > Hi cocooners! > > > > > I have got win2k, tomcat4.0.2, cocoon2.0.1. > > > > > I have oracle driver classes12.zip in CLASSPATH. > > > > > When I run this snippet I got exception: > > > > > > > > > > Cocoon 2 - Internal server error > > > > > > > > > > type internal-server-error > > > > > message Exception in ServerPagesGenerator.generate() > > > > > description org.apache.cocoon.ProcessingException: Exception in > > > > > ServerPagesGenerator.generate(): java.lang.RuntimeException: > > > > Could not get > > > > > the datasource java.sql.SQLException: There are no connections in > > > > > the pool, > > > > > check your settings. > > > > > sender org.apache.cocoon.servlet.CocoonServlet > > > > > source Cocoon servlet > > > > > request-uri > > > > > /cocoon/mekka/main > > > > > exception > > > > > org.apache.cocoon.ProcessingException: Exception in > > > > > ServerPagesGenerator.generate(): java.lang.RuntimeException: > > > > Could not get > > > > > the datasource java.sql.SQLException: There are no connections in > > > > > the pool, > > > > > check your settings. > > > > > path-info > > > > > mekka/main > > > > > stacktrace > > > > > org.apache.cocoon.ProcessingException: Exception in > > > > > ServerPagesGenerator.generate(): java.lang.RuntimeException: > > > > Could not get > > > > > the datasource java.sql.SQLException: There are no connections in > > > > > the pool, > > > > > check your settings. > > > > > at > > > > > org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerP > > > > > agesGenera > > > > > tor.java:212) > > > > > at > > > > > org.apache.cocoon.components.pipeline.CachingEventPipeline.process > > > > > (CachingEv > > > > > entPipeline.java:210) > > > > > at > > > > > org.apache.cocoon.components.pipeline.CachingStreamPipeline.proces > > > > > s(CachingS > > > > > treamPipeline.java:359) > > > > > at > > > > > org.apache.cocoon.www.mekka.sitemap_xmap.wildcardMatchN40004F(site > > > > > map_xmap.j > > > > > ava:630) > > > > > at > > > > > > > org.apache.cocoon.www.mekka.sitemap_xmap.process(sitemap_xmap.java:487) > > > > > at > > > > > > > org.apache.cocoon.www.mekka.sitemap_xmap.process(sitemap_xmap.java:445) > > > > > at org.apache.cocoon.sitemap.Handler.process(Handler.java:163) > > > > > at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114) > > > > > at > > > > > org.apache.cocoon.www.sitemap_xmap.wildcardMatchN400209(sitemap_xm > > > > > ap.java:31 > > > > > 22) > > > > > at > org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2509) > > > > > at > org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2462) > > > > > at org.apache.cocoon.sitemap.Handler.process(Handler.java:163) > > > > > at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114) > > > > > at org.apache.cocoon.Cocoon.process(Cocoon.java:514) > > > > > at > > > > > > > org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:647) > > > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > > > > at > > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(A > > > > > pplication > > > > > FilterChain.java:247) > > > > > at > > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicati > > > > > onFilterCh > > > > > ain.java:193) > > > > > at > > > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapp > > > > > erValve.ja > > > > > va:243) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 66) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > > > > > java:472) > > > > > at > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > > at > > > > > org.apache.catalina.core.StandardContextValve.invoke(StandardConte > > > > > xtValve.ja > > > > > va:190) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 66) > > > > > at > > > > > org.apache.catalina.valves.CertificatesValve.invoke(CertificatesVa > > > > > lve.java:2 > > > > > 46) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 64) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > > > > > java:472) > > > > > at > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > > at > > > > > > > > > > > org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343) > > > > > at > > > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValv > > > > > e.java:180 > > > > > ) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 66) > > > > > at > > > > > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispat > > > > > cherValve. > > > > > java:170) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 64) > > > > > at > > > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValv > > > > > e.java:170 > > > > > ) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 64) > > > > > at > > > > > > > > > > > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 64) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > > > > > java:472) > > > > > at > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > > at > > > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngine > > > > > Valve.java > > > > > :174) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 66) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > > > > > java:472) > > > > > at > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > > at > > > > > org.apache.catalina.connector.http.HttpProcessor.process(HttpProce > > > > > ssor.java: > > > > > 1012) > > > > > at > > > > > org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor > > > > > .java:1107 > > > > > ) > > > > > at java.lang.Thread.run(Thread.java:484) > > > > > java.lang.RuntimeException: Could not get the datasource > > > > > java.sql.SQLException: There are no connections in the pool, check > > your > > > > > settings. > > > > > at org.apache.cocoon.www.mekka.main_xml.generate(main_xml.java:366) > > > > > at > > > > > org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerP > > > > > agesGenera > > > > > tor.java:200) > > > > > at > > > > > org.apache.cocoon.components.pipeline.CachingEventPipeline.process > > > > > (CachingEv > > > > > entPipeline.java:210) > > > > > at > > > > > org.apache.cocoon.components.pipeline.CachingStreamPipeline.proces > > > > > s(CachingS > > > > > treamPipeline.java:359) > > > > > at > > > > > org.apache.cocoon.www.mekka.sitemap_xmap.wildcardMatchN40004F(site > > > > > map_xmap.j > > > > > ava:630) > > > > > at > > > > > > > org.apache.cocoon.www.mekka.sitemap_xmap.process(sitemap_xmap.java:487) > > > > > at > > > > > > > org.apache.cocoon.www.mekka.sitemap_xmap.process(sitemap_xmap.java:445) > > > > > at org.apache.cocoon.sitemap.Handler.process(Handler.java:163) > > > > > at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114) > > > > > at > > > > > org.apache.cocoon.www.sitemap_xmap.wildcardMatchN400209(sitemap_xm > > > > > ap.java:31 > > > > > 22) > > > > > at > org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2509) > > > > > at > org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2462) > > > > > at org.apache.cocoon.sitemap.Handler.process(Handler.java:163) > > > > > at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114) > > > > > at org.apache.cocoon.Cocoon.process(Cocoon.java:514) > > > > > at > > > > > > > org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:647) > > > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > > > > at > > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(A > > > > > pplication > > > > > FilterChain.java:247) > > > > > at > > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicati > > > > > onFilterCh > > > > > ain.java:193) > > > > > at > > > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapp > > > > > erValve.ja > > > > > va:243) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 66) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > > > > > java:472) > > > > > at > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > > at > > > > > org.apache.catalina.core.StandardContextValve.invoke(StandardConte > > > > > xtValve.ja > > > > > va:190) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 66) > > > > > at > > > > > org.apache.catalina.valves.CertificatesValve.invoke(CertificatesVa > > > > > lve.java:2 > > > > > 46) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 64) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > > > > > java:472) > > > > > at > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > > at > > > > > > > > > > > org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343) > > > > > at > > > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValv > > > > > e.java:180 > > > > > ) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 66) > > > > > at > > > > > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispat > > > > > cherValve. > > > > > java:170) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 64) > > > > > at > > > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValv > > > > > e.java:170 > > > > > ) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 64) > > > > > at > > > > > > > > > > > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 64) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > > > > > java:472) > > > > > at > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > > at > > > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngine > > > > > Valve.java > > > > > :174) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 66) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > > > > > java:472) > > > > > at > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > > at > > > > > org.apache.catalina.connector.http.HttpProcessor.process(HttpProce > > > > > ssor.java: > > > > > 1012) > > > > > at > > > > > org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor > > > > > .java:1107 > > > > > ) > > > > > at java.lang.Thread.run(Thread.java:484) > > > > > > > > > > original exception > > > > > Original exception : java.lang.RuntimeException: Could not get the > > > > > datasource java.sql.SQLException: There are no connections in the > > pool, > > > > > check your settings. > > > > > at org.apache.cocoon.www.mekka.main_xml.generate(main_xml.java:366) > > > > > at > > > > > org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerP > > > > > agesGenera > > > > > tor.java:200) > > > > > at > > > > > org.apache.cocoon.components.pipeline.CachingEventPipeline.process > > > > > (CachingEv > > > > > entPipeline.java:210) > > > > > at > > > > > org.apache.cocoon.components.pipeline.CachingStreamPipeline.proces > > > > > s(CachingS > > > > > treamPipeline.java:359) > > > > > at > > > > > org.apache.cocoon.www.mekka.sitemap_xmap.wildcardMatchN40004F(site > > > > > map_xmap.j > > > > > ava:630) > > > > > at > > > > > > > org.apache.cocoon.www.mekka.sitemap_xmap.process(sitemap_xmap.java:487) > > > > > at > > > > > > > org.apache.cocoon.www.mekka.sitemap_xmap.process(sitemap_xmap.java:445) > > > > > at org.apache.cocoon.sitemap.Handler.process(Handler.java:163) > > > > > at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114) > > > > > at > > > > > org.apache.cocoon.www.sitemap_xmap.wildcardMatchN400209(sitemap_xm > > > > > ap.java:31 > > > > > 22) > > > > > at > org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2509) > > > > > at > org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2462) > > > > > at org.apache.cocoon.sitemap.Handler.process(Handler.java:163) > > > > > at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:114) > > > > > at org.apache.cocoon.Cocoon.process(Cocoon.java:514) > > > > > at > > > > > > > org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:647) > > > > > at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) > > > > > at > > > > > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(A > > > > > pplication > > > > > FilterChain.java:247) > > > > > at > > > > > org.apache.catalina.core.ApplicationFilterChain.doFilter(Applicati > > > > > onFilterCh > > > > > ain.java:193) > > > > > at > > > > > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapp > > > > > erValve.ja > > > > > va:243) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 66) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > > > > > java:472) > > > > > at > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > > at > > > > > org.apache.catalina.core.StandardContextValve.invoke(StandardConte > > > > > xtValve.ja > > > > > va:190) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 66) > > > > > at > > > > > org.apache.catalina.valves.CertificatesValve.invoke(CertificatesVa > > > > > lve.java:2 > > > > > 46) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 64) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > > > > > java:472) > > > > > at > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > > at > > > > > > > > > > > org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2343) > > > > > at > > > > > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValv > > > > > e.java:180 > > > > > ) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 66) > > > > > at > > > > > org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispat > > > > > cherValve. > > > > > java:170) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 64) > > > > > at > > > > > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValv > > > > > e.java:170 > > > > > ) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 64) > > > > > at > > > > > > > > > > > org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:468) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 64) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > > > > > java:472) > > > > > at > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > > at > > > > > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngine > > > > > Valve.java > > > > > :174) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipel > > > > > ine.java:5 > > > > > 66) > > > > > at > > > > > org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline. > > > > > java:472) > > > > > at > > > > org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) > > > > > at > > > > > org.apache.catalina.connector.http.HttpProcessor.process(HttpProce > > > > > ssor.java: > > > > > 1012) > > > > > at > > > > > org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor > > > > > .java:1107 > > > > > ) > > > > > at java.lang.Thread.run(Thread.java:484) > > > > > > > > > > And there are my files: > > > > > main.xml > > > > > > > > > > <esql:connection> > > > > > <esql:pool>epayroll</esql:pool> > > > > > <esql:execute-query> > > > > > <esql:query> > > > > > select E1.EMPNO, E1.ENAME, E1.JOB, E2.EMPNO MGRNO, E2.ENAME MGR, > > > > > E1.HIREDATE, E1.SAL, E1.COMM, D.DEPTNO, D.DNAME > > > > > from EMP E1, EMP E2, DEPT D > > > > > where E1.DEPTNO = D.DEPTNO > > > > > and E1.MGR = E2.EMPNO (+) > > > > > </esql:query> > > > > > <esql:results> > > > > > <esql:row-results> > > > > > <employee> > > > > > <employee-id><esql:get-long column="EMPNO"/></employee-id> > > > > > <employee-name><esql:get-string > column="ENAME"/></employee-name> > > > > > <job><esql:get-string column="JOB"/></job> > > > > > <hiredate><esql:get-date column="HIREDATE"/></hiredate> > > > > > <manager-name><esql:get-string column="MGR"/></manager-name> > > > > > <manager-id><esql:get-long column="MGRNO"/></manager-id> > > > > > <salary><esql:get-double column="SAL"/></salary> > > > > > <comm><esql:get-string column="COMM"/></comm> > > > > > <department-id><esql:get-long > column="DEPTNO"/></department-id> > > > > > <department-name><esql:get-string > > > > column="DNAME"/></department-name> > > > > > </employee> > > > > > </esql:row-results> > > > > > </esql:results> > > > > > <esql:no-results>Brak danych!</esql:no-results> > > > > > </esql:execute-query> > > > > > </esql:connection> > > > > > > > > > > cocoon.xconf > > > > > > > > > > <jdbc name="epayroll"> > > > > > <pool-controller min="5" max="10" oradb="true"/> > > > > > <dburl>jdbc:oracle:thin:@10.0.0.100:1521:epayroll</dburl> > > > > > <user>scott</user> > > > > > <password>tiger</password> > > > > > </jdbc> > > > > > > > > > > web.xml > > > > > > > > > > <init-param> > > > > > <param-name>load-class</param-name> > > > > > <param-value> > > > > > <!-- For ORACLE database driver: --> > > > > > oracle.jdbc.driver.OracleDriver > > > > > </param-value> > > > > > </init-param> > > > > > > > > > > Where is the problem? And what? > > > > > > > > > > The best regards > > > > > Jerzy Kut > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > Please check that your question has not already been answered in the > > > > > FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> > > > > > > > > > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > > > > > For additional commands, e-mail: <[EMAIL PROTECTED]> > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > Please check that your question has not already been answered in the > > > > FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> > > > > > > > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > > > > For additional commands, e-mail: <[EMAIL PROTECTED]> > > > > > > > > > > > > > --------------------------------------------------------------------- > > > Please check that your question has not already been answered in the > > > FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> > > > > > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > > > For additional commands, e-mail: <[EMAIL PROTECTED]> > > > > > > --------------------------------------------------------------------- > > Please check that your question has not already been answered in the > > FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> > > > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > > For additional commands, e-mail: <[EMAIL PROTECTED]> > > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> ----- Original Message ----- From: "Aitziber Zubieta" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 18, 2002 1:19 PM Subject: Problems whit SQL Server drivers Hi all I'm trying to make a connection with Sql Server. can anybody tell me: how are the drivers that I have to use and where do I have to put them? I've tried with: In the web.xml file I have added: <init-param> <param-name>load-class</param-name> <param-value> <--JDBC:ODBC--> com.ms.jdbc.odbc.JdbcOdbcDriver </param-value> </init-param> In the cocoon.xconf: <jdbc name="nombres"> <dburl>jdbc:odbc:10.100.1.2:1433:Databases/Pruebas</dburl><!--I think this is wrong <user>sa</user> <password>jdbccon</password> </jdbc> In the sitemap.xmap: <map:match pattern="sql/*"> <map:generate src="docs/samples/sql/{1}.xml"/> <map:transform type="sql"> <map:parameter name="use-connection" value="nombres"/> </map:transform> <map:transform src="stylesheets/simple-sql2html.xsl"/> <map:serialize/> </map:match> please can anyone help me? Thanks... --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]> --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
