Re: [Hsqldb-developers] Error accessing DB

[Fred T. <fr...@us...>]

This might happen in situations where files were not saved properly on
client machines due to disk error, disk full or whatever.
You need to have a backup strategy to revert to a good version if
this happens.
You can also get paid support from http://hyperxtreme.co.uk for data
recovery and repair.
Fred


On Fri, Oct 20, 2017, at 14:45, Alexander Gerbig wrote:
> Hello HSQL developers,
> 
> we use a hsqldb for the local storage of data in a client application.
> Some users report, that they cannot access their database. They get
> the following error:> 
> _java.sql.SQLException_: No suitable driver found for jdbc:hsqldb:file:<url-to-
> db>> 
> This exception comes from eclipse link that we use to access the
> database. Accessing the database with plain jdbc shows the
> following error:> 
> Caused by: org.hsqldb.HsqlException: error in script file line: 71 <path-to-
> db> IO error: RowInputBinary 6341 in statement [SET TABLE
> PUBLIC.KONTAKT INDEX '6341 0 482']> at org.hsqldb.error.Error.error(Unknown Source)
> at org.hsqldb.scriptio.ScriptReaderText.readDDL(Unknown Source)
> at org.hsqldb.scriptio.ScriptReaderBase.readAll(Unknown Source)
> at org.hsqldb.persist.Log.processScript(Unknown Source)
> at org.hsqldb.persist.Log.open(Unknown Source)
> at org.hsqldb.persist.Logger.open(Unknown Source)
> at org.hsqldb.Database.reopen(Unknown Source)
> at org.hsqldb.Database.open(Unknown Source)
> at org.hsqldb.DatabaseManager.getDatabase(Unknown Source)
> at org.hsqldb.DatabaseManager.newSession(Unknown Source)
> ... 4 more
> Caused by: org.hsqldb.HsqlException: IO error: RowInputBinary 6341
> at org.hsqldb.error.Error.error(Unknown Source)
> at org.hsqldb.rowio.RowInputBinary.readString(Unknown Source)
> at org.hsqldb.rowio.RowInputBinary.readChar(Unknown Source)
> at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
> at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
> at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)
> at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)
> at org.hsqldb.rowio.RowInputBinaryDecode.readData(Unknown Source)
> at org.hsqldb.RowAVLDisk.<init>(Unknown Source)
> at org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)
> at org.hsqldb.persist.DataFileCache.getFromFile(Unknown Source)
> at org.hsqldb.persist.DataFileCache.get(Unknown Source)
> at org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)
> at org.hsqldb.persist.RowStoreAVLDisk.setAccessor(Unknown Source)
> at org.hsqldb.Table.setIndexRoots(Unknown Source)
> at org.hsqldb.Table.setIndexRoots(Unknown Source)
> at org.hsqldb.StatementCommand.getResult(Unknown Source)
> at org.hsqldb.StatementCommand.execute(Unknown Source)
> at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
> ... 13 more
> Caused by: java.io.UTFDataFormatException
> at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
> at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)
> ... 31 more
> 
> We use HSQLDB in Version 2.3.4 with eclipse link in Version 2.6.0. We
> open the database with the following properties:> 
> url: jdbc:hsqldb:file:${path-to-
> db};shutdown=true;hsqldb.default_table_type=cached;crypt_key=${crypt-
> key};crypt_type=blowfish;crypt_lobs=true> hsqldb.lob_compressed: true"
> hsqldb.defrag_limit: 10
> 


> hsqldb.lob_file_scale:1
> 
> The database is encrypted which makes it hard to see what is wrong in
> the script file. Is there a way to repair this database?> 
> Any help is welcome.
> 
> Thanks.
> 
> Best regards,
> Alexander
> ----------------------------------------------------------------------
> --------> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _________________________________________________
> hsqldb-developers mailing list
> hsq...@li...
> https://lists.sourceforge.net/lists/listinfo/hsqldb-developers