How to configure webMethods JDBC Adapter to use Oracle RAC

If you have created a JDBC Adapter on WebMethods, it's a really straight forward process, but what happens when we have to connect to a Cluster

Try it and see what happens...

Now it's not that simple isn't?

Thankfully I have a workaround

1. Leave blank serverName, databaseName and portNumber fields.
2. In Other Properties enter your URL:

   url=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)
   (ADDRESS=(PROTOCOL=TCP)(HOST=host1) (PORT=1521))
   (ADDRESS=(PROTOCOL=TCP)(HOST=host2) (PORT=1521))
   (CONNECT_DATA=(SERVICE_NAME=service)))

I hope this will help you.

Built-In Services For Connections - WebMethods

Integration Server provides built‐in services that enable you to programmatically control connections.b You can use them to enable and disable a connection, and to return usage statistics and the current state (Enabled or Disabled) and error status for a connection. These services are located in the WmART package, in the pub.art.connection folder.

There are two built‐in services, setAdapterServiceNodeConnection and setPollingNotificationNodeConnection, that enable you to change the connection associated with an adapter service or notification respectively.

This is going to help you a lot and save you so much time if you haven't worked with this tool before.