Re: JDBC-ODBC Bridge and TSM ODBC driver

[Warren, Matthew James]

Ok,

After a little hunting I have managed to get it working using the 'empty'
MSAccess DB method containing links to the TSM DB, and pointing JDBC at that
intsead.

Has there been any progress getting it to work right off the bat with
JDBC-ODBC Bridge??

Thanks,

Matt.

-----Original Message-----
From: Warren, Matthew James [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 10, 2002 11:19 AM
To: [EMAIL PROTECTED]
Subject: JDBC-ODBC Bridge and TSM ODBC driver


He TSM'ers,

Has anyone any success connecting to the TSM database using the JDBC-ODBC
bridge and the TSM ODBC drivers? I have set bot system and user datasources
using the TSM ODBC driver, and I am then attmepting to access this from Java
using the JDBC-ODBC bridge.

Currently I am using this code in a Main method;

try
{
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException CNFE)
{
    System.out.println(CNFE.toString());
}
try
{
    Connection con =
DriverManager.getConnection("jdbc:odbc:SPADUX","{auserid}","{apassword}");
}
catch(SQLException SQLE)
{
    System.out.println(SQLE.toString());
}


I have tried with both a System DSN setup called SPADUX using the TSM ODBC
drivers, and a user DSN.


And I get the following error;

Session established with server SPADUX0001: Solaris 7/8
  Server Version 4, Release 2, Level 1.9
  Server date/time: 05/10/2002 11:12:44  Last access: 05/10/2002 11:05:26

java.sql.SQLException: General error
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6138)
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6266)
        at sun.jdbc.odbc.JdbcOdbc.SQLColAttributes(JdbcOdbc.java:2044)
        at
sun.jdbc.odbc.JdbcOdbcResultSet.getColAttribute(JdbcOdbcResultSet.java:5241)
        at
sun.jdbc.odbc.JdbcOdbcResultSet.getColumnType(JdbcOdbcResultSet.java:5870)
        at
sun.jdbc.odbc.JdbcOdbcResultSet.getMaxCharLen(JdbcOdbcResultSet.java:5269)
        at
sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:267)
        at
sun.jdbc.odbc.JdbcOdbcConnection.buildTypeInfo(JdbcOdbcConnection.java:1473)
        at
sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:379)
        at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:163)
        at java.sql.DriverManager.getConnection(DriverManager.java:515)
        at java.sql.DriverManager.getConnection(DriverManager.java:174)
        at TSMBillMan.main(TSMBillMan.java:32)


If I use the Forte4J CE Database connection class wizard, I get the extra
information along with the above;

'Unable to Connect: TSM: There is no information about this table'

When the wizard attempts to connect to the DB. I guess the wizard is
attempting to query something similar to the syscat tables to discover
details about the database??


Has anyone else come across this, or succesfully used the JDBC-ODBC Bridge
and the TSM ODBC driver?