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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
