Re: hsqldb - how do I get rid of this error message (and turn off hsqldb)

2002-05-29 Thread daniel robinson

did both things, moved jar and added  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:[EMAIL PROTECTED]]
> >
> > 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:
> >
> >   
> > 
> >   
> >   true
> >   jdbc:postgresql:testdb
> >   unknown
> >   
> > 
> >   
> >
> > and Web.xml contains:
> >
> >  
> >   load-class
> >   
> > org.postgresql.Driver
> >   
> > 
> >
> > 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 org.postgresql.Driver element into your 
> config (under the  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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>




Re: hsqldb - how do I get rid of this error message (and turn off hsqldb)

2002-05-29 Thread daniel robinson

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:
> >
> >   
> > 
> >   
> >   true
> >   jdbc:postgresql:testdb
> >   unknown
> >   
> > 
> >   
> >
> > and Web.xml contains:
> >
> >  
> >   load-class
> >   
> > org.postgresql.Driver
> >   
> > 
> >
> > 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.(ServerSocket.java:170)
> >>>at java.net.ServerSocket.(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. 
> >>>
> >>>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. 
> >>
> >>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. 
> >
> > 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. 
>
> 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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>




RE: hsqldb - how do I get rid of this error message (and turn off hsqldb)

2002-05-29 Thread Berin Loritsch

> From: daniel robinson [mailto:[EMAIL PROTECTED]] 
> 
> 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:
> 
>   
> 
>   
>   true
>   jdbc:postgresql:testdb
>   unknown
>   
> 
>   
> 
> and Web.xml contains:
> 
>  
>   load-class
>   
> org.postgresql.Driver
>   
> 
> 
> 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 org.postgresql.Driver element into your 
config (under the  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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>




Re: hsqldb - how do I get rid of this error message (and turn off hsqldb)

2002-05-29 Thread Lajos Moczar

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:
> 
>   
> 
>   
>   true
>   jdbc:postgresql:testdb
>   unknown
>   
> 
>   
> 
> and Web.xml contains:
> 
>  
>   load-class
>   
> org.postgresql.Driver
>   
> 
> 
> 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.(ServerSocket.java:170)
>>>at java.net.ServerSocket.(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. 
>>>
>>>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. 
>>
>>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. 
> 
> 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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>




Re: hsqldb - how do I get rid of this error message (and turn off hsqldb)

2002-05-29 Thread daniel robinson

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:

  

  
  true
  jdbc:postgresql:testdb
  unknown
  

  

and Web.xml contains:

 
  load-class
  
org.postgresql.Driver
  


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.(ServerSocket.java:170)
> > at java.net.ServerSocket.(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. 
> >
> > 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. 
>
> 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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>




Re: hsqldb - how do I get rid of this error message (and turn off hsqldb)

2002-05-29 Thread Lajos Moczar

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.(ServerSocket.java:170)
> at java.net.ServerSocket.(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. 
> 
> 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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>




RE: hsqldb - how do I get rid of this error message (and turn off hsqldb)

2002-05-29 Thread Mark S. Kent

I've seen this on our Linux 7.1 servers when Tomcat didn't completely
shut-down and left some stuff in memory.  Try 'kill'-ing the Tomcat process
and restarting Tomcat.

mark

-Original Message-
From: daniel robinson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 4:04 PM
To: [EMAIL PROTECTED]
Subject: 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.(ServerSocket.java:170)
at java.net.ServerSocket.(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]>




hsqldb - how do I get rid of this error message (and turn off hsqldb)

2002-05-29 Thread daniel robinson

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.(ServerSocket.java:170)
at java.net.ServerSocket.(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. 

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>