John Pacubas wrote:
> I am trying to utilze Netezza, database as a datasource with their JDBC
> 3.0 driver in Apache-Cocoon, v2.1.8. I've have tried both ESQL and
> SQLTransformer to produce XML with very limited success. Some specific
> method in the driver doesn't seem to be implemented. I even tried a
> first pass at modifying the Cocoon databases block source code base by
> copying PostgreSQL specific code as Netezza specific code since Netezza
> was originally based on Postgres... Any wisdom?
>
The answer is here:
> http-8080-Processor24/SQLTransformer.Query: Failed to execute query
> [EMAIL PROTECTED]
> This method is not yet implemented.
> at org.netezza.Driver.notImplemented(Unknown Source)
> at
> org.netezza.jdbc2.AbstractJdbc2Statement.setResultSetType(Unknown
> Source)
> at org.netezza.jdbc3.Jdbc3Connection.prepareStatement(Unknown
> Source)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown
> Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at
> org.apache.avalon.excalibur.datasource.AbstractJdbcConnection.invoke(Abs
> tractJdbcConnection.java:397)
> at $Proxy44.prepareStatement(Unknown Source)
> at
> org.apache.cocoon.transformation.SQLTransformer$Query.execute(SQLTransfo
> rmer.java:1256)
>
Line 1256 reads:
pst = conn.prepareStatement(query,
ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
So it looks like your JDBC driver doesn't support some of these two options.
Sylvain
--
Sylvain Wallez
http://bluxte.net
Apache Software Foundation Member
