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"> <title>Hello</title> <content> <para>This 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 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]>