Hello Jan, it is not a bug - the JDBC specification here speaks of 'typical table types', and also provides a way to retrieve these table types using DatabaseMetaData.getTableTypes().
The result of getTableTypes for SAP DB is TABLE_TYPE ------------ RESULT SYNONYM SYSTEM TABLE VIEW which is consistent with the getTables() call. In fact, a little comparision between vendors shows that their naming varies a lot. Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Lolling, Jan [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 24, 2003 9:29 AM > To: [EMAIL PROTECTED] > Subject: Bug in database metadata > > > Hello, > > I found a bug in database metadata. > When I retrieve the table informations from any system user > (DatabaseMetaData.getTables()) than these table has a wrong > type "SYSTEM". The JDBC specification doesn't know about this > type. It exists only the type "SYSTEM_TABLE". I know it is a > very little bug and not important but my program renders the > given tables dependent from these types. > > Mit freundlichen Gr�ssen > > Jan Lolling > > T-Systems > Systems Integration > Entwicklungszentrum Berlin > Hausanschrift: Wittestrasse 30H, 13509 Berlin > Postanschrift: Postfach 652, 13476 Berlin > Tel.: (0 30) 4 35 77-54 44 > Fax: (0 30) 4 35 77-53 07 > mailto:[EMAIL PROTECTED] > Internet: http://www.t-systems.com > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
