Sunday, June 29, 2008

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

Belarc advisor - Very good tool to know about Windows system

This tool very quickly gave an excellent snapshot of my Windows box. It found details on disk, CPU, printers etc. I hope there is something like this for Unix too.
http://www.belarc.com/free_download.html