Error calling Jdbc driver methods getExportedKeys(), getIndexInfo(), etc.

[Former Member]

Hi,

I tried to call the jdbc sap driver methods getExportedKeys(), getIndexInfo(), getTypes(), etc.

I got exceptions like missing table SYSODBCTYPES, SYSODBCINDEXES, SYSODBCFOREIGNKEYS, etc.

Did I miss to execute some script after installation or is a driver problem ?

Thank you,

Dragos

[Former Member]

I need to build the logical structure of the database as XML out of the existing database schema. Therefore I call the methods DatabaseMetaData.getExportedKeys(), getTypeInfo(), getImportedKeys().

Maybe I got it wrong, but there is no standard SQL report, just listing the schema structure by calling some jdbc methods.

Connection connection = Driver.connect()

DatabaseMetaData md = connection.getMetaData();

md.getExportedKeys();

on getExportedKeys() it throws an exception, some internal table cannot be found.

Thank you for help,

Dragos

[former_member184473]

Hello Dragos,

Which transaction/report are you facing this issue?

Regards,

Eduardo Rezende