I'm making progress - I've finally figured out the minimal necessary
changes to load the jdbc driver for postgres ( posgresql 7.0.3, linux
RH 7.1, Sun JDK 1.3.1 ).
Unfortunately, I still get an error when I try Simple SQL from the
welcome screen - from cocoon.log:
DEBUG 62403 [cocoon ] (Thread-8): Retrieving a
org.apache.avalon.excalibur.datasource.JdbcConnection from the pool
ERROR 62442 [cocoon ] (Thread-8): 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:241)
at
org.apache.cocoon.transformation.SQLTransformer$Query.execute(SQLTransformer.java:820)
at
org.apache.cocoon.transformation.SQLTransformer.executeQuery(SQLTransformer.java:230)
at
org.apache.cocoon.transformation.SQLTransformer.endExecuteQueryElement(SQLTransformer.java:362)
and many more similar ones follow.
As I read this, it's saying that the postgresql driver doesn't
implement the perpareStament method, but the docs say it does!
Has anyone got jdbc working with postgres and Cocoon 2?
Or has anyone any other suggestions?
--
Colin Paul Adams
Preston Lancashire
---------------------------------------------------------------------
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]>
