[Bug 934532] Re: CLASSPATH for hsqldb-utils does not include jtds

[Andy Choens]

-- 
You received this bug notification because you are a member of Ubuntu
Foundations Bugs, which is subscribed to hsqldb in Ubuntu.
https://bugs.launchpad.net/bugs/934532

Title:
  CLASSPATH for hsqldb-utils does not include jtds

Status in “hsqldb” package in Ubuntu:
  New

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)

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/hsqldb/+bug/934532/+subscriptions