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

Venu_Narayanan · February 8, 2011, 1:01am

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

Ambrish_I · February 8, 2011, 12:39pm

HI,

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

-Ambrish-

pankaj.kumar.971619 · March 23, 2011, 8:35pm

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.

Jeevan_Kiran · March 27, 2011, 8:32pm

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