Hi Dom, I have followed these steps but I get the following error when I request the url from the web browser:
> javax.servlet.ServletException: org.apache.cocoon.ProcessingException: > Failed to process pipeline > at <map:serialize type="xml"> - > file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:45:36 > at <map:transform type="sql"> - > file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:39:35 > at <map:generate> - > file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:38:42 > at <map:match> - > file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:37:37 > at > org.apache.cocoon.servlet.RequestProcessor.service(RequestProcessor.java:232) > at > org.apache.cocoon.sitemap.SitemapServlet.service(SitemapServlet.java:64) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) > at > org.apache.cocoon.servletservice.ServletServiceContext$PathDispatcher.forward(ServletServiceContext.java:567) > at > org.apache.cocoon.servletservice.ServletServiceContext$PathDispatcher.forward(ServletServiceContext.java:544) > at > org.apache.cocoon.servletservice.spring.ServletFactoryBean$ServiceInterceptor.invoke(ServletFactoryBean.java:230) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:166) > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) > at $Proxy5.service(Unknown Source) > at > org.apache.cocoon.servletservice.DispatcherServlet.service(DispatcherServlet.java:102) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) > at > org.apache.cocoon.tools.rcl.wrapper.servlet.ReloadingServlet.service(ReloadingServlet.java:89) > at > org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487) > at > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093) > at > org.apache.cocoon.servlet.multipart.MultipartFilter.doFilter(MultipartFilter.java:119) > at > org.apache.cocoon.tools.rcl.wrapper.servlet.ReloadingServletFilter.doFilter(ReloadingServletFilter.java:50) > at > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) > at org.apache.cocoon.servlet.DebugFilter.doFilter(DebugFilter.java:169) > at > org.apache.cocoon.tools.rcl.wrapper.servlet.ReloadingServletFilter.doFilter(ReloadingServletFilter.java:50) > at > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) > at > org.apache.cocoon.tools.rcl.wrapper.servlet.ReloadingSpringFilter.doFilter(ReloadingSpringFilter.java:69) > at > org.apache.cocoon.tools.rcl.wrapper.servlet.ReloadingServletFilter.doFilter(ReloadingServletFilter.java:50) > at > org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1084) > at > org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360) > at > org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216) > at > org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181) > at > org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:712) > at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405) > at > org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:211) > at > org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:114) > at > org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:139) > at org.mortbay.jetty.Server.handle(Server.java:313) > at > org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:506) > at > org.mortbay.jetty.HttpConnection$RequestHandler.headerComplete(HttpConnection.java:830) > at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:514) > at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211) > at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:381) > at > org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:396) > at > org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:442) > Caused by: org.apache.cocoon.ProcessingException: Failed to process > pipeline > at <map:serialize type="xml"> - > file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:45:36 > at <map:transform type="sql"> - > file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:39:35 > at <map:generate> - > file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:38:42 > at <map:match> - > file:///home/caribdis/cocoon/bloqueBD2/./src/main/resources/COB-INF/sitemap.xmap:37:37 > at > org.apache.cocoon.ProcessingException.throwLocated(ProcessingException.java:143) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.handleException(AbstractProcessingPipeline.java:921) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.setupPipeline(AbstractProcessingPipeline.java:370) > at > org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.setupPipeline(AbstractCachingProcessingPipeline.java:727) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.preparePipeline(AbstractProcessingPipeline.java:464) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process(AbstractProcessingPipeline.java:409) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:597) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:72) > at $Proxy8.process(Unknown Source) > at > org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode.invoke(SerializeNode.java:144) > at > org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:55) > at > org.apache.cocoon.components.treeprocessor.sitemap.MatchNode.invoke(MatchNode.java:87) > at > org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:77) > at > org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(PipelineNode.java:151) > at > org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.invokeNodes(AbstractParentProcessingNode.java:77) > at > org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(PipelinesNode.java:93) > at > org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:240) > at > org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process(ConcreteTreeProcessor.java:171) > at > org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreeProcessor.java:251) > at > org.apache.cocoon.servlet.RequestProcessor.process(RequestProcessor.java:357) > at > org.apache.cocoon.servlet.RequestProcessor.service(RequestProcessor.java:171) > ... 38 more > Caused by: org.springframework.beans.factory.BeanCreationException: Error > creating bean with name > 'org.apache.cocoon.transformation.Transformer/sqlPooled': Initialization > of bean failed; nested exception is java.lang.NoSuchMethodError: > org.apache.cocoon.transformation.SQLTransformer.getLogger()Lorg/apache/commons/logging/Log; > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:448) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:270) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:160) > at > org.apache.cocoon.core.container.spring.avalon.PoolableFactoryBean.getFromPool(PoolableFactoryBean.java:212) > at > org.apache.cocoon.core.container.spring.avalon.PoolableProxyHandler.invoke(PoolableProxyHandler.java:68) > at $Proxy9.setup(Unknown Source) > at > org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.setupPipeline(AbstractProcessingPipeline.java:354) > ... 59 more > Caused by: java.lang.NoSuchMethodError: > org.apache.cocoon.transformation.SQLTransformer.getLogger()Lorg/apache/commons/logging/Log; > at > org.apache.cocoon.transformation.SQLTransformer.configure(SQLTransformer.java:278) > at > org.apache.avalon.framework.container.ContainerUtil.configure(ContainerUtil.java:202) > at > org.apache.cocoon.core.container.spring.avalon.AvalonBeanPostProcessor.postProcessBeforeInitialization(AvalonBeanPostProcessor.java:235) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyBeanPostProcessorsBeforeInitialization(AbstractAutowireCapableBeanFactory.java:301) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1167) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:425) > ... 65 more > Dominic Tootell-2 wrote: > > Inside your cocoon 2 block: > > > 1) inside > src/main/resources/META-INF/cocoon/avalon/custom-sitemap-compents.xconf > put: > > <map:components> > > ..... > > <map:transformers> > <map:transformer logger="sitemap.transformer.sql" > name="sql" src="org.apache.cocoon.transformation.SQLTransformer"/> > > .... > > </map:transformers> > </map:components> > > > 2) in the block pom.xml: > > <dependency> > <groupId>org.apache.cocoon</groupId> > <artifactId>cocoon-databases-impl</artifactId> > <version>1.0.0</version> > </dependency> > <dependency> > <groupId>oracle</groupId> > <artifactId>oracle-jdbc</artifactId> > <version>10.2.0.4</version> > </dependency> > I have installed oracle XE 10.2.0.1.0, so I put my version instead of yours (10.2.0.4). When I build the block, I got an artifact missing error (oracle:oracle-jdbc:jar:10.2.0.1.0), so I downloaded from the http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html oracle's web page the http://download.oracle.com/otn/utilities_drivers/jdbc/10201/ojdbc14.jar ojdbc14.jar driver. After that, I installed the driver whith: mvn install:install-file -DgroupId=oracle -DartifactId=oracle-jdbc -Dversion=10.2.0.1.0 -Dpackaging -Dfile=ojdbc14.jar Do I load wrong the jdbc driver? Is it the root of my error? Thank you. > 3) inside src/main/resources/META-INF/cocoon/spring/datasources.xml > > <beans xmlns="http://www.springframework.org/schema/beans"; > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; > xsi:schemaLocation="http://www.springframework.org/schema/beans > http://www.springframework.org/schema/beans/spring-beans-2.0.xsd";> > > <bean > name="org.apache.avalon.excalibur.datasource.DataSourceComponent/lastmod > " > class="org.apache.cocoon.databases.bridge.spring.avalon.SpringToAvalonDa > taSourceWrapper"> > <property name="wrappedBean"> > <bean > class="org.springframework.jdbc.datasource.DriverManagerDataSource" > > <property name="driverClassName" > value="oracle.jdbc.driver.OracleDriver"/> > <property name="url" > value="jdbc:oracle:thin:@cmcdev2007:1521:cmccis"/> > <property name="username" value="xxxx"/> > <property name="password" value="xxxxx"/> > </bean> > </property> > </bean> > </beans> > > 4) inside src/main/resources/COB-INF/sitemap.xmap: > > <map:match pattern="runsql/*"> > <map:generate src="sql/sql.xml"/> > <map:transform type="sql"> > <map:parameter > name="use-connection" value="lastmod"/> > <map:parameter > name="show-nr-of-rows" value="true"/> > <map:parameter > name="clob-encoding" value="UTF-8"/> > <map:parameter name="date" > value="{1}"/> > </map:transform> > <map:serialize type="xml"/> > </map:match> > > > 5) inside src/main/resources/COB-INF/sql/sql.xml: > > <?xml version="1.0" encoding="UTF-8"?> > <page> > <title>Hello</title> > <content> > <para>The following concepts were modified since:</para> > <sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0";> > > <sql:query name="lastmod"> > SELECT * FROM DALCONCEPT_LASTMOD > WHERE LASTMODIFIED >= TO_DATE('<sql:substitute-value > sql:name="date"/>','YYYYMMDD') > </sql:query> > </sql:execute-query> > </content> > </page> > > > I agree with the others though.... Hibernate + Spring should be used for > any production type app, for a quick mock up, the above should work > without having to go near Spring + Hibernate. > > /dom > > -- View this message in context: http://www.nabble.com/Database-connection-by-cocoon-2.2-tp17674320p19535506.html Sent from the Cocoon - Users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
