I been using HypersonicSQL with great joy and success for over 2.5 years now and have not found any unstable issues with it - ... except when crashing it and then have a unclean shutdown, then rebuild the db from backup ... first how are You using it ? - not at all - for read data - for read/write data - do You do backups ? - what OS ? (after reinstall chmod ?) If JBoss goes down unexpectedly (kill pid / power) and then do not have a chance to shutdown HypersonicSQL properly - while writes has been made since last run - then the .script file can become corrupt. start without a .script file anew - and rebuild Your data - or use the file persistents mode by using CREATE CASHED TABLE instead of CREATE TABLE docs and tools at : http://sourceforge.net/projects/hsqldb/ HypersonicSQL 1.4 (JBoss vesion in 2.4) hsqldb 1.6 If using HypersonicSQL with large datasets and You are in a developing phase - then have a separate pararell instance of HypersonicSQL running outside of Your JBoss VM. So that You can have Your db not rebuild itself everytime JBoss is started. Also how did Your JBoss stoped working - any logs ? >From below all I can se is that JBoss have problem starting - due to a corrupt HypersonicSQL .script file ... that comes from unclean shutdown. /peter_f *** on 1-09-13 21.04, Tejaswi Redkar at [EMAIL PROTECTED] wrote: I think you should get rid of HypersonicSQL. This is not a stable product. I have seen this problem when using Hypersonic independently. -----Original Message----- From: Matthew Baird [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 13, 2001 11:16 AM To: 'A.L.'; [EMAIL PROTECTED] Subject: RE: [JBoss-user] JBOSS stops working we've also seen this error, fwiw. No solution here other than to comment out refs to hypersonic -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of A.L. Sent: Wednesday, September 05, 2001 8:53 AM To: [EMAIL PROTECTED] Subject: [JBoss-user] JBOSS stops working I have been running JBOSS for a month now, and all of a sudden it stops working. This problem happened before, so I reinstalled it. Any help would be much appreciated. When trying to start the tomact-Jboss program the command line shows the following and then stops: [Hypersonic] Server.run/init: java.sql.SQLException: Wrong database file version [Hypersonic] java.sql.SQLException: Wrong database file version [Hypersonic] at org.hsql.Trace.getError(Trace.java:124) [Hypersonic] at org.hsql.Trace.getError(Trace.java:115) [Hypersonic] at org.hsql.Trace.check(Trace.java:149) [Hypersonic] at org.hsql.Trace.check(Trace.java:145) [Hypersonic] at org.hsql.Log.open(Log.java:100) [Hypersonic] at org.hsql.Database.<init>(Database.java:47) [Hypersonic] at org.hsql.Server.run(Server.java:69) [InstantDB] XA Connection pool InstantDB bound to java:/InstantDB [Hypersonic] at org.hsql.Server.main(Server.java:33) [Hypersonic] at org.jboss.jdbc.HypersonicDatabase$1.run(HypersonicDatabase.ja _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
