I've checked all the mail lists and I put up messages on the USER list but I am
stopped so...
I'm running:
Win98
Tomcat 4.0.3
C2
PostgreSQL 7.2.1 in CYGWIN
PostgreSQL JDBC 7.2
Tomcat/common/lib contains:
pgjdbc1.jar (containing org.postresql.Driver)
jdbc2_0-stdext.jar
Cocoon/WEB-INF/lib contains (per a suggestion)
pgjdbc1.jar (containing org.postresql.Driver)
I've created the "testdb" with the required data and checked that the SQL defined in
sql-page.xml works
cocoon.xconf:
<datasources>
<jdbc name="personnel">
<pool-controller min="5" max="10"/>
<auto-commit>true</auto-commit>
<dburl>jdbc:postgresql:testdb</dburl>
<password>foo</password>
<driver>org.postgresql.Driver</driver> !!!!! ----- ADDED PER SOMEONE'S
SUGGESTION
</jdbc>
</datasources>
and Web.xml contains:
<init-param>
<param-name>load-class</param-name>
<param-value>
org.postgresql.Driver
</param-value>
</init-param>
When I run the simple SQL example - which worked with the "built-in" db hsqldb or
whatever I
get an "Internal Server Error":
root cause
java.lang.AbstractMethodError
at org.apache.avalon.excalibur.datasource.JdbcConnection.prepareStatement(Unknown
Source)
at
org.apache.cocoon.transformation.SQLTransformer$Query.execute(SQLTransformer.java:923)
The logs show (at the end)
DEBUG (2002-05-29) 22:40.07:360 [cocoon ] (/cocoon/sql/sql-page)
HttpProcessor[8080][4]/SQLTransformer: RECEIVED END ELEMENT
execute-query(http://apache.org/cocoon/SQL/2.0)
DEBUG (2002-05-29) 22:40.07:360 [cocoon ] (/cocoon/sql/sql-page)
HttpProcessor[8080][4]/SQLTransformer: SQLTransformer executing query nr 0
DEBUG (2002-05-29) 22:40.07:360 [cocoon ] (/cocoon/sql/sql-page)
HttpProcessor[8080][4]/SQLTransformer$Query: EXECUTING
select id,name from department_table
DEBUG (2002-05-29) 22:40.07:360 [cocoon ] (/cocoon/sql/sql-page)
HttpProcessor[8080][4]/DefaultPool: Retrieving a
org.apache.avalon.excalibur.datasource.JdbcConnection from the pool
DEBUG (2002-05-29) 22:40.07:360 [cocoon ] (/cocoon/sql/sql-page)
HttpProcessor[8080][4]/DefaultPool: Returning a
org.apache.avalon.excalibur.datasource.JdbcConnection to the pool
DEBUG (2002-05-29) 22:40.07:360 [cocoon ] (/cocoon/sql/sql-page)
HttpProcessor[8080][4]/DefaultComponentFactory: ComponentFactory decommissioning
instance of
org.apache.cocoon.components.parser.JaxpParser.
DEBUG (2002-05-29) 22:40.07:360 [cocoon ] (/cocoon/sql/sql-page)
HttpProcessor[8080][4]/DefaultPool: Returning a
org.apache.cocoon.components.sax.XMLByteStreamCompiler to the pool
DEBUG (2002-05-29) 22:40.07:360 [cocoon ] (/cocoon/sql/sql-page)
HttpProcessor[8080][4]/CachingEventPipeline: Recycling of CachingEventPipeline
DEBUG (2002-05-29) 22:40.07:360 [cocoon ] (/cocoon/sql/sql-page)
HttpProcessor[8080][4]/DefaultPool: Returning a
org.apache.cocoon.generation.FileGenerator to
the pool
DEBUG (2002-05-29) 22:40.07:360 [cocoon ] (/cocoon/sql/sql-page)
HttpProcessor[8080][4]/DefaultPool: Returning a
org.apache.cocoon.transformation.SQLTransformer
to the pool
DEBUG (2002-05-29) 22:40.07:360 [cocoon ] (/cocoon/sql/sql-page)
HttpProcessor[8080][4]/DefaultPool: Returning a
org.apache.cocoon.transformation.TraxTransformer to the pool
DEBUG (2002-05-29) 22:40.07:360 [cocoon ] (/cocoon/sql/sql-page)
HttpProcessor[8080][4]/DefaultPool: Returning a
org.apache.cocoon.components.pipeline.CachingEventPipeline to the pool
DEBUG (2002-05-29) 22:40.07:360 [cocoon ] (/cocoon/sql/sql-page)
HttpProcessor[8080][4]/CachingStreamPipeline: Recycling of CachingStreamPipeline
DEBUG (2002-05-29) 22:40.07:410 [cocoon ] (/cocoon/sql/sql-page)
HttpProcessor[8080][4]/DefaultPool: Returning a
org.apache.cocoon.serialization.HTMLSerializer
to the pool
DEBUG (2002-05-29) 22:40.07:410 [cocoon ] (/cocoon/sql/sql-page)
HttpProcessor[8080][4]/DefaultPool: Returning a
org.apache.cocoon.components.pipeline.CachingStreamPipeline to the pool
After reviewing the above, the source code and the error message I can't figure out
what is
wrong. PLEASE HELP!
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]
