commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Phil Steitz <phil.ste...@gmail.com>
Subject Re: [dbcp] How to create replication aware connection pool ?
Date Wed, 06 Aug 2014 14:04:53 GMT
On 8/6/14 1:15 AM, Mark Thomas wrote:
> On 06/08/2014 01:34, Parth Patil wrote:
>> Hi Friends,
>> I am using DBCP2 in my project and I am pleased with the performance of the
>> library. Though I am only able to provide a single mysql host in the
>> connection string. What do I need to do inorder to make the DBCP connection
>> pool replication aware ?
> Write some code :). DBCP 2 is not replication aware. There was an
> enhancement request for this [1] but I resolved it as WONTFIX on the
> bases that:
> <quote>
> ...generally, failover requires some form of database replication and
> databases that provide that tend to provide JDBC drivers that support
> failover as well.
> </quote>
>
>> I am going to use 1 master and 2 slaves in my
>> setup. Am I correct in assuming that its possible to create connection pool
>> over several mysql hosts ?
> No, you are not correct.
>
>> I tried to use the replication aware mysql jdbc driver
>> (com.mysql.jdbc.ReplicationDriver)
> That is the correct way to do this.
>
>> but that doesn't seem to work and I am
>> getting an exception. Following is my test code
> <snip/>
>
>> Following is the exception that I am getting :
>>
>> [error] (run-main-0) java.lang.AbstractMethodError:
>> com.mysql.jdbc.ReplicationConnection.isValid(I)Z
> <snip/>
>
> DBCP2 uses JDBC4 (Java 1.6) and that is a new method introduced in that
> release.

I think you mean JDBC 4.1, Java 1.7 for DBCP2.

Phil
>
> You can avoid the call to that method by setting a validation query for
> your connection pool. For MySQL the following should work:
> /* ping */ SELECT 1
>
>
> Mark
>
> [1] https://issues.apache.org/jira/browse/DBCP-393
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
> For additional commands, e-mail: user-help@commons.apache.org
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
For additional commands, e-mail: user-help@commons.apache.org


Mime
View raw message