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