I’m using WM 6.1 and SQL SERVER 2000 and have several JDBC customSQL adapter services that I’ve created.
The problem is that I can’t run them without the fully qualified schema name in the actual SQL statement:
SELECT IMITM FROM TESTDTA.F4102 (WORKS)
SELECT IMITM FROM F4102 (DOES NOT WORK) (Error: Invalid object)
Question: How do you setup the JDBC adapter so that you eliminate the need to have the fully qualified schema name?
Environment will require developing in test environment then promote to production database. There are also multiple schemas per database.
TESTDTA (Development Business Data)
TESTCTL (Development control tables)
CRPDTA (Test Business Data)
CRPCTL ( Test control tables)
PRODDTA (Production Business Data)
PRODCTL (Production control tables)
Tried using currentSchema=TESTDTA but that didn’t seem to do anything.
This is a very important issue for the client and if I can’t solve this issue the client may stop using webmethods.
Any help or examples would be greatly appreciated.