cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rams├ęs Morales <Ramses.Mora...@cwpanama.com>
Subject problems with SQLTransformer
Date Tue, 16 Jul 2002 15:27:47 GMT
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message