[OpenBD] Re: jdbc failover

[Victor Balada Diaz]

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