[OpenBD] Re: jdbc failover

[Nitai @ SixSigns]

Glad to read that. Matt is about to change the Admin datasource setion for MySQL include this setting.

On Dec 17, 2008, at 11:40 AM, Victor Balada Diaz wrote:

Hello Nitai,

It's working now. Thanks for the help.

On Tue, 2008-12-16 at 23:12 +0100, Nitai @ SixSigns wrote:

Hi Victor

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

Kind Regards,
Nitai

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

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&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>

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

113) at
com
.mysql
.jdbc
.util
.ReadAheadInputStream
.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)
at
com

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.

.mysql .jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java: .mysql .jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:

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

--
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