You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by daniel robinson <dr...@dnai.com> on 2002/05/29 23:03:41 UTC
hsqldb - how do I get rid of this error message (and turn off hsqldb)
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: PostgreSQL won't work - any ideas appreciated
Posted by Kenny Chow <ky...@yahoo.com>.
Are you referring to this error, AbstractMethodError
at
org.apache.avalon.excalibur.datasource.JdbcConnection.prepareStatement(Unknown
Source) ? If so, I am sorry for reponding to the wrong
thread.
--- daniel robinson <dr...@dnai.com> wrote:
> Kenny,
>
> Thanks for the response but I have no idea what you
> mean by "two resources"
> could you explain?
>
> Thanks,
>
> Dan
>
> Kenny Chow wrote:
>
> > If I understand it correctly, there should be two
> > resources are configured to bind to the same
> address.
> >
> > So look for that. Just an idea.
> >
> > --- daniel robinson <dr...@dnai.com> wrote:
> > > Anyone,
> > >
> > > I would appreciate help on this from anyone -
> I've
> > > tried all suggestions -- error
> > > messages are below - Please note that I've
> already
> > > tried:
> > >
> > > snip...
> > > * Add a <driver>org.postgresql.Driver</driver>
> > > element into your <jdbc/>
> > > config (under the <dburl/> element is good).
> > > ...snip
> > >
> > > as suggested by Berin.
> > >
> > > Once I get this figured out I PROMISE TO CREATE
> > > DOCUMENTATION :)
> > >
> > > Thanks,
> > >
> > > Dan
> > >
> > > 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:
> > > <co...@xml.apache.org>
> > > For additional commands, e-mail:
> > > <co...@xml.apache.org>
> > >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! - Official partner of 2002 FIFA World Cup
> > http://fifaworldcup.yahoo.com
> >
> >
>
---------------------------------------------------------------------
> > 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:
> <co...@xml.apache.org>
> > For additional commands, e-mail:
> <co...@xml.apache.org>
>
>
>
---------------------------------------------------------------------
> 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:
> <co...@xml.apache.org>
> For additional commands, e-mail:
> <co...@xml.apache.org>
>
=== message truncated ===
__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: PostgreSQL won't work - any ideas appreciated
Posted by daniel robinson <dr...@dnai.com>.
Kenny,
Thanks for the response but I have no idea what you mean by "two resources"
could you explain?
Thanks,
Dan
Kenny Chow wrote:
> If I understand it correctly, there should be two
> resources are configured to bind to the same address.
>
> So look for that. Just an idea.
>
> --- daniel robinson <dr...@dnai.com> wrote:
> > Anyone,
> >
> > I would appreciate help on this from anyone - I've
> > tried all suggestions -- error
> > messages are below - Please note that I've already
> > tried:
> >
> > snip...
> > * Add a <driver>org.postgresql.Driver</driver>
> > element into your <jdbc/>
> > config (under the <dburl/> element is good).
> > ...snip
> >
> > as suggested by Berin.
> >
> > Once I get this figured out I PROMISE TO CREATE
> > DOCUMENTATION :)
> >
> > Thanks,
> >
> > Dan
> >
> > 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:
> > <co...@xml.apache.org>
> > For additional commands, e-mail:
> > <co...@xml.apache.org>
> >
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: PostgreSQL won't work - any ideas appreciated
Posted by Kenny Chow <ky...@yahoo.com>.
If I understand it correctly, there should be two
resources are configured to bind to the same address.
So look for that. Just an idea.
--- daniel robinson <dr...@dnai.com> wrote:
> Anyone,
>
> I would appreciate help on this from anyone - I've
> tried all suggestions -- error
> messages are below - Please note that I've already
> tried:
>
> snip...
> * Add a <driver>org.postgresql.Driver</driver>
> element into your <jdbc/>
> config (under the <dburl/> element is good).
> ...snip
>
> as suggested by Berin.
>
> Once I get this figured out I PROMISE TO CREATE
> DOCUMENTATION :)
>
> Thanks,
>
> Dan
>
> 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:
> <co...@xml.apache.org>
> For additional commands, e-mail:
> <co...@xml.apache.org>
>
__________________________________________________
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
PostgreSQL won't work - any ideas appreciated
Posted by daniel robinson <dr...@dnai.com>.
Anyone,
I would appreciate help on this from anyone - I've tried all suggestions -- error
messages are below - Please note that I've already tried:
snip...
* Add a <driver>org.postgresql.Driver</driver> element into your <jdbc/>
config (under the <dburl/> element is good).
...snip
as suggested by Berin.
Once I get this figured out I PROMISE TO CREATE DOCUMENTATION :)
Thanks,
Dan
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: hsqldb - how do I get rid of this error message (and turn off
hsqldb)
Posted by daniel robinson <dr...@dnai.com>.
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: <co...@xml.apache.org>
> >>>For additional commands, e-mail: <co...@xml.apache.org>
> >>>
> >>>
> >>---------------------------------------------------------------------
> >>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: <co...@xml.apache.org>
> >>For additional commands, e-mail: <co...@xml.apache.org>
> >>
> >
> >
> > ---------------------------------------------------------------------
> > 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: <co...@xml.apache.org>
> > For additional commands, e-mail: <co...@xml.apache.org>
> >
> >
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: hsqldb - how do I get rid of this error message (and turn off hsqldb)
Posted by Lajos Moczar <lm...@galatea.com>.
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: <co...@xml.apache.org>
>>>For additional commands, e-mail: <co...@xml.apache.org>
>>>
>>>
>>---------------------------------------------------------------------
>>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: <co...@xml.apache.org>
>>For additional commands, e-mail: <co...@xml.apache.org>
>>
>
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: hsqldb - how do I get rid of this error message (and turn off
hsqldb)
Posted by daniel robinson <dr...@dnai.com>.
did both things, moved jar and added <driver> into cocoon.xconf. No
change. Logs look pretty clean - there is a retrieval of jdbc connection
and release ok There are a bunch of msgs to do with the parsing and
executing of the SQL. Nothing alarming.
???
Berin Loritsch wrote:
> > From: daniel robinson [mailto:drob@dnai.com]
> >
> > 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.
>
> What you have *should* work, however there are a couple of things
> to try.
>
> * Add a <driver>org.postgresql.Driver</driver> element into your <jdbc/>
> config (under the <dburl/> element is good).
>
> * Move the library to ${webapp}/WEB-INF/libs
>
> When you look at the logs, what do you see (usually you will see a
> stacktrace
> as to why something in the load-class initial parameter did not get
> loaded).
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
RE: hsqldb - how do I get rid of this error message (and turn off hsqldb)
Posted by Berin Loritsch <bl...@apache.org>.
> From: daniel robinson [mailto:drob@dnai.com]
>
> 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.
What you have *should* work, however there are a couple of things
to try.
* Add a <driver>org.postgresql.Driver</driver> element into your <jdbc/>
config (under the <dburl/> element is good).
* Move the library to ${webapp}/WEB-INF/libs
When you look at the logs, what do you see (usually you will see a
stacktrace
as to why something in the load-class initial parameter did not get
loaded).
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: hsqldb - how do I get rid of this error message (and turn off
hsqldb)
Posted by daniel robinson <dr...@dnai.com>.
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: <co...@xml.apache.org>
> > For additional commands, e-mail: <co...@xml.apache.org>
> >
> >
>
> ---------------------------------------------------------------------
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: hsqldb - how do I get rid of this error message (and turn off hsqldb)
Posted by Lajos Moczar <lm...@galatea.com>.
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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>