Re: HELP: In TSM (Tivoli storage manager) 5.1 querying its databse thorugh java code

[Andrew Raibeck]

I copied and pasted your code, as is, into the two .java files. Then I
modified the DSN, Admin ID, and password to match my environment, then
compiled the files. The output looked just fine to me, so your code looks
good.

Which version of the ODBC driver are you using? Please be sure you are
using a current version. 5.1.5.0 is preferable.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: [EMAIL PROTECTED] (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 <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
10/29/2002 14:30
Please respond to "ADSM: Dist Stor Manager"


        To:     [EMAIL PROTECTED]
        cc:
        Subject:        Re: HELP: In TSM (Tivoli storage manager) 5.1 querying its 
databse thorugh
java code



Hi,
  After adding in system and user dsn when running I get following message
on screen:

C:\my-java>java TSM
Session established with server TSM_SERVER1: Windows
  Server Version 5, Release 1, Level 0.0
  Server date/time: 10/29/2002 15:25:28  Last access: 10/29/2002 15:15:01

Session established with server TSM_SERVER1: Windows
  Server Version 5, Release 1, Level 0.0
  Server date/time: 10/29/2002 15:25:29  Last access: 10/29/2002 15:25:28

TSM: There is no information about this table.

Any thoughts please?
Following are the contents of 2 files:

TSMConnect:

import java.sql.*;
public class TSMConnect
{
   public Connection connect() throws SQLException
  {
     try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }
     catch (ClassNotFoundException e)
    {
      throw new SQLException("Unable to load JdbcOdbcDriver class");
    }
    // arguments are "jdbc:odbc:yourdsn", "youradmin", "yourpw"
    return DriverManager.getConnection("jdbc:odbc:tsm", "admin", "admin");
  }
  public void close(Connection dbc, Statement stmt)
{
   try
  {
    if (stmt != null) stmt.close(); if (dbc != null) dbc.close();
  }
  catch (SQLException sqlex) {}
}
public static void main(String args[])
{
  TSMConnect TC = new TSMConnect(); Connection dbc = null; Statement stmt
=
null;
  try
{
   dbc = TC.connect();
   System.out.println("Connection opened.");
   stmt = dbc.createStatement();
   System.out.println("Created a statement.");
}
catch (SQLException sqlex)
{
   System.out.println(sqlex.getMessage());
}
finally
{
   TC.close(dbc, stmt); System.out.println("Connection closed.");
}
}
}


TSM:

import java.sql.*;
public class TSM extends TSMConnect
{
  public static void main(String args[])
{
   if (args.length != 0)
  {
    System.out.println("Usage: java TSM");
    System.exit(1);
  }
  String query = "SELECT * FROM backups";
  TSM tsmObj = new TSM();
  Connection dbc = null;
  Statement stmt = null;
  ResultSet resultSet = null;
  try
{
    dbc = tsmObj.connect();
    stmt = dbc.createStatement();
    resultSet = stmt.executeQuery(query);
    tsmObj.presentResultSet(resultSet);
}
catch (SQLException sqlex)
{
    System.out.println(sqlex.getMessage());
  }
finally
{
  tsmObj.close(dbc, stmt);
}
}
public void presentResultSet(ResultSet rs) throws SQLException
{
  if (!rs.next()) System.out.println("No records to display");
  else
  {
    do
    {
      System.out.println(rs.getString("NODE_NAME") + ": " +
rs.getString("FILESPACE_NAME"));
     } while (rs.next());
  }
}
}



Thanks
- murali