On 16.May.2002 -- 04:13 PM, Kelly Cole wrote: > Thanks for the quick response... I am using Cocoon 2.0.2, Tomcat 4.0.1 and > JDK 1.3.1_03.
Your versions look reasonable. Have you compiled any of it yourself? > root cause > > java.lang.AbstractMethodError > at > org.apache.avalon.excalibur.datasource.JdbcConnection.prepareStatement(JdbcC > onnection.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(SQLTr > ansformer.java:417) This looks like a JDBC2 / JDBC3 clash for me. But I have to confess, that I'm no expert on this. (Neither do I use DB2, the SQLTransformer nor JDBC3 / j2sdk 1.4). Hopefully, someone else can jump in (Berin?) > query(http://apache.org/cocoon/SQL/2.0) > /SQLTransformer: QUERY IS "select sys_grp_no, sys_grp_name from > testdb2.sysgrps" > /SQLTransformer: RECEIVED CHARACTERS: > /SQLTransformer: RECEIVED END ELEMENT > execute-query(http://apache.org/cocoon/SQL/2.0) > /SQLTransformer: SQLTransformer executing query nr 0 > /SQLTransformer$Query: EXECUTING select sys_grp_no, sys_grp_name from > testdb2.sysgrps Everything fine up to here. Query seems OK. > And finally, here's a snippet of the core.log ("with the > [core.datasources.TDB2](/cocoon/db/test.html) HttpProcessor[8080][4]/" > trimmed off): > LogKitLogger: Marking 0 objects as old in pool. > LogKitLogger: JdbcConnection object created > LogKitLogger: Created a new > org.apache.avalon.excalibur.datasource.JdbcConnection from the object > factory. > LogKitLogger: Got a org.apache.avalon.excalibur.datasource.JdbcConnection > from the pool. > LogKitLogger: Put a org.apache.avalon.excalibur.datasource.JdbcConnection > back into the pool. That looks good. Your connection seems OK. Just for a test: Could you see whether ESQL works with your setup? E.g. take cocoon/docs/samples/xsp/esql.xsp and modify it to use your connection and query. Chris. -- C h r i s t i a n H a u l [EMAIL PROTECTED] fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08 --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
