CLASSPATH for hsqldb-utils does not include jtds

Bug #934532 reported by Andy Choens
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
hsqldb (Ubuntu)
Confirmed
Undecided
Unassigned

Bug Description

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)

Revision history for this message
Andy Choens (andy-choens) wrote :
Revision history for this message
Launchpad Janitor (janitor) wrote :

Status changed to 'Confirmed' because the bug affects multiple users.

Changed in hsqldb (Ubuntu):
status: New → Confirmed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.