RE: SQLException - please help

[Faulkner, Perry]

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:43 To: [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:02 To: [EMAIL PROTECTED] 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.