db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Suavi Ali Demir <dem...@yahoo.com>
Subject Re: Auto-reconnect, connection pool connection validation query question
Date Thu, 20 Jan 2005 22:21:17 GMT
values(1)

This is valid derby sql.

Regards,
Ali


--- Jonathan Eric Miller <jemiller@uchicago.edu>
wrote:

> I'm in the process of attempting to use Derby with
> Tomcat and it's built-in 
> connection pool. I'm wondering if Derby's JDBC
> driver as an "autoReconnect" 
> property like MySQL has which will automatically
> reestablish a connection 
> that has been broken? Failing that, I'm wondering if
> anyone has an idea for 
> a simple query that could be used as a validation
> query to verify that the 
> connection is valid. Tomcat's connection pool lets
> you specify a query that 
> is tried on connections before it hands them out to
> you that way you know 
> that the connection is valid (i.e. the connection
> hasn't been timed out by 
> the server or otherwise dropped to to network
> failure and the like). For 
> other DBMSes, I've used a simple query of "SELECT
> '1'". However, this 
> doesn't appear to be a valid SQL statement in Derby.
> Has anyone else ran 
> into this problem?
> 
> <Context>
> <Resource name="jdbc/..."
> auth="Container"
> type="javax.sql.DataSource"
> driverClassName="com.ibm.db2.jcc.DB2Driver"
> url="jdbc:derby:net://localhost:1527/..."
> username="..."
> password="..."
> maxActive="5"
> maxIdle="5"
> maxWait="60000"
> validationQuery="SELECT '1'"
> removeAbandoned="true"
> removeAbandonedTimeout="60"
> logAbandoned="true"/>
> </Context>
> 
> Jon
> 
> 


Mime
View raw message