Hello, at first what is the version of your JDBC-driver? It is always a good idea to use the newest JDBC-driver available at: ftp://ftp.sap.com/pub/sapdb/bin/java/sapdbc.jar
> some limitations I found, so please can anybody point me to the right > place to get this working too: > > - in the metadata of the connection I got no getCatalogs and no > getTables working. this is not so strange because I can use > getTablePrivileges and this works fine. SAP DB has only one catalog per database instance. This catalog has not really a name. You can give him the name "DEFAULT" or the name of the database instance. So DatabaseMetaData.getCatalogs returns an empty result. Maybe it would be better to return a resultset with one row which has one column containing the string "DEFAULT" or the database name? DatabaseMetaData.getTables should work. Whats the parameter of your method call? The following call: DatabaseMetaDataSapDB.getTables (null, null, null, null) should give you all tables. > > - in the ResultSetMetaData I get no: getSchemaName and no > getTableName > back. The concept of schema is not really supported by SAP DB. All objects do you create are stored under the name of the current user. So the name of this user could be your catalog name. ResultSetMetaData.getSchemaName() returns "" as schema name. But it would be possible to return the user name instead of "". Do you think this is a good idea? ResultSetMetaData.getTableName() can return "" if the driver cannot determines the tablename (see JDBC specification). > - isAutoIncrement is always false, if I use Default Serial or not > - isDefinitlyWriteable and isWriteable are always false Unfortunately the driver cannot efficient determines whether the the column is autoincrement/is difinitly writeable or not. To support this feature some changes in our communication protocol between interfaces and kernel will be needed. This is not planed for the near future because of the compatibility between different releases. Hope my answer is helpful. Comments are welcome. Regards, Marco ---------------------------------------------- Marco PASKAMP SAP DB, SAP Labs Berlin SAP DB is open source. Get it! www.sapdb.org _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
