Bill Lindsay

Thanks Fred, the real need is what you suggested, turning on compression for CLOBS only. Is that fixed in 2.5.1?

@fredt Hi Fred, ran into this issue again. Someone turned on compression database wide and inserted LOB failed. Is this still a possibility to add? We are running 2.5.0 at this point. I posted a realted comment last night, but this is resolved by turning off compression. TY

I have a database which has 2 versions, with the only difference being the size of a column. I insert ZIP files into a BLOB. One works the other doesnt. The behaviour is the same using a SQL Client. DBeaver in this case, but in application code I can trap the is the issue in ReturnResultImpl Class executeUpdate(preparedStsatment) when executing this.jdbcExecuteStatementStart(); java.sql.SQLTransientConnectionException: connection exception: connection failure: java.net.SocketException: Software caused...

Can compression be done at a TABLE level? So the CLOBS can benefit?

Works now Fred. Back in business. Would be great to get that update. We find compression handy. I understand we dont dont get that much for the LOBS. Have a good one

Hi Fred thanks for the quick response. It happens for a particular BLOB, when is exceeds 2.5mb, but looking at the metadata. I was expecting it to be fine, since the metadata is indicating 1GB size. I believe we do have compression on. Why would turning it off correct this? Should I rebuild the database from scratch?

AMI_SCHEMA BUNDLES BUNDLE BLOB 1073741824 YES Size of BLOB using DEFAULT Size of File (ZIP) 11,807KB Using Spring Boot JPA and @LOB on Entity save fails with ArrayIndexOutOfBounds org.hsqldb.HsqlException: java.lang.ArrayIndexOutOfBoundsException: 528384 at org.hsqldb.error.Error.error(Unknown Source) at org.hsqldb.SessionData.allocateLobForResult(Unknown Source) at org.hsqldb.Session.allocateResultLob(Unknown Source) at org.hsqldb.result.Result.readLobResults(Unknown Source) at org.hsqldb.server.ServerConnection.receiveResult(Unknown...

I would like to download the source for hsqldb, I tried accessing git clone https://git.code.sf.net/p/hsqldb/hsqldb hsqldb-hsqldb and it is creating an empty directory. Am I looking at the correct repo?