We also tried: nohup java -Xmx512m -cp ./lib/hsqldb-jdk8.jar -jar ./lib/sqltool-2.6.0-jdk8.jar --sql "SHUTDOWN COMPACT;" testdb & same issue. ------------------------IMPORTANT NOTICE This communication contains information that is considered confidential and may also be privileged . It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited...
Hi Team, Recently we have upgraded from hsqldb2.5.0 to 2.6.0 but while running the shutdown compact from the script I am getting an error "No Suitable Driver found" and It was working perfectly fine with hsqldb2.5.0 here are the details scripts nohup java -Xmx512m -jar ./lib/sqltool-2.6.0-jdk8.jar --sql "SHUTDOWN COMPACT;" testdb & sqltool.rc urlid testdb url jdbc:hsqldb:hsql://localhost/testdb;shutdown=true username sa password abcd Error Failed to get a connection to 'jdbc:hsqldb:hsql://localhost'...
sorry that was the result of a google search "hsqldb documentation sqltool". Benoit ------------------------IMPORTANT NOTICE This communication contains information that is considered confidential and may also be privileged . It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication...
Hi On page http://www.hsqldb.org/doc/ the links:http://www.hsqldb.org/doc/util-guide/index.html andhttp://www.hsqldb.org/doc/util-guide/util-guide.pdf Return 404. Best regards Benoit ------------------------IMPORTANT NOTICE This communication contains information that is considered confidential and may also be privileged . It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication...
Hi Fred Will the SHUTDOWN COMPACT fix the issue? Many thanks Benoit ------------------------IMPORTANT NOTICE This communication contains information that is considered confidential and may also be privileged . It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in...
Hi Strange issue with 2.5.0. Our DB is 149GB and one cached table has 425m rows.c I added one Bigint and one Tinyint to that table and the data file jumped from 149GB to 274GB. I can’t understand the huge increase... any suggestion? When we check the size using squirrel J, a varchar (10) shows a size of 10 implying 10 bytes but if the column is bigint it shows 64, surely that is not 64 bytes but bits? Is it consistent? We will attempt running a shutdown compact on it (will take days I believe). Many...
Thanks The question is whether it is possible to grant these to ALL tables by default without having to specify "ATABLE" present and future. Thanks Benoit ------------------------IMPORTANT NOTICE This communication contains information that is considered confidential and may also be privileged . It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it...
Hi We're struggling to find a way to create a user which would have only the ability to SELECT / INSERT / UPDATE / DELETE and use a Sequence (i.e. NOT drop a table or other admin stuff). We would like to find a way without having to specify each table, sequence individually (especially if new tables are created later on). Is there a way? Many thanks Benoit ------------------------IMPORTANT NOTICE This communication contains information that is considered confidential and may also be privileged ....