Hello, I'm trying to make an XML-application with a connection to a MySQL-database. I have the following database.xml:
<?xml version="1.0"?> <page xmlns:sql="http://apache.org/cocoon/SQL/2.0"> <programma> <sql:execute-query> <sql:query>select datum from rooster where maand='januari'</sql:query> </sql:execute-query> </programma> </page> In my sitemap.xmap: <map:match pattern="*.xml"> <map:generate src="{1}.xml"/> <map:transform type="sql"> <map:parameter name="use-connection" value="stretchers"/> </map:transform> <map:transform src="{1}-html.xsl"/> <map:serialize/> </map:match> In my cocoon.xconf: <datasources> <jdbc name="stretchers"> <pool-controller min="5" max="10"/> <dburl>jdbc:mysql://localhost/Stretchers</dburl> <user>root</user> <password>******</password> </jdbc> </datasources> In my web.xml: <init-param> <param-name>load-class</param-name> <param-value> <!-- For MySQL Database --> org.gjt.mm.mysql.Driver </param-value> </init-param> I have put mm.mysql-2.0.11-bin.jar in %Cocoon%/WEB-INF/lib I get the following error in %Cocoon%/WEB-INF/logs/core.log.000001: DEBUG (2002-02-28) 09:33.49:702 [core] (Unknown-URI) Unknown-thread/LogKitLogger: factory created class was null so a new instance could not be created. org.apache.avalon.excalibur.datasource.NoValidConnectionException: No valid JdbcConnection class available at org.apache.avalon.excalibur.datasource.JdbcConnectionFactory.newInstance(Jdb cConnectionFactory.java:183) at org.apache.avalon.excalibur.pool.AbstractPool.newPoolable(AbstractPool.java: 82) at org.apache.avalon.excalibur.pool.HardResourceLimitingPool.newPoolable(HardRe sourceLimitingPool.java:95) at org.apache.avalon.excalibur.datasource.JdbcConnectionPool.newPoolable(JdbcCo nnectionPool.java:74) at org.apache.avalon.excalibur.pool.AbstractPool.internalGrow(AbstractPool.java :126) at org.apache.avalon.excalibur.pool.HardResourceLimitingPool.internalGrow(HardR esourceLimitingPool.java:104) at org.apache.avalon.excalibur.pool.SoftResourceLimitingPool.grow(SoftResourceL imitingPool.java:91) at org.apache.avalon.excalibur.datasource.JdbcConnectionPool.run(JdbcConnection Pool.java:195) at java.lang.Thread.run(Thread.java:536) FATAL_E (2002-02-28) 09:33.49:802 [core] (Unknown-URI) Unknown-thread/LogKitLogger: Excalibur could not create any connections. Examine your settings to make sure they are correct. Make sure you can connect with the same settings on your machine. ... WARN (2002-02-28) 09:47.24:762 [core] (/stretchers/database.xml) Ajp13Processor[8009][4]/LogKitLogger: Could not return Connection java.lang.IllegalStateException: There are no connections in the pool, check your settings. at org.apache.avalon.excalibur.datasource.JdbcConnectionPool.get(JdbcConnection Pool.java:124) at org.apache.avalon.excalibur.datasource.JdbcDataSource.getConnection(JdbcData Source.java:201) at org.apache.cocoon.transformation.SQLTransformer$Query.getConnection(SQLTrans former.java:923) at org.apache.cocoon.transformation.SQLTransformer$Query.execute(SQLTransformer .java:978) at org.apache.cocoon.transformation.SQLTransformer.executeQuery(SQLTransformer. java:271) at org.apache.cocoon.transformation.SQLTransformer.endExecuteQueryElement(SQLTr ansformer.java:417) at org.apache.cocoon.transformation.SQLTransformer.endElement(SQLTransformer.ja va:691) at org.apache.cocoon.components.sax.XMLTeePipe.endElement(XMLTeePipe.java:81) at org.apache.xerces.parsers.SAXParser.endElement(SAXParser.java:1403) at org.apache.xerces.validators.common.XMLValidator.callEndElement(XMLValidator .java:1550) at org.apache.xerces.framework.XMLDocumentScanner$ContentDispatcher.dispatch(XM LDocumentScanner.java:1204) at org.apache.xerces.framework.XMLDocumentScanner.parseSome(XMLDocumentScanner. java:381) at org.apache.xerces.framework.XMLParser.parse(XMLParser.java:1098) at org.apache.cocoon.components.parser.JaxpParser.parse(JaxpParser.java:182) at org.apache.cocoon.components.source.URLSource.toSAX(URLSource.java:331) at org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:109) at org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv entPipeline.java:209) at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS treamPipeline.java:355) at org.apache.cocoon.www.sitemap_xmap.matchN10216(sitemap_xmap.java:1711) at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1472) at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:1409) at org.apache.cocoon.sitemap.Handler.process(Handler.java:180) at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:127) at org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:144) at org.apache.cocoon.Cocoon.process(Cocoon.java:582) at org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:795) 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:201) 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:2344) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164 ) 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:462) 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 :163) 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.ajp.tomcat4.Ajp13Processor.process(Ajp13Processor.java:371) at org.apache.ajp.tomcat4.Ajp13Processor.run(Ajp13Processor.java:424) at java.lang.Thread.run(Thread.java:536) ... And in %Cocoon%/WEB-INF/logs/error.log.000001: FATAL_E (2002-02-28) 09:33.49:802 [core] (Unknown-URI) Unknown-thread/LogKitLogger: Excalibur could not create any connections. Examine your settings to make sure they are correct. Make sure you can connect with the same settings on your machine. ERROR (2002-02-28) 09:47.19:565 [sitemap.generator.velocity] (/stretchers/database.xml) Ajp13Processor[8009][4]/VelocityGenerator: ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader. ERROR (2002-02-28) 09:47.19:595 [sitemap.generator.velocity] (/stretchers/database.xml) Ajp13Processor[8009][4]/VelocityGenerator: ResourceManager : unable to find resource 'VM_global_library.vm' in any resource loader. What is wrong? Have I forgotten something? What should I do? Regards Richard Korthuis --------------------------------------------------------------------- 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]>