webmethods JDBC URL - How to make it portable across server and schema name changes

webmethods JDBC adapter needs to be pointed to different databases as one moves to Development to QA to production. This also usually requires opening adapter services in developer tools and reselecting new schema name. One way to avoid this is to specify schema name in adapter connection properties and than select default schema while creating adapter services. Following are details on how to define schema while defining adapter connection.

DB2 – In adapter properties

currentSchema

Oracle – in adapter settings

databaseName lema

Sql server – In adapter properties

databaseName=AdventureWorks