Hello, I'm trying to test jdbc failover with OpenBlueDragon 1.0. I've setup the following datasource:
<hoststring>jdbc:mysql://127.0.0.1:10001,127.0.0.1:10002/db_test?useUnicode=true&characterEnco ding=UTF-8&jdbcCompliantTruncation=false&cacheResultSetMetadata=true&useDynamicCharsetInfo=false&am p;zeroDateTimeBehavior=convertToNull&autoReconnect=true&failOverReadOnly=false</hoststring> Taking down 127.0.0.0.1:10001 and testing from OpenBD administration webpage seems to work without problems, but doing the same from a cfquery inside our app fails with the following exception: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** com.mysql.jdbc.CommunicationsException MESSAGE: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: Connection reset STACKTRACE: java.net.SocketException: Connection reset at java.net.SocketInputStream.read(SocketInputStream.java:168) at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:113) at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160) at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188) at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1994) at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:573) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1044) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2748) at com.mysql.jdbc.Connection.<init>(Connection.java:1553) at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285) [ rest skipped, in case it's needed i could attach it ] Is there anything i'm doing wrong to get jdbc failover working? Thanks in advance. Regards. --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official blog @ http://blog.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
