Integration Server 10.5 | WmDB User’s Guide | Determining Whether to Use the WmDB Package or the Adapter for JDBC | When to Use the webMethods Adapter for JDBC
 
When to Use the webMethods Adapter for JDBC
You will want to use the Adapter for JDBC in most cases, including the following:
*Your system is likely to be expanded and modernized. This is typical for enterprise, mission-critical applications.
*You require better database performance. The performance of the Adapter for JDBC is superior to that of the WmDB package, particularly for batch operations. For example, to insert data into a database using the WmDB package, you use the pub.db:insert service; you supply the items to insert using a document list as input, and the pub.db:insert service processes each item in the document list sequentially without using JDBC standard facilities.
*You require or plan to use notification features.
*You need automatic and efficient database connection pool management.
*You require XA transactionality.
*You need to use JDBC standard data types, including BLOB and CLOB.
*You need to be able to configure services rather than hard code them.
*You need to use role-based security. The Adapter for JDBC allows the separation of the database administrator and development environments as needed. The WmDB package requires Administrator privileges.
*You want a configurable and structured user interface. Adapter for JDBC uses template-based configuration that is more structured and easier to use. The Adapter for JDBC uses metadata that helps protect the user's investment even if technology changes.
*You want to manage your database connection using webMethods Optimize for Infrastructure.