I have no answer for you, but I'm fascinated by your question.  I'm curious
about what you are attempting to develop.  We will be trying to develop
support web pages based on Java, servlets, jdbc, Informix, et al.  I have
been wondering if there is a way to include JDBC access to a TSM server
using a JDBC-ODBC bridge, which it sounds like you are attempting to
do.  I'd be very interested in any progress you make on getting this to work.

Good luck!

..Paul

At 04:18 PM 12/6/2000 -0500, Doug Baker wrote:

Hello all. Has anyone successfully used Java & the JDBC to query
a TSM database? Our TSM is 3.7, on AIX. I've tried various ODBC
drivers, from ADSM 3.6 to TSM 3.7 to TSM 4.1 - all work fine when
getting data with MS Access 2000.

Unfortunately when trying to get at the DB in Java, I get an
SQLException with the message "TSM: There is no information about
this table." This is from doing a simple "select * from volumes"
query.

I'm definitely authenticating properly to the DB, because putting
fake username gets a "General Error."

I'm doing this under Borland JBuilder Foundation 4.0. But note
that when I try to use the JDBC explorer under Borland JBuilder
3.0 Pro, I get the same problem.

I've also tested this on NT 4.0 - so I suspect it's something to
do with JDBC, snce the same ODBC datasource is fine with Access.
Any advice would be great..

Doug Baker