Hi
Chris/Mehmet,
I
found that if tomcat isn't shut down properly, the .backup file is zero length
and you get this error every time you start again! If that is the case, I
resolved it by stopping tomcat,copying the original cocoondb.backup from
the cocoon distribution over the zero length one in the tomcat tree, then
restarting. In fact I copied both the .backup and .data, but I think the .backup
is sufficient.
During
the week, someone also mentioned a locking problem with cocoondb.backup, so if
the above doesn't work for you, I suggest you search the mail. I believe it also
mentioned a solution in the FAQs, so you should try that as
well.
HTH.
Regards,
Perry
-Original Message-From: Mehmet Birgi
[mailto:[EMAIL PROTECTED]]Sent: Thursday, 8 November 2001
19:43To: [EMAIL PROTECTED]Subject: RE:
SQLException - please help
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:[EMAIL PROTECTED]]Sent: Thursday, October 25, 2001
04:02To: [EMAIL PROTECTED]Cc: chris
yeungSubject: 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-StandaloneApache
Tomcat/4.0.1Starting service Tomcat-ApacheApache
Tomcat/4.0.1Server.run/init: java.sql.SQLException: File input/output
error:
C:\tg\jakarta-tomcat-4.0.1\webapps\cocoon\WEB-INF\db\cocoondb.backupjava.sql.SQLException:
File input/output error:
C:\tg\jakarta-tomcat-4.0.1\webapps\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/catalogLoading 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.