jdbc adapter service error

, ,
1

Hi All,
I am new to webMethods …

while creating jdbc adapter service.
in developer i selected adapter service and entered name and selected as selectsql templet after that i have selected table name from table tab and automatically showing type is synonym, after that i click on select tab for inserting rows now i am not getting the column names, row is showing blank.
adapter connection every thing is fine. i checked in backend system, table is present and also having values.
I tried for another table with same connection and same user name its working fine.

is there any specific reason?

Thanks
Bunni

2

Make sure you select the right db schema and under that hierarchy you should see the tables listed and try it.Also check with the db owner for access/permissions etc…

HTH,
RMg