cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sylvain Wallez <sylv...@apache.org>
Subject Re: Netezza JDBC 3.0 Driver not supported
Date Thu, 09 Mar 2006 08:40:44 GMT
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
> org.apache.cocoon.transformation.SQLTransformer$Query@20ba4d
> 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


Mime
View raw message