Unable to See any tables under current schema when creating an Oracle adapter service

, ,
1

The JDBC connection to the Oracle database is up and running. When I create a new JDBC adapter service, I am not able to see any tables or views under current schema as well as under the schema name as well.

wM Version 7.1.2
Please advise…
Regards
Zeppy

2

HI,

 Kindly check once if the JDBC adapter connection which you are using is pointing to the right dB.

-Ambrish-

3


HI,

Kindly check once if the JDBC adapter connection which you are using is pointing to the right dB.

Alongwith it check as user which u have used in JDBC adapters to connect to oracle database has sufficient rights to view tables.

4

Hi Zeppy,

what type of template have you created(Insert/Update/Delete/BatchInsert) for establishing the connection with Oracle DB. Type of Transaction (Local/XA/No_transaction) used in the adpterservice template?

Regards,
Jeevan_mjk