CLASSPATH for hsqldb-utils does not include jtds

The CLASSPATH for the executables in the hsqldb-utils do not include the jtds driver, thus any attempt to configure these tools to use jtds will fail.

My sqltool.rc includes a section for a SQL Server database. I have the jtds JDBC driver installed from the Ubuntu repos. I read the documentation and set up sqltool.rc, yet I was getting errors when connecting to my SQL Server instance. Other JDBC tools on my computer are able to successfully connect to this SQL Server instance, thus I know my JDBC URL is correct and that I have installed jtds correctly.

Then, I went and looked at the shell script starting sqltool in /usr/bin/. I noticed the CLASSPATH did not include jtds, which is why it kept giving me a driver error when trying to connect to my SQL Server instance. After adding:

    :/usr/share/java/jtds.jar

to the end of the CLASSPATH setting, sqltool was able to successfully connect to my SQL Server instance.

This is the full, edited exec statement that is working on my machine.

    exec java -cp $CLASSPATH:/usr/share/java/hsqldbutil.jar:/usr/share/java/hsqldb.jar:/usr/share/java/postgresql.jar:/usr/share/java/mysql.jar:/usr/share/java/jtds.jar "org.hsqldb.util.SqlTool" "$@"

This same error appears in the shell scripts for the other executables provided by the hsqldb-utils package, and the fix is the same in each case. These are meant to be generic JDBC compiant tools and I think it makes sense to make sure they are able to see / find the JDBC drivers that a user can easily install from the repos.

ProblemType: Bug
DistroRelease: Ubuntu 11.10
Package: hsqldb-utils 1.8.0.10-9ubuntu1
ProcVersionSignature: Ubuntu 3.0.0-16.28-generic 3.0.17
Uname: Linux 3.0.0-16-generic x86_64
ApportVersion: 1.23-0ubuntu4
Architecture: amd64
Date: Fri Feb 17 16:39:09 2012
InstallationMedia: Ubuntu 11.10 "Oneiric Ocelot" - Release amd64 (20111012)
PackageArchitecture: all
SourcePackage: hsqldb
UpgradeStatus: No upgrade log present (probably fresh install)