ADSM-L

JDBC and TSM ODBC

2000-12-06 16:29:21
Subject: JDBC and TSM ODBC
From: Doug Baker <dbaker AT MAIL.WESLEYAN DOT EDU>
Date: Wed, 6 Dec 2000 16:18:20 -0500
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
<Prev in Thread] Current Thread [Next in Thread>