Monthly Archives: December 2011

Connect To HyperSQL Database Via SqlTool

Posted on December 27, 2011 by Michael

The following command executed in the lib directory of the HyperSQL tool will connect to a HyperSQL database: java -cp sqltool.jar;hsqldb.jar org.hsqldb.cmdline.SqlTool –inlineRc url=jdbc:hsqldb:file:path_to_db\db_namejava -cp sqltool.jar;hsqldb.jar org.hsqldb.cmdline.SqlTool –inlineRc url=jdbc:hsqldb:file:path_to_db\db_name Remember to run commit; before exiting the tool as any statements … Continue reading →

Posted in Programming | Tagged , | 1 Comment

HyperSQL SqlTool: Header has X columns, but input record has Y column values

Posted on December 27, 2011 by Michael

I received the following error when attempting to import data into HyperSQL via the bundled SqlTool from a CSV file generated by MSSQL Server. Header has 17 columns, but input record has 14 column values Normally this indicates just what … Continue reading →

Posted in Programming | Tagged , , , | Leave a comment

Amazon EC2 Elastic Beanstalk Basic Authentication

Posted on December 6, 2011 by Michael

I wanted to set up a secure update center for a NetBeans Platform application Tetrad IT is working on. I also wanted to play with Amazon EC2… As the update center is for Tetrad staff only I wanted to do … Continue reading →

Posted in Programming | Tagged , , , , , , | 3 Comments