You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cocoon.apache.org by daniel robinson <dr...@dnai.com> on 2002/05/30 08:24:35 UTC

Can't get PostgreSQL to work - HELP !!!

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


RE: Can't get PostgreSQL to work - HELP !!!

Posted by Leo Sutic <le...@inspireinfrastructure.com>.

> From: daniel robinson [mailto:drob@dnai.com] 
>
> 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)
      ^^^^^^^

Unless you are running JDK 1.1.x, you want
http://jdbc.postgresql.org/download/pgjdbc2.jar
Note the '2' instead of a '1' at the end of the jar file name.

The AbstractMethodError is probably caused by the driver not
implementing methods from the Java2 versions of JDBC.

/LS


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org