Hi.
I'm receiving two consecutive unsuported exceptions:
-----------------------------------------------------------------------------------------------
DEBUG (2002-07-16) 10:09.12:987
[sitemap.transformer.sql](/cocoon/LinePlant)
HttpProcessor[8080][4]/SQLTransformer$Query: EXECUTING SELECT
field_value, codes_desc FROM cst_codes
ERROR (2002-07-16) 10:09.13:222
[sitemap.transformer.sql](/cocoon/LinePlant)
HttpProcessor[8080][4]/SQLTransformer$Query: Caught a SQLException
java.sql.SQLException: unsupported
at
com.Connx.jdbc.TCJdbc.TCJdbcConnection.prepareStatement(TCJdbcConnection.java:581)
at
org.apache.avalon.excalibur.datasource.JdbcConnection.prepareStatement(JdbcConnection.java:172)
at
org.apache.cocoon.transformation.SQLTransformer$Query.execute(SQLTransformer.java:1014)
at
org.apache.cocoon.transformation.SQLTransformer.executeQuery(SQLTransformer.java:271)
at
org.apache.cocoon.transformation.SQLTransformer.endExecuteQueryElement(SQLTransformer.java:417)
.
.
.
DEBUG (2002-07-16) 10:09.13:649
[sitemap.transformer.sql](/cocoon/LinePlant)
HttpProcessor[8080][4]/SQLTransformer: SQLTransformer:.executeQuery()
query.execute failed
java.sql.SQLException: unsupported
at
com.Connx.jdbc.TCJdbc.TCJdbcConnection.prepareStatement(TCJdbcConnection.java:581)
at
org.apache.avalon.excalibur.datasource.JdbcConnection.prepareStatement(JdbcConnection.java:172)
at
org.apache.cocoon.transformation.SQLTransformer$Query.execute(SQLTransformer.java:1014)
at
org.apache.cocoon.transformation.SQLTransformer.executeQuery(SQLTransformer.java:271)
.
.
.
------------------------------------------------------------------------------------------------
I'm using a JDBC 1.1.6 driver, compatible with 1.2. I checked the source
code of the transformer, and I don't see why I get that unsupported
exception, I mean, regular JDBC in there.
I saw an "oldDriver" attribute on SQLtransformer.java, so I used it on
cocoon.xconf to see if that would solve the problem (but didn't):
<datasources>
<jdbc logger="core.datasources.database" name="database">
<pool-controller max="10" min="5"/>
<auto-commit>false</auto-commit>
<old-driver>true</old-driver>
<dburl>jdbc:connx:dd=----------;GATEWAY=------------</dburl>
<user>--------</user>
<password>--------</password>
</jdbc>
</datasources>
This is the query:
<execute-query xmlns="http://apache.org/cocoon/SQL/2.0";>
<query name="regiones">SELECT field_value, codes_desc FROM cst_codes
</query>
</execute-query>
This is the transformation part of that pipe:
<map:transform type="sql">
<map:parameter name="use-connection" value="database"/>
</map:transform>
I tested that query with jdbc on a plain java class, and it worked.
Checking SQLTranformer.java, it should be working too. What's wrong??
Thanks for your help.
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
