Re: JDBC Connection Pooling and Fail-over

From:

Tom Anderson <twic@urchin.earth.li>

Newsgroups:

comp.lang.java.programmer

Date:

Fri, 30 Oct 2009 16:56:02 +0000

Message-ID:

<alpine.DEB.1.10.0910301614270.15627@urchin.earth.li>

On Mon, 26 Oct 2009, Alex Collins wrote:

I have to be honest, I'm pretty new to JDBC. The driver I'm using is for
IBM Informix, and this will return a series of recognisable errors when
the schema changes or the connection to the database is lost. Simply
re-preparing or reconnecting and then executing again will solve the
issue, and this is something the caller need not even be aware of.

Sounds reasonable. I'm not sure why people were so aghast at your post.

Anyway, try:

http://commons.apache.org/dbcp/
http://proxool.sourceforge.net/
http://sourceforge.net/projects/c3p0/
http://www.source-code.biz/snippets/java/8.htm

Although i'm actually not sure these will do failover - i *think* they'll
pass the failure back to your code and leave it to get a fresh connection
and try again. Since fresh connections are really from a pool, this will
be cheap, but it's still awkward to code. With any luck, though, you'll be
alright - before returning a connection, the pool will validate it, and
this will weed out lost connections. I don't know if it will catch this
schema problem, though.

tom

--
Our only chance for survival is better engineering. -- James Dyson