[OpenBD] Re: jdbc failover

[Nitai @ SixSigns]

Hi Victor




Kind Regards,
Nitai

On Dec 16, 2008, at 9:22 AM, Victor Balada Diaz wrote:

Set "cacheResultSetMetadata=true" to FALSE and try again. I went over a week with such errors until I disabled the Metadata.

Hello,

I'm trying to test jdbc failover with OpenBlueDragon 1.0. I've setup
the following datasource:



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:


EXCEPTION ** com.mysql.jdbc.CommunicationsException MESSAGE:

EXCEPTION ** java.net.SocketException MESSAGE: Connection reset
STACKTRACE: java.net.SocketException: Connection reset at
java.net.SocketInputStream.read(SocketInputStream.java:168) at

[ 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 !!
-~----------~----~----~----~------~----~------~--~---

<hoststring>jdbc:mysql://127.0.0.1:10001,127.0.0.1:10002/db_test? useUnicode=true&amp;characterEnco ding = UTF -8 &amp ;jdbcCompliantTruncation = false &amp;cacheResultSetMetadata=true&amp;useDynamicCharsetInfo=false&am p ;zeroDateTimeBehavior =convertToNull&amp;autoReconnect=true&amp;failOverReadOnly=false</ hoststring> Communications link failure due to underlying exception: ** BEGIN NESTED Communications link failure due to underlying exception: ** BEGIN NESTED 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)

--
Razuna On-Demand - Hosted Digital Asset Management Solution

http://www.razuna.com/

Kabunto - Open Source Forum Solution
http://www.kabunto.org/

Roozani - memorize everywhere
http://www.roozani.com/

SixSigns - Enrich people’s lives and web experience
http://www.sixsigns.com
http://blog.sixsigns.com

Follow us on Twitter
http://twitter.com/sixsigns

Razuna - Open Source Digital Asset Management with Web Content Management

smime.p7s
Description: S/MIME cryptographic signature