Yogesh Dhimate

I feel every webMethods integration developer should have a local installation of MySQL database as it is fairly lightweight and free to use. I use XAMPP to setup MySQL on my development system. It also provides an HTTP server and very usable admin console to get things done quickly. This helps a lot in creating proofs of concept or simply trying out new things on the database without bothering DBAs in your organization.

webMethods Integration Server supports connectivity with MySQL database using JDBC Adapter.  The configuration is as described below.

Copy the JAR

1. Download mysql connector jar (mysql-connector-java-5.1.33-bin.jar) from MySQL site. 
2. Add this jar to <IntegrationServer>/lib/jars folder
3. Restart the Integration Server, go to 'About' page and make sure that you see the jar listed in the server classpath     
   

• Configure JDBC adapter connection as shown below. 

• Enable the connection

Once JDBC adapter connection is enabled you can use it to create your adapter services using webMethods designer.