Fields are not listing in adapter template in JDBC adapter

, ,
1

Dear all,

We have created a new oracle database and created many tables trying to access it from developer using JDBC adapter.

We don’t want to use any schema in the queries, just the table name. so that Even if we promote to different environment it should work.

So we made those tables visible under currentShema and granted SELECT privileges on the tables directly to user.

But still we are not able to see fields of those tables.

Even we granted below permissions, its of vain?

GRANT CREATE SESSION
GRANT CREATE VIEW
GRANT GLOBAL QUERY REWRITE
GRANT SELECT ANY DICTIONARY
GRANT UNLIMITED TABLESPACE

But still we are not able to resolve the issue. Kindly help us in getting this resolved.

Thanks in advcance!!!

Thanks,
Raj

2

See if there is some setting to be provided/specified in “Other Properties” in your JDBC connection.

3

Take the help of DBA team. Its recommended to use schemas for easy maintainablity.

Thanks,

4

Use “..<table_name>” in your AdapterService.

Then the current schema refers to the default schema belonging to the user specified in the connection being used (usually named the same as the user name).

So on different environments you login with different users/schemas to the database, but the table layout should be identical on these.

Which version of IS and JDBC Adapter are you using?
Any Fixes?
Which Version of JDBC driver?

Any error messages in server log or error log related to this?

Regards,
Holger

5

Thank you so much Mahesh :slight_smile: Its working fine now.

we have changed the property
Other Properties driverType=oci;connectionProperties={includeSynonyms=true}

Regards,
Raj

6

Great :slight_smile: have a nice day ahead.