You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by chris yeung <ch...@xml-asia.org> on 2001/10/25 04:01:45 UTC

SQLException - please help

I am a new user to Cocoon 2.0.
Here are what I have:
---------------------------------
Cocoon-2.0rc1a
Tomcat-4.0.1
jdk1.3.1
Windows 2000 Professional
----------------------------------------

- I have installed Cocoon perfectly including hsql
- Starting http://localhost:8080/cocoon and I can run all examples without problems
- I added a couple of employees/companies under "Sample Forms", it
  worked perfect as well
- now if I shutdown tomcat, restart, I've got the following errors in the DOS window
========================
Starting service Tomcat-Standalone
Apache Tomcat/4.0.1
Starting service Tomcat-Apache
Apache Tomcat/4.0.1
Server.run/init: java.sql.SQLException: File input/output error: C:\tg\jakarta-t
omcat-4.0.1\webapps\cocoon\WEB-INF\db\cocoondb.backup
java.sql.SQLException: File input/output error: C:\tg\jakarta-tomcat-4.0.1\webap
ps\cocoon\WEB-INF\db\cocoondb.backup
        at org.hsqldb.Trace.getError(Trace.java:180)
        at org.hsqldb.Trace.getError(Trace.java:144)
        at org.hsqldb.Trace.error(Trace.java:205)
        at org.hsqldb.Log.restoreBackup(Log.java:731)
        at org.hsqldb.Log.open(Log.java:212)
        at org.hsqldb.Database.<init>(Database.java:96)
        at org.hsqldb.Server.run(Server.java:137)
        at org.hsqldb.Server.main(Server.java:78)
        at org.apache.cocoon.components.hsqldb.ServerImpl.run(ServerImpl.java:102)
        at java.lang.Thread.run(Thread.java:484)
Loading catalog: /path/to/local/catalog
Loading catalog: c:\tg\jakarta-tomcat-4.0.1\webapps\cocoon\resources\entities\catalog
============================

I've taken a look at the "cocoondb.backup" file and I don't see any unusual.

Please advise and many thanks.

Chris Yeung
XML Asia Ltd.

RE: SQLException - please help

Posted by David Rosenstrauch <da...@dti.net>.
shutdown, delete "cocoondb.backup", restart, and everything will be fine.


At 09:43 AM 11/8/01 +0100, you wrote:
>I get the same error (with the same configuration, except I also tried with Cocoon-2.0rc2, and it is still the same). Has anyone found out yet what it is?
>  
>thanx,
>  
>memo  
>-----Original Message----- 
>From: chris yeung [mailto:chris.yeung@xml-asia.org] 
>Sent: Thursday, October 25, 2001 04:02 
>To: cocoon-users@xml.apache.org 
>Cc: chris yeung 
>Subject: SQLException - please help
>
>   
>I am a new user to Cocoon 2.0. 
>Here are what I have: 
>--------------------------------- 
>Cocoon-2.0rc1a 
>Tomcat-4.0.1 
>jdk1.3.1 
>Windows 2000 Professional 
>---------------------------------------- 
>   
>- I have installed Cocoon perfectly including hsql 
>- Starting <http://localhost:8080/cocoon>http://localhost:8080/cocoon and I can run all examples without problems 
>- I added a couple of employees/companies under "Sample Forms", it 
>   worked perfect as well 
>- now if I shutdown tomcat, restart, I've got the following errors in the DOS window 
>======================== 
>Starting service Tomcat-Standalone 
>Apache Tomcat/4.0.1 
>Starting service Tomcat-Apache 
>Apache Tomcat/4.0.1 
>Server.run/init: java.sql.SQLException: File input/output error: C:\tg\jakarta-t 
>omcat-4.0.1\webapps\cocoon\WEB-INF\db\cocoondb.backup 
>java.sql.SQLException: File input/output error: C:\tg\jakarta-tomcat-4.0.1\webap 
>ps\cocoon\WEB-INF\db\cocoondb.backup 
>         at org.hsqldb.Trace.getError(Trace.java:180) 
>         at org.hsqldb.Trace.getError(Trace.java:144) 
>         at org.hsqldb.Trace.error(Trace.java:205) 
>         at org.hsqldb.Log.restoreBackup(Log.java:731) 
>         at org.hsqldb.Log.open(Log.java:212) 
>         at org.hsqldb.Database.<init>(Database.java:96) 
>         at org.hsqldb.Server.run(Server.java:137) 
>         at org.hsqldb.Server.main(Server.java:78) 
>         at org.apache.cocoon.components.hsqldb.ServerImpl.run(ServerImpl.java:102) 
>         at java.lang.Thread.run(Thread.java:484) 
>Loading catalog: /path/to/local/catalog 
>Loading catalog: c:\tg\jakarta-tomcat-4.0.1\webapps\cocoon\resources\entities\catalog 
>============================ 
>   
>I've taken a look at the "cocoondb.backup" file and I don't see any unusual. 
>   
>Please advise and many thanks. 
>   
>Chris Yeung 
>XML Asia Ltd. 


---------------------------------------------------------------------
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: SQLException - please help

Posted by Mehmet Birgi <me...@birgi.com>.
I get the same error (with the same configuration, except I also tried with
Cocoon-2.0rc2, and it is still the same). Has anyone found out yet what it
is?

thanx,

memo
  -----Original Message-----
  From: chris yeung [mailto:chris.yeung@xml-asia.org]
  Sent: Thursday, October 25, 2001 04:02
  To: cocoon-users@xml.apache.org
  Cc: chris yeung
  Subject: SQLException - please help



  I am a new user to Cocoon 2.0.
  Here are what I have:
  ---------------------------------
  Cocoon-2.0rc1a
  Tomcat-4.0.1
  jdk1.3.1
  Windows 2000 Professional
  ----------------------------------------

  - I have installed Cocoon perfectly including hsql
  - Starting http://localhost:8080/cocoon and I can run all examples without
problems
  - I added a couple of employees/companies under "Sample Forms", it
    worked perfect as well
  - now if I shutdown tomcat, restart, I've got the following errors in the
DOS window
  ========================
  Starting service Tomcat-Standalone
  Apache Tomcat/4.0.1
  Starting service Tomcat-Apache
  Apache Tomcat/4.0.1
  Server.run/init: java.sql.SQLException: File input/output error:
C:\tg\jakarta-t
  omcat-4.0.1\webapps\cocoon\WEB-INF\db\cocoondb.backup
  java.sql.SQLException: File input/output error:
C:\tg\jakarta-tomcat-4.0.1\webap
  ps\cocoon\WEB-INF\db\cocoondb.backup
          at org.hsqldb.Trace.getError(Trace.java:180)
          at org.hsqldb.Trace.getError(Trace.java:144)
          at org.hsqldb.Trace.error(Trace.java:205)
          at org.hsqldb.Log.restoreBackup(Log.java:731)
          at org.hsqldb.Log.open(Log.java:212)
          at org.hsqldb.Database.<init>(Database.java:96)
          at org.hsqldb.Server.run(Server.java:137)
          at org.hsqldb.Server.main(Server.java:78)
          at
org.apache.cocoon.components.hsqldb.ServerImpl.run(ServerImpl.java:102)
          at java.lang.Thread.run(Thread.java:484)
  Loading catalog: /path/to/local/catalog
  Loading catalog:
c:\tg\jakarta-tomcat-4.0.1\webapps\cocoon\resources\entities\catalog
  ============================

  I've taken a look at the "cocoondb.backup" file and I don't see any
unusual.

  Please advise and many thanks.

  Chris Yeung
  XML Asia Ltd.