You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cocoon.apache.org by John Pacubas <Jo...@cnet.com> on 2006/03/09 08:10:30 UTC
Netezza JDBC 3.0 Driver not supported
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?
Thanks in advance.
John
********* ESQL Logic Stack Trace ****************
WARN (2006-03-08) 22:16.42:885 [sitemap.generator.serverpages]
(/cocoon/dwxml/activity_site.xsp)
http-8080-Processor25/AbstractEsqlConnection: Your database [netezza
nps] is not being recognized yet. Using the generic [jdbc] query as
default. Please report this to dev@cocoon.apache.org
ERROR (2006-03-08) 22:16.42:975 [sitemap.handled-errors]
(/cocoon/dwxml/activity_site.xsp)
http-8080-Processor25/ErrorHandlerHelper: Exception in
ServerPagesGenerator.generate()
at <map:serialize type="xml"> -
file:/C:/cygwin/usr/local/tomcat55/webapps/cocoon/dwxml/sitemap.xmap:187
:32
at <map:generate type="serverpages"> -
file:/C:/cygwin/usr/local/tomcat55/webapps/cocoon/dwxml/sitemap.xmap:186
:62
at <map:mount> -
file:/C:/cygwin/usr/local/tomcat55/webapps/cocoon/sitemap.xmap:893:66
java.lang.RuntimeException: Error executing statement: select * from
pt_activity_site_day where day='2006-02-28': This method is not yet
implemented.
at
org.apache.cocoon.www.dwxml.activity_site_xsp.generate(org.apache.cocoon
.www.dwxml.activity_site_xsp:624)
at
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGe
nerator.java:228)
at
org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process
XMLPipeline(AbstractProcessingPipeline.java:578)
at
org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipe
line.processXMLPipeline(AbstractCachingProcessingPipeline.java:183)
at
org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process
(AbstractProcessingPipeline.java:480)
at
org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode.invoke(
SerializeNode.java:120)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.
invokeNodes(AbstractParentProcessingNode.java:46)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.i
nvoke(PreparableMatchNode.java:130)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.
invokeNodes(AbstractParentProcessingNode.java:68)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(P
ipelineNode.java:142)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.
invokeNodes(AbstractParentProcessingNode.java:68)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(
PipelinesNode.java:92)
at
org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process
(ConcreteTreeProcessor.java:234)
at
org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process
(ConcreteTreeProcessor.java:176)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreePro
cessor.java:248)
at
org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(Moun
tNode.java:117)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.
invokeNodes(AbstractParentProcessingNode.java:46)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.i
nvoke(PreparableMatchNode.java:130)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.
invokeNodes(AbstractParentProcessingNode.java:68)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(P
ipelineNode.java:142)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.
invokeNodes(AbstractParentProcessingNode.java:68)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(
PipelinesNode.java:92)
at
org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process
(ConcreteTreeProcessor.java:234)
at
org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process
(ConcreteTreeProcessor.java:176)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreePro
cessor.java:248)
at org.apache.cocoon.Cocoon.process(Cocoon.java:679)
at
org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1154)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:85
6)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
at java.lang.Thread.run(Unknown Source)
********* SQLTransformer Stack Trace ****************
INFO (2006-03-08) 22:30.01:042 [sitemap.transformer.sql.query]
(/cocoon/dwxml/activity_site.xml)
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)
at
org.apache.cocoon.transformation.SQLTransformer$Query.executeQuery(SQLTr
ansformer.java:1165)
at
org.apache.cocoon.transformation.SQLTransformer.endExecuteQueryElement(S
QLTransformer.java:456)
at
org.apache.cocoon.transformation.SQLTransformer.endTransformingElement(S
QLTransformer.java:664)
at
org.apache.cocoon.transformation.AbstractSAXTransformer.endElement(Abstr
actSAXTransformer.java:482)
at
org.apache.cocoon.www.dwxml.activity_site_xml.generate(org.apache.cocoon
.www.dwxml.activity_site_xml:426)
at
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGe
nerator.java:228)
at
org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process
XMLPipeline(AbstractProcessingPipeline.java:578)
at
org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipe
line.processXMLPipeline(AbstractCachingProcessingPipeline.java:183)
at
org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.process
(AbstractProcessingPipeline.java:480)
at
org.apache.cocoon.components.treeprocessor.sitemap.SerializeNode.invoke(
SerializeNode.java:120)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.
invokeNodes(AbstractParentProcessingNode.java:46)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.i
nvoke(PreparableMatchNode.java:130)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.
invokeNodes(AbstractParentProcessingNode.java:68)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(P
ipelineNode.java:142)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.
invokeNodes(AbstractParentProcessingNode.java:68)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(
PipelinesNode.java:92)
at
org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process
(ConcreteTreeProcessor.java:234)
at
org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process
(ConcreteTreeProcessor.java:176)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreePro
cessor.java:248)
at
org.apache.cocoon.components.treeprocessor.sitemap.MountNode.invoke(Moun
tNode.java:117)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.
invokeNodes(AbstractParentProcessingNode.java:46)
at
org.apache.cocoon.components.treeprocessor.sitemap.PreparableMatchNode.i
nvoke(PreparableMatchNode.java:130)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.
invokeNodes(AbstractParentProcessingNode.java:68)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelineNode.invoke(P
ipelineNode.java:142)
at
org.apache.cocoon.components.treeprocessor.AbstractParentProcessingNode.
invokeNodes(AbstractParentProcessingNode.java:68)
at
org.apache.cocoon.components.treeprocessor.sitemap.PipelinesNode.invoke(
PipelinesNode.java:92)
at
org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process
(ConcreteTreeProcessor.java:234)
at
org.apache.cocoon.components.treeprocessor.ConcreteTreeProcessor.process
(ConcreteTreeProcessor.java:176)
at
org.apache.cocoon.components.treeprocessor.TreeProcessor.process(TreePro
cessor.java:248)
at org.apache.cocoon.Cocoon.process(Cocoon.java:679)
at
org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:1154)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:85
6)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:744)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
at java.lang.Thread.run(Unknown Source)
INFO (2006-03-08) 22:30.01:042 [access]
(/cocoon/dwxml/activity_site.xml) http-8080-Processor24/CocoonServlet:
'dwxml/activity_site.xml' Processed by Apache Cocoon 2.1.8 in 120
milliseconds.
Re: Netezza JDBC 3.0 Driver not supported
Posted by Sylvain Wallez <sy...@apache.org>.
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