Re: Validation query

From: Bob Lee (wliuei_at_hotmail.com)
Date: 05/12/04 

Date: Wed, 12 May 2004 15:40:31 -0700

Tom,

The whole story:

We have a Web application. The application uses MS SQL
Server database and Apache Jakarta commons-dbcp
connection pool to communicate with the database.

Every time after the database is re-started, the
application server is forced to re-start. Otherwise,
the connections that the pool keeps become invalid and
the system cannot get a connection for the database.

I think there is a possible solution: add a
validationQuery on the connection pool and set the
testOnBorrw parameter to true. However, I am wondering
this could cause an overhead on the transaction. The performance is a
big issue on our application. How much will it affect the performance?

Bob

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Oracle Connection Pool Performance
    ... ASP.NET - DOT NET 1.1 which means a connection pool using OLEDB. ... However there are no queries ... with huge buffer gets and the oracle stats do not point to anything ... Final info Database is 8.0.5 and no not an option to upgrade that yet, ...
    (microsoft.public.dotnet.framework.adonet)
  • MySQL and Cocoon
    ... I want to write some code that connects to a database from the Apache ... Cocoon servlet, to check authentication data. ... Here the problem, for me, is to write java code that reuse ... the connection pool set for other purposes. ...
    (comp.lang.java.databases)
  • Re: Generic user in web application and identification in database
    ... but we don't know wich will be the framework (struts, ADF, our own ... and as database Oracle 9i. ... I want to use an unique connection database. ... Have you thought about a connection pool per database user? ...
    (comp.databases.oracle.server)
  • Tomcat 5.5.7 - Monitoring Database Connection Pools
    ... Database: Oracle 10g ... I have set up a connection pool for my application, ... How can I monitor my database ... Can this be done by TOmcat or do I need to enable extensive ...
    (comp.lang.java.help)
  • Re: Project deletion from Server
    ... But in the web access it is deleting ... >server database, ... >A) CREATING A NEW ODBC CONNECTION ... >Server database, and then click the Next button. ...
    (microsoft.public.project.pro_and_server)