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.