JDBC: DatabaseMetaData.getTableTypes() does not return "SYNONYM" as table type

[Zoltan Debreczy]

Is it a bug or a feature?
If it is a bug, can you tell me how long?
If it is a feature, can you tell me why?

Thanks in advance!

Zoltan Debreczy
mailto:[EMAIL PROTECTED]

My tests:

0. Environment:
OS:
  Microsoft Windows NT 4.00.1381
application.getServerInfo():
  Apache Tomcat/4.0.3

DatabaseMetaData.getDatabaseProductVersion():
  Kernel 7.3.0 Build 024-000-000-000
DatabaseMetaData.getDriverVersion():
  package com.sap.dbtech.jdbc, "SAP DB JDBC Driver", "SAP AG", "7.3.0 Build
023-000-085-131"

1. Table types returned by 'DatabaseMetaData.getTableTypes()' are:
   RESULT
   SNAPSHOT
   SYSTEM
   SYSTEM TABLE
   TABLE
   UNLOADED
   VIEW

Sample code:
...
Connection       oConnection       = DriverManager.getConnection (oStDbUrl,
oStUserName, oStPassword);
DatabaseMetaData oDatabaseMetaData = oConnection.getMetaData();
ResultSet        oRsTableTypes     = oDatabaseMetaData.getTableTypes();

while ( oRsTableTypes.next() ) {
  out.println( oRsTableTypes.getString(1) + "<BR>" );
}
oRsTableTypes.close();
oConnection.close();
...

2. 'DatabaseMetaData.getTables(catalog, schema, tablePattern, tabletypes[])'
without table type definition
    returns as table type "SYNONYM"s:
    (I have a newly created database, the schema "SYS" has a lot of
SYNONYMs.)

Sample code:
...
Connection       oConnection       = DriverManager.getConnection (oStDbUrl,
oStUserName, oStPassword);
DatabaseMetaData oDatabaseMetaData = oConnection.getMetaData();

ResultSet        oRsTables         = oDatabaseMetaData.getTables(null,
"SYS", null, null);

while ( oRsTables.next() ) {
  out.println(   "TABLE_TYPE:" + oRsTables.getString(4)
             + ", TABLE_NAME:" + oRsTables.getString(3) + "<BR>" );
}
oRsTables.close();
oConnection.close();
...

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general