Re: Cocoon-2.0/Tomcat with Postgres
Alex Kachanov wrote: what seems to be a problem? I use jakarta 4.0.1 and cocoon 2.0.1 and want to use PostgreSQL. I have the following problem: my test page says the following: Hello This is my first Cocoon2 page filled with sql data! This method is not yet implemented. it is just the simple sql page a little modified: ?xml version=1.0? page xmlns:sql=http://apache.org/cocoon/SQL/2.0; titleHello/title content paraThis is my first Cocoon2 page filled with sql data!/para execute-query xmlns=http://apache.org/cocoon/SQL/2.0; query select name, country from doctors /query /execute-query /content /page in psql: heli= select name, country from doctors; name| country +--- Gustav Gans| Tirol Donald Duck| Wien Daisy Duck | Salzburg (3 rows) logs: Processor[8080][0]/SQLTransformer$Query: Caught a SQLException This method is not yet implemented. at org.postgresql.Driver.notImplemented(Driver.java:368) at org.postgresql.jdbc2.Connection.prepareStatement(Connection.java:399) at org.apache.avalon.excalibur.datasource.JdbcConnection.prepareStatement(JdbcConnection.java:172) at org.apache.cocoon.transformation.SQLTransformer$Query.execute(SQLTransformer.java:985) at org.apache.cocoon.transformation.SQLTransformer.executeQuery(SQLTransformer.java:271) at org.apache.cocoon.transformation.SQLTransformer.endExecuteQueryElement(SQLTransformer.java:417) at org.apache.cocoon.transformation.SQLTransformer.endElement(SQLTransformer.java:691) at org.apache.cocoon.components.sax.XMLByteStreamInterpreter.parse(XMLByteStreamInterpreter.java:86) at org.apache.cocoon.components.sax.XMLByteStreamInterpreter.deserialize(XMLByteStreamInterpreter.java:59) at org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEventPipeline.java:177) at org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:355) at org.apache.cocoon.www.sitemap_xmap.matchN104DD(sitemap_xmap.java:6499) at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:3028) at org.apache.cocoon.www.sitemap_xmap.process(sitemap_xmap.java:2432) 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(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:243) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) 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.java:201) . . . and the postmaster says: DEBUG: database system is in production state postmaster: reaping dead processes... postmaster: BackendStartup: pid 3285 user test db heli socket 5 FindExec: searching PATH ... FindExec: found /usr/bin/postgres using PATH DEBUG: StartTransactionCommand DEBUG: CommitTransactionCommand postmaster: BackendStartup: pid 3287 user test db heli socket 5 FindExec: searching PATH ... FindExec: found /usr/bin/postgres using PATH DEBUG: StartTransactionCommand DEBUG: CommitTransactionCommand FindExec: searching PATH ... FindExec: found /usr/bin/postgres using PATH DEBUG: StartTransactionCommand DEBUG: CommitTransactionCommand postmaster: BackendStartup: pid 3288 user test db heli socket 5 FindExec: searching PATH ... FindExec: found /usr/bin/postgres using PATH DEBUG: StartTransactionCommand DEBUG: CommitTransactionCommand postmaster: BackendStartup: pid 3289 user test db heli socket 5 postmaster: BackendStartup: pid 3290 user test db heli socket 5 FindExec: searching PATH ... FindExec: found /usr/bin/postgres using PATH DEBUG: StartTransactionCommand DEBUG: CommitTransactionCommand DEBUG: StartTransactionCommand DEBUG: CommitTransactionCommand postmaster: dumpstatus: I looked at http://lab.applinet.nl/postgresql-jdbc/ and the doku says The PreparedStatement Interface is supported. - Please check that
Re: Cocoon-2.0/Tomcat with Postgres
On Fri, 8 Feb 2002, heli wrote: Alex Kachanov wrote: what seems to be a problem? I use jakarta 4.0.1 and cocoon 2.0.1 and want to use PostgreSQL. I have the following problem: my test page says the following: Hello This is my first Cocoon2 page filled with sql data! This method is not yet implemented. is it possible you're using an old version of the postgresql driver? - donald - 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]
Re: Cocoon-2.0/Tomcat with Postgres
Donald Ball wrote: On Fri, 8 Feb 2002, heli wrote: Alex Kachanov wrote: what seems to be a problem? I use jakarta 4.0.1 and cocoon 2.0.1 and want to use PostgreSQL. I have the following problem: my test page says the following: Hello This is my first Cocoon2 page filled with sql data! This method is not yet implemented. is it possible you're using an old version of the postgresql driver? - donald - 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] thank you, i installed the rpms for postgresql 7.1.3 and the corresponding jdbc rpm but it looks like they have jdbc7.0-1.2.jar instead of jdbc7.1-1.2.jar bye heli -- __ ____ ____ _____ / // /__ / /_ _ __ __/ /_ / // /__ (_)__/ /__ ___ / _ / -_) / ' \/ // / __/ / _ / -_) / _ / -_) _ `/ _ `/ -_) __/ /_//_/\__/_/_/_/_/\_,_/\__/ /_//_/\__/_/\_,_/\__/\_, /\_, /\__/_/ /___//___/ - 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]