cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bertrand Delacretaz <bdelacre...@codeconsult.ch>
Subject SQLTransformer, AbstractMethodError in prepareStatement
Date Tue, 18 Jun 2002 08:33:09 GMT
I'm trying to access a Basis Plus database using their JDBC driver.

It looks like the connection opens correctly, but then I get "500 internal 
error" from Cocoon, and the following messages in the tomcat logs:

java.lang.AbstractMethodError
        at 
org.apache.avalon.excalibur.datasource.JdbcConnection.prepareStatement(JdbcConnection.java:172)
        at 
org.apache.cocoon.transformation.SQLTransformer$Query.execute(SQLTransformer.java:1014)
. . .

It works fine from an XSP page running in the same instance of Cocoon (going 
directly to JDBC using Class.forName, DriverManager.getConnection and 
Connection.PrepareStatement), meaning the driver supports PreparedStatements.

Suspecting a classloader problem, I tried putting the JDBC driver jar in 
WEB-INF/lib, then in the main lib directory and then even in the JRE lib/ext 
directory, with same results.

Here's what I have in web.xml (works according to the logs):
    <init-param>
      <param-name>load-class</param-name>
      <param-value>
        <!-- for Basis Plus -->
        com.opentext.basis.jdbc.BasisDriver
      </param-value>
    </init-param>

And in cocoon.xconf:

  <datasources>
    <!-- bd BasisPlus -->
    <jdbc logger="core.datasources.basisplus.eiger" name="eiger">
      <pool-controller max="1" min="1"/>
      <dburl>jdbc:opentext:basis://bla:stit@eiger:2033/some_dba</dburl>
      <user>bla</user>
      <password>stit</password>
    </jdbc>

Also seems to work, if I put a wrong password I get the proper error message 
("Could not return connection").

Any clues?

-- 
 Bertrand Delacrétaz (codeconsult.ch, jfor.org)

 buzzwords: XML, java, XSLT, cocoon, mentoring/teaching/coding.
 disclaimer: eternity is very long. mostly towards the end. get ready.






---------------------------------------------------------------------
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