There is no JDBC driver for TSM. However, it is possible to use the JDBC
<--> ODBC bridge to access the TSM database via Java.

If you go to http://search.adsm.org and do a search with criteria:

   +jdbc +raibeck

You will find some discussion on this subject.

In particular, I posted some sample Java code that uses the JDBC <--> ODBC
bridge at:

   http://msgs.adsm.org/cgi-bin/get/adsm0205/395.html.

I also recommend getting the latest TSM ODBC driver, 5.1.5, from the IBM
FTP site, as it contains the latest fixes.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.eyebm DOT com (change eye to i to reply)

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




murali ramaswamy <muralirama29 AT HOTMAIL DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
10/28/2002 14:29
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        In TSM (Tivoli storage manager) 5.1 querying its 
databse thorugh java
code



Hi,
  I have TSM 5.1 software and it has odbc driver software that I
installed.
However there is no jdbc odbc driver found in that driver installed
folder.
It is needed to make queries to the databse of TSM to get the details
through java program that I am trying to write.  Could someone please tell
me where and how to find the driver class and an example of making DB
queries to get backup jobs information?  Please let me know if there is
anyway I could query TSM databse through java to get backup information.
Really I appreciate help.
Thanks
-murali




_________________________________________________________________
Get a speedy connection with MSN Broadband.  Join now!
http://resourcecenter.msn.com/access/plans/freeactivation.asp