cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Beauprez Sven <Sven.Beaup...@the-ecorp.com>
Subject RE: [C2] and posgresql
Date Fri, 06 Jul 2001 08:14:26 GMT

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:colin@colina.demon.co.uk]
> Sent: Thursday, July 05, 2001 9:14 PM
> To: cocoon-users@xml.apache.org
> 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: <cocoon-users-unsubscribe@xml.apache.org>
> For additional commands, e-mail: <cocoon-users-help@xml.apache.org>
> 

---------------------------------------------------------------------
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: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message