When to Use the WmDB Package
There are cases when it is more appropriate to use the WmDB package rather than the Adapter for JDBC. Use the WmDB package when:
You need immediate results from the execution of an SQL query. The WmDB package allows you to run quick SQL queries directly from the
Integration Server Administrator or DSP pages.
You have a need for ad hoc introspection of database objects, such as tables, views, aliases, synonyms, or stored procedures.
You want to customize management of the database connection pool.
You have a limited number of tasks that need to access a database.
You are required to integrate with a proprietary or a non-mainstream database, and you want to perform a quick, easy compatibility test before exploring an implementation that uses the
Adapter for JDBC. The
Adapter for JDBC supports all JDBC-compliant database implementations.
You are developing a throw-away test scenario.