That didn't work: Here is the error:
java.lang.AbstractMethodError at org.apache.avalon.excalibur.datasource.JdbcConnection.prepareStatement(Unknown Source) Thanks Lajos Moczar wrote: > I don't know PostgreSQL, but you might try putting the jar file in > cocoon/WEB-INF/lib. I have found cases where cocoon doesn't have access > to the jars in $CATALINA_HOME/common/lib, even though it is supposed to. > > If that doesn't fix the problem, you'll have to post the error message. > > Lajos > > daniel robinson wrote: > > > Ok, > > > > I commented out the hsqldb stuff and this error has gone away - but I can't > > get PostgreSQL to work correctly. > > > > I've created the sample DB and modified cocoon.xconf: > > > > <datasources> > > <jdbc name="personnel"> > > <pool-controller min="5" max="10"/> > > <auto-commit>true</auto-commit> > > <dburl>jdbc:postgresql:testdb</dburl> > > <user>unknown</user> > > <password></password> > > </jdbc> > > </datasources> > > > > and Web.xml contains: > > > > <init-param> > > <param-name>load-class</param-name> > > <param-value> > > org.postgresql.Driver > > </param-value> > > </init-param> > > > > and pgjdbc1.jar (containing org.postresql.Driver) is in Tomcat/common/lib and > > I have created the sample tables in testdb within PostgreSQL. > > > > Help appreciated. > > > > Lajos Moczar wrote: > > > > > >>Comment out the hsqldb stuff in cocoon.xconf, unless you really need it. > >> > >>Lajos > >> > >>daniel robinson wrote: > >> > >> > >>>List, > >>> > >>>Is there some comprehensive DB configure doc for C2? I've looked > >>>throught the listserv but its very piecemeal (sp?). I keep getting this > >>>error from tomcat: > >>> > >>>Loading catalog: /localhost/cocoon/resources/entities/catalog > >>>Server.run/init: java.net.BindException: Address in use: JVM_Bind > >>>java.net.BindException: Address in use: JVM_Bind > >>> at java.net.PlainSocketImpl.socketBind(Native Method) > >>> at java.net.PlainSocketImpl.bind(PlainSocketImpl.java:405) > >>> at java.net.ServerSocket.<init>(ServerSocket.java:170) > >>> at java.net.ServerSocket.<init>(ServerSocket.java:82) > >>> at org.hsqldb.Server.run(Server.java:131) > >>> at org.hsqldb.Server.main(Server.java:78) > >>> at > >>>org.apache.cocoon.components.hsqldb.ServerImpl.run(ServerImpl.java:101) > >>> at java.lang.Thread.run(Thread.java:484) > >>>Starting service Tomcat-Apache > >>>Apache Tomcat/4.0.3 > >>> > >>>help appreciated. > >>> > >>>Dan > >>> > >>> > >>> > >>>--------------------------------------------------------------------- > >>>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]> > >> > > > > > > --------------------------------------------------------------------- > > 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]> --------------------------------------------------------------------- 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]>
