If you use postgresql only because you need an open source DB, I suggest you
switch to MySQL. It is a very good DB and the JDBC drivers implement
everything you need. The SQLTransformer worked fine on it.
http://www.mysql.com
http://mmmysql.sourceforge.net/
Sven
> -----Original Message-----
> From: Colin Paul Adams [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 05, 2001 9:14 PM
> To: [EMAIL PROTECTED]
> Subject: [C2] and posgresql
>
>
> 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.prepareS
> tatement(JdbcConnection.java:241)
> at
> org.apache.cocoon.transformation.SQLTransformer$Query.execute(
> SQLTransformer.java:820)
> at
> org.apache.cocoon.transformation.SQLTransformer.executeQuery(S
> QLTransformer.java:230)
> at
> org.apache.cocoon.transformation.SQLTransformer.endExecuteQuer
> yElement(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]>
>
---------------------------------------------------------------------
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]>
