cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From daniel robinson <d...@dnai.com>
Subject Can't get PostgreSQL to work - HELP !!!
Date Thu, 30 May 2002 06:24:35 GMT
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: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org


Mime
View raw message