Stored procedures in HSQLDB

Posted by & filed under Uncategorized.

The only way to implement stored procedures in older versions of HSQLDB involved calling static methods in Java code.  Starting in version 2.2, HSQLDB supports stored-procedures as predefined SQL calls.  Documentation and examples of how to do this are not ideal or abundant.  Here is an example. DROP SCHEMA IF EXISTS example cascade CREATE SCHEMA […]

Scripting FTP

Posted by & filed under Uncategorized.

I recently had to add a step to a shell script that uses FTP to copy a file to a remote server.  Usually I’d use scp, secure copy, but for some reason I had to use FTP.  It had been a while since I had done this and didn’t quite remember how to do it. […]

Incorporating a Javascript/CSS plugin into a Maven build process using the Maven Minify plugin.

Posted by & filed under Uncategorized.

Finally, I was able to get a javascript minify plugin working.  http://maven-samaxes-plugin.googlecode.com/svn-history/r123/sites/maven-minify-plugin/index.html It uses YUI compressor under the hoods.  It combines Javascript into one file, CSS into another file and then uses the YUI compressor to minify the two files.  To preserve comments in the minified file, use /*! sequence at the start of a […]

Engineering Mistakes and Process Improvement

Posted by & filed under Uncategorized.

I often come across articles that I find are great in theory but putting them to practice in an organization is very challenging mainly due to the culture.  It often takes a lot of pain before change will occur.  The old saying, “ouch that hurts!  Don’t do that.” comes to mind.  Why is it that […]

Apache 2.2 Configuration

Posted by & filed under Uncategorized.

Apache configuration can be the most frustrating things, especially for those of us who don’t do it everyday.  The one mistake I constantly make is allowing Apache to serve up content from a document root.  Nine times out of ten I forget to add the Directory settings.  For example, once you configure a DocumentRoot don’t […]