One strange thing is happening.
If I keep URL jdbc:mysql://192.168.6.128:3306/testenv1 in ds1.xml then connection is successful but if I change it to
jdbc:mysql://192.168.6.129:3306/testenv1 then connection is failing.
Same way,
If I keep URL jdbc:mysql://192.168.6.129:3306/testenv2 in ds2.xml then connection is successful but if I change it to
jdbc:mysql://192.168.6.128:3306/testenv2 then connection is failing.
So looks like MySQL is available on both the IPs (192.168.6.128 & 192.168.6.129) but if I make connection from
JDBC client running on one IP to MySQL server available on same server then only connection is possible
In simple words
128 (JDBC client ) to 128 ( MySQL Server) ==== > Pass
129 (JDBC client ) to 129 ( MySQL Server) ==== > Pass
128 (JDBC client ) to 129 ( MySQL Server) ==== > Fail
129 (JDBC client ) to 128 ( MySQL Server) ==== > Fail
Has anyone noticed something similar to this?