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

[Andy Choens]

Public bug reported:

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)

** Affects: hsqldb (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: amd64 apport-bug oneiric running-unity

-- 
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