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