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:
![*](chapterTOC_bullet.png)
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.
![*](chapterTOC_bullet.png)
You have a need for ad hoc introspection of database objects, such as tables, views, aliases, synonyms, or stored procedures.
![*](chapterTOC_bullet.png)
You want to customize management of the database connection pool.
![*](chapterTOC_bullet.png)
You have a limited number of tasks that need to access a database.
![*](chapterTOC_bullet.png)
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.
![*](chapterTOC_bullet.png)
You are developing a throw-away test scenario.