Expand|Select|Wrap|Line Numbers
- try {
- DatabaseMetaData metadata=con.getMetaData();
- System.out.println(metadata.getDriverName());
- System.out.println("Driver version: " +metadata.getDriverVersion());
- System.out.print("JDBC version: " + metadata.getJDBCMajorVersion());
- System.out.println("." +metadata.getJDBCMinorVersion());
- System.out.println("Database product name: " +metadata.getDatabaseProductName());
- System.out.println("Database product version: " +metadata.getDatabaseProductVersion());
- System.out.print("Database version: " +metadata.getDatabaseMajorVersion());
- System.out.println("." +metadata.getDatabaseMinorVersion());
- String[] names = {"TABLE"};
- //exception occurs on next line:
- ResultSet tables = metadata.getTables(null,"%", null, names);
- while (tables.next()) {
- String tableName = tables.getString("TABLE_NAME");
- System.out.println(tableName);
- }
- } catch (SQLException se) {
- System.out.println("Error: could not get tables");
- se.printStackTrace();
- System.exit(1);
- }
IBM DB2 JDBC Universal Driver Architecture
Driver version: 3.1.57
JDBC version: 3.0
Database product name: DB2/AIX64
Database product version: SQL09013
Database version: 9.1
Error: could not get tables
com.ibm.db2.jcc.c.SqlException: DB2 SQL error: SQLCODE: -443, SQLSTATE: 38553, SQLERRMC: SYSIBM.SQLTABLES;TABLES;SYSIBM:CLI:-805
at com.ibm.db2.jcc.c.fg.d(fg.java:1340)
at com.ibm.db2.jcc.b.gb.k(gb.java:351)
at com.ibm.db2.jcc.b.gb.e(gb.java:96)
at com.ibm.db2.jcc.b.w.e(w.java:83)
at com.ibm.db2.jcc.b.vb.i(vb.java:164)
at com.ibm.db2.jcc.c.fg.q(fg.java:1311)
at com.ibm.db2.jcc.c.gg.d(gg.java:2386)
at com.ibm.db2.jcc.c.hg.V(hg.java:146)
at com.ibm.db2.jcc.c.t.a(t.java:7384)
at com.ibm.db2.jcc.c.t.a(t.java:5974)
at com.ibm.db2.jcc.c.t.getTables(t.java:5885)
...