Christian,
Thanks again... No, I haven't compiled anything myself. Also, I forgot to
mention I was on Win2k...
I tried the xsp, but I only got the page header ("A Database Driven XSP
Page").
Here's the xsp page I tried:
<xsp:page language="java" xmlns:xsp="http://apache.org/xsp";
xmlns:esql="http://apache.org/cocoon/SQL/v2";>
<page>
<title>A Database Driven XSP Page</title>
<content>
<esql:connection>
<esql:pool>TDB2</esql:pool>
<esql:execute-query>
<esql:query>select * from
testdb2.sysgrps</esql:query>
<esql:results>
<esql:row-results>
<para>
<esql:get-string column="name"/>
</para>
<esql:get-columns/>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
</content>
</page>
</xsp:page>
Here's some of the core.log (the "pinging" stuff looks new...:
LogKitLogger: Marking 1 objects as old in pool.
LogKitLogger: Got a org.apache.avalon.excalibur.datasource.JdbcConnection
from the pool.
LogKitLogger: Pinging database after 690593ms of inactivity.
LogKitLogger: JdbcConnection was closed.
LogKitLogger: Removing a
org.apache.avalon.excalibur.datasource.JdbcConnection from the pool because
it failed validation.
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.
/CachingEventPipeline: Recycling of CachingEventPipeline
/CachingStreamPipeline: Recycling of CachingStreamPipeline
The last line of the sitemap.log:
/esql_xsp: esql query: select * from testdb2.sysgrps
Thanks again for your help.
Kelly
-----Original Message-----
From: Christian Haul [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 12:26 AM
To: [EMAIL PROTECTED]
Subject: Re: Connection problem to DB2
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]>
---------------------------------------------------------------------
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]>
