https://sourceforge.net/p/hsqldb/hsqldb-utilities/2021-05-25T09:05:13.348000ZRecent changes to hsqldb-utilities2021-05-25T09:05:13.348000Z2021-05-25T09:05:13.348000ZFred Toussihttps://sourceforge.net/u/fredt/https://sourceforge.net235fb02d6caa7731f7c17c190931c9574fe485c6

<div class="markdown_content"><p>The file could be corrupted. With version 2.6.0 you can check data file consistency and in some cases fix the issues.</p></div>

2021-05-25T01:47:50.036000Z2021-05-25T01:47:50.036000ZAsgarhttps://sourceforge.net/u/asgar12/https://sourceforge.net9647cbd84cd085dd2e67fd02b1be4b4b39fb979e

<div class="markdown_content"><p>Thanks Fred Toussi .. But any idea what will cause this error ? Does it means data file is corrupted ? </p></div>

2021-05-24T19:45:01.280000Z2021-05-24T19:45:01.280000ZFred Toussihttps://sourceforge.net/u/fredt/https://sourceforge.net2ea95e96700133989eac38b99f86184e64dea0ec

<div class="markdown_content"><p>Version 2.2.9 is nearly 9 years old. Versions 2.6.0 may work better. The latest version also allows you to check the consistency of the database files.</p></div>

2021-05-24T16:18:22.219000Z2021-05-24T16:18:22.219000ZAsgarhttps://sourceforge.net/u/asgar12/https://sourceforge.net7e236fb002a071ad34d9e836d10d6e27d1b2eb0b

<div class="markdown_content"><p>Hi,</p> <p>I am getting below error on doing select, We are using HSQL Database Engine 2.2.9</p> <p>SELECT * FROM "PUBLIC"."BATCH_JOB_EXECUTION" </p> <p>org.hsqldb.HsqlException: java.io.IOException: java.lang.IndexOutOfBoundsException<br/> at org.hsqldb.error.Error.error(Unknown Source)<br/> at org.hsqldb.persist.DataFileCache.readObject(Unknown Source)<br/> at org.hsqldb.persist.DataFileCache.getFromFile(Unknown Source)<br/> at org.hsqldb.persist.DataFileCache.get(Unknown Source)<br/> at org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)<br/> at org.hsqldb.index.NodeAVLDisk.findNode(Unknown Source)<br/> at org.hsqldb.index.NodeAVLDisk.getLeft(Unknown Source)<br/> at org.hsqldb.index.IndexAVL.firstRow(Unknown Source)<br/> at org.hsqldb.RangeVariable$RangeIteratorMain.initialiseIterator(Unknown Source)<br/> at org.hsqldb.RangeVariable$RangeIteratorMain.next(Unknown Source)<br/> at org.hsqldb.QuerySpecification.buildResult(Unknown Source)<br/> at org.hsqldb.QuerySpecification.getSingleResult(Unknown Source)<br/> at org.hsqldb.QuerySpecification.getResult(Unknown Source)<br/> at org.hsqldb.StatementQuery.getResult(Unknown Source)<br/> at org.hsqldb.StatementDMQL.execute(Unknown Source)<br/> at org.hsqldb.Session.executeCompiledStatement(Unknown Source)<br/> at org.hsqldb.Session.executeDirectStatement(Unknown Source)<br/> at org.hsqldb.Session.execute(Unknown Source)<br/> at org.hsqldb.jdbc.JDBCStatement.fetchResult(Unknown Source)<br/> at org.hsqldb.jdbc.JDBCStatement.execute(Unknown Source)<br/> at org.hsqldb.util.DatabaseManagerSwing.executeSQL(Unknown Source)<br/> at org.hsqldb.util.DatabaseManagerSwing.access$1000(Unknown Source)<br/> at org.hsqldb.util.DatabaseManagerSwing$StatementExecRunnable.run(Unknown Source)<br/> at java.awt.event.InvocationEvent.dispatch(Unknown Source)<br/> at java.awt.EventQueue.dispatchEventImpl(Unknown Source)<br/> at java.awt.EventQueue.access$500(Unknown Source)<br/> at java.awt.EventQueue$3.run(Unknown Source)<br/> at java.awt.EventQueue$3.run(Unknown Source)<br/> at java.security.AccessController.doPrivileged(Native Method)<br/> at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(Unknown Source)<br/> at java.awt.EventQueue.dispatchEvent(Unknown Source)<br/> at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)<br/> at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)<br/> at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)<br/> at java.awt.EventDispatchThread.pumpEvents(Unknown Source)<br/> at java.awt.EventDispatchThread.pumpEvents(Unknown Source)<br/> at java.awt.EventDispatchThread.run(Unknown Source)<br/> Caused by: java.io.IOException: java.lang.IndexOutOfBoundsException<br/> at org.hsqldb.lib.java.JavaSystem.toIOException(Unknown Source)<br/> at org.hsqldb.persist.RAFileNIO.read(Unknown Source)<br/> at org.hsqldb.persist.RAFileHybrid.read(Unknown Source)<br/> ... 36 more<br/> Caused by: java.lang.IndexOutOfBoundsException<br/> at java.nio.Buffer.checkBounds(Unknown Source)<br/> at java.nio.ByteBuffer.get(Unknown Source)<br/> at java.nio.DirectByteBuffer.get(Unknown Source)<br/> ... 38 more</p></div>

2019-09-05T12:56:33.392000Z2019-09-05T12:56:33.392000ZFred Toussihttps://sourceforge.net/u/fredt/https://sourceforge.net7e44d209057ad0f4ec2621367122100936bf3a6f

<div class="markdown_content"><p>Probably, the .data file of the database is damaged. </p></div>

2019-09-05T12:44:21.812000Z2019-09-05T12:44:21.812000ZAsgarhttps://sourceforge.net/u/asgar12/https://sourceforge.net5e016c22232b19b7be94e8259533137d785e797b

<div class="markdown_content"><p>We are using HSQL Database Engine 2.2.9</p></div>

2019-09-05T12:33:43.223000Z2019-09-05T12:33:43.223000ZAsgarhttps://sourceforge.net/u/asgar12/https://sourceforge.net4da1d1b3f5a059aa9c9c14590c8d1cd80b907581

<div class="markdown_content"><p>Hi, <br/> We received IndexOutOfBoundsException post which there was java.lang.OutOfMemoryError: Java heap space. What could cause this error ?</p> <p>FATAL ?:? logSevereEvent() readObject 551630 <br/> java.io.IOException: java.lang.IndexOutOfBoundsException<br/> at org.hsqldb.persist.ScaledRAFileNIO.read(Unknown Source)<br/> at org.hsqldb.persist.ScaledRAFileHybrid.read(Unknown Source)<br/> at org.hsqldb.persist.DataFileCache.readObject(Unknown Source)<br/> at org.hsqldb.persist.DataFileCache.getFromFile(Unknown Source)<br/> at org.hsqldb.persist.DataFileCache.get(Unknown Source)<br/> at org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)<br/> at org.hsqldb.index.NodeAVLDisk.findNode(Unknown Source)<br/> at org.hsqldb.index.NodeAVLDisk.getRight(Unknown Source)<br/> at org.hsqldb.index.IndexAVL.findNode(Unknown Source)<br/> at org.hsqldb.index.IndexAVL.findFirstRow(Unknown Source)<br/> at org.hsqldb.RangeVariable$RangeIteratorMain.getFirstRow(Unknown Source)<br/> at org.hsqldb.RangeVariable$RangeIteratorMain.initialiseIterator(Unknown Source)<br/> at org.hsqldb.RangeVariable$RangeIteratorMain.next(Unknown Source)<br/> at org.hsqldb.QuerySpecification.buildResult(Unknown Source)<br/> at org.hsqldb.QuerySpecification.getSingleResult(Unknown Source)<br/> at org.hsqldb.QuerySpecification.getResult(Unknown Source)<br/> at org.hsqldb.StatementQuery.getResult(Unknown Source)<br/> at org.hsqldb.StatementDMQL.execute(Unknown Source)<br/> at org.hsqldb.Session.executeCompiledStatement(Unknown Source)<br/> at org.hsqldb.Session.execute(Unknown Source)<br/> at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)<br/> at org.hsqldb.jdbc.JDBCPreparedStatement.executeQuery(Unknown Source)<br/> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)<br/> at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:643)<br/> at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)<br/> at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)<br/> at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665)<br/> at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673)<br/> at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:705)<br/> at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:200)<br/> at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:205)<br/> at org.springframework.batch.core.repository.dao.JdbcJobInstanceDao.getJobInstance(JdbcJobInstanceDao.java:223)<br/> at org.springframework.batch.core.repository.support.SimpleJobRepository.getLastJobExecution(SimpleJobRepository.java:253)<br/> at sun.reflect.GeneratedMethodAccessor411.invoke(Unknown Source)<br/> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)<br/> at java.lang.reflect.Method.invoke(Method.java:611)<br/> at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)<br/> at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)<br/> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)<br/> at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)<br/> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<br/> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)<br/> at com.sun.proxy.$Proxy110.getLastJobExecution(Unknown Source)<br/> at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:94)<br/> Caused by: java.lang.IndexOutOfBoundsException<br/> at java.nio.Buffer.checkBounds(Buffer.java:546)<br/> at java.nio.ByteBuffer.get(ByteBuffer.java:660)<br/> at java.nio.DirectByteBuffer.get(DirectByteBuffer.java:265)<br/> ... 75 more</p> <p>-PreparedStatementCallback; SQL <span>[SELECT JOB_INSTANCE_ID, JOB_NAME from BATCH_JOB_INSTANCE where JOB_NAME = ? and JOB_KEY = ?]</span>; java.io.IOException: java.lang.IndexOutOfBoundsException; nested exception is java.sql.SQLException: java.io.IOException: java.lang.IndexOutOfBoundsException; </p> <p>FATAL ?:? logSevereEvent() xyz_repdb.data getFromFile out of mem 543782 <br/> java.lang.OutOfMemoryError: Java heap space<br/> at org.hsqldb.lib.StringConverter.readUTF(Unknown Source)<br/> at org.hsqldb.rowio.RowInputBinary.readString(Unknown Source)<br/> at org.hsqldb.rowio.RowInputBinary.readChar(Unknown Source)<br/> at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)<br/> at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)<br/> at org.hsqldb.rowio.RowInputBase.readData(Unknown Source)<br/> at org.hsqldb.rowio.RowInputBinary.readData(Unknown Source)<br/> at org.hsqldb.rowio.RowInputBinaryDecode.readData(Unknown Source)<br/> at org.hsqldb.RowAVLDisk.&lt;init&gt;(Unknown Source)<br/> at org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)<br/> at org.hsqldb.persist.DataFileCache.getFromFile(Unknown Source)<br/> at org.hsqldb.persist.DataFileCache.get(Unknown Source)<br/> at org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)<br/> at org.hsqldb.index.NodeAVLDisk.findNode(Unknown Source)<br/> at org.hsqldb.index.NodeAVLDisk.getRight(Unknown Source)<br/> at org.hsqldb.index.IndexAVL.findNode(Unknown Source)<br/> at org.hsqldb.index.IndexAVL.findFirstRow(Unknown Source)<br/> at org.hsqldb.RangeVariable$RangeIteratorMain.getFirstRow(Unknown Source)<br/> at org.hsqldb.RangeVariable$RangeIteratorMain.initialiseIterator(Unknown Source)<br/> at org.hsqldb.RangeVariable$RangeIteratorMain.next(Unknown Source)<br/> at org.hsqldb.QuerySpecification.buildResult(Unknown Source)<br/> at org.hsqldb.QuerySpecification.getSingleResult(Unknown Source)<br/> at org.hsqldb.QuerySpecification.getResult(Unknown Source)<br/> at org.hsqldb.StatementQuery.getResult(Unknown Source)<br/> at org.hsqldb.StatementDMQL.execute(Unknown Source)<br/> at org.hsqldb.Session.executeCompiledStatement(Unknown Source)<br/> at org.hsqldb.Session.execute(Unknown Source)<br/> at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)<br/> at org.hsqldb.jdbc.JDBCPreparedStatement.executeQuery(Unknown Source)<br/> at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)<br/> at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:643)<br/> at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)<br/> at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)<br/> at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665)<br/> at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673)<br/> at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:705)<br/> at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:200)<br/> at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:205)<br/> at org.springframework.batch.core.repository.dao.JdbcJobInstanceDao.getJobInstance(JdbcJobInstanceDao.java:223)<br/> at org.springframework.batch.core.repository.support.SimpleJobRepository.getLastJobExecution(SimpleJobRepository.java:253)<br/> at sun.reflect.GeneratedMethodAccessor411.invoke(Unknown Source)<br/> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)<br/> at java.lang.reflect.Method.invoke(Method.java:611)<br/> at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)<br/> at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)<br/> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)<br/> at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)<br/> at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)<br/> at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)<br/> at com.sun.proxy.$Proxy110.getLastJobExecution(Unknown Source)<br/> at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:94)&lt;/init&gt;</p></div>

2019-05-03T11:30:48.206000Z2019-05-03T11:30:48.206000ZBas de Bakkerhttps://sourceforge.net/u/basdebakker/https://sourceforge.net404cd6834efc8e2289568443e89cfaefa6bc32bd

<div class="markdown_content"><p>I'm trying to use DatabaseManagerSwing on a 15 inch laptop with 4K display. The default font size is too small to read. If I increase the font size, rows in the table tree view start overlapping each oher, making the text unreadable again.</p></div>

2011-09-23T19:13:25Z2011-09-23T19:13:25ZBlaine Simpsonhttps://sourceforge.net/u/unsaved/https://sourceforge.net15fe394e7ce010b02499f93a084792dd6b1aa208

<div class="markdown_content"><p>Have not tested scope definitively, but at least *DSV_COL_DELIM set in auto.sql does not have the intended effect upon DSV exports executed interactively.</p></div>

2011-09-08T08:58:32Z2011-09-08T08:58:32ZAnonymoushttps://sourceforge.net/u/userid-None/https://sourceforge.netf2b45bc120924b132cfde73bc5938c65edd7d651

<div class="markdown_content"><p><a href="http://stackoverflow.com/questions/6783025/how-to-configure-hsqldb-2-2-5-in-maven-pom" rel="nofollow">http://stackoverflow.com/questions/6783025/how-to-configure-hsqldb-2-2-5-in-maven-pom</a></p></div>