Keith

There is a problem with dropping overloaded procedures. If I have two procedures that are overloaded, and one calls the other, I am unable to drop the one that is not dependent on the other. I have to first alter the body of the routine to not reference the other before dropping it. But it gets even stranger. The DROP command drops both! That's not right. Working example: -- Create the first one that takes an argument CREATE PROCEDURE signalproblem(message VARCHAR(100)) SPECIFIC signalproblem1 BEGIN...

This problem still exists even with 2.4.0. It's a shame that I have to drop all triggers and procedures in order to add/rename/drop a column in a table. That's a lot of needless extra work. Can we get a feature to allow column changes without having to drop and recreate all triggers and procedures?

I would like to dump the contents of an HSQL database as a sequence of INSERT statements that I can use to transfer data into another database such as PostgreSQL. I know about the SCRIPT statement, and it works well except for tables with lobs. When a table has lobs, the field in the INSERT statement has what appears to be a lob id, which is useless to me. Is there a way to get the actual lob using the lob id? If I can get the lob data, then I can replace the id in the INSERT statement with rawt...

I would like to dump the contents of an HSQL database as a sequence of INSERT statements that I can use to transfer data into another database such as PostgreSQL. I know about the SCRIPT statement, and it works well except for tables with lobs. When a table has lobs, the field in the INSERT statement has what appears to be a lob id, which is useless to me. Is there a way to get the actually lob using the lob id? If I can get the lob data, then I can replace the id in the INSERT statement with ra...

I have database that is encryped including the .lobs file. I honestly do not know what caused it, but the data in one of the tables, which has a BLOB field, is now corrupted. When do queries using SqlTool that involves the table I get various errors. Sometimes all I get is "java.lang.NullPointerException". Other times I get "java.lang.ArrayIndexOutOfBoundsException". Both with no stack traces. When I try to do SCRIPT, I get the following: sql> script 'dump.sql'; 2017-10-25T20:39:23.755+0000 SEVERE...

I am having problems with the JRT approach. My field is defined as BLOB, and I notice that BLOB is not in the mapping of SQL to Java types. The only supported binary types are BINARY and VARBINARY. I can convert BLOB to VARBINARY using the CONVERT function, but some of the blobs are really large and I get errors about "right truncation". I also notice when I issue the CREATE FUNCTION command with VARBINARY, it complains about it not having a size parameter, but when the blobs, I don't know the size....

Thanks, Fred. The JRT method is the way I'll go. I can't afford to convert the BLOB to DOUBLE ARRAY because I need to have the blobs stored in the separate .lobs file for performance reasons. I have lots of these blobs and they can get fairly large.

I have a table with a blob field that stores all kinds of generic information collected from an outside system. To interpret the blob, there is a format field in the table to tell apps what kind of data is in the blob. Normally the data is just an array of double or int. In Java, I can get this array as byte[] and then convert it to double[] using DoubleBuffer. Now I need to do some manipulation of the data within the database itself inside a trigger function in order to maintain integrity with another...