Re: Cayenne Supported DBCP Properties

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu May 27 2010 - 08:26:45 UTC

  • Next message: Andrus Adamchik: "Re: Cayenne Supported DBCP Properties"

    Is there a deeper stack trace? Could it be that the specific
    validation query is failing or the pool can't establish a connection
    or something?

    Andrus

    On May 27, 2010, at 11:15 AM, Joe Baldwin wrote:

    > I asked this question previously but got no response. The problem
    > appears to be with Cayenne supported DBCP properties.
    >
    > My webapp is getting the following exception (Cayenne 3.0, with
    > dbcpdatasourcefactory):
    >
    > java.util.NoSuchElementException: Could not create a validated
    > object, cause: ValidateObject failed
    >
    > org
    > .apache
    > .commons
    > .pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1191)
    >
    > When the following two parameters are added to the dbcp.properties
    > file
    >
    > cayenne.dbcp.validationQuery="select 1"
    > cayenne.dbcp.testOnBorrow=true
    >
    > (Note: This does not occur if the two parameters are left out.)
    >
    > My understanding from the Apache DBCP docs is that the
    > "testOnBorrow" will not be run if the "validationQuery" parameter is
    > not set, and therefore they must both be set for this "testOnBorrow"
    > validation to occur.
    >
    > Furthermore, the cayenne docs
    >
    > http://cayenne.apache.org/doc30/dbcpdatasourcefactory.html
    >
    > list these two parameters as supported by Cayenne
    > dbcpDataSourceFactory.
    >
    > Questions:
    > 1. Are these parameters actually supported as I understand them, and
    > if so, then has anyone seen this exception?
    > 2. What is the default connection-validation behavior when these
    > parameters are absent from the configuration?



    This archive was generated by hypermail 2.0.0 : Thu May 27 2010 - 08:27:19 UTC