commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Trenton D. Adams" <tre...@athabascau.ca>
Subject Re: dbcp configurations
Date Thu, 24 Feb 2005 18:52:42 GMT
Andre Van Klaveren wrote:
> Are you setting timeBetweenEvictionRunsMillis?

Yes, checkout my new email.  It has my current intialization code.

> 
> 
> On Thu, 24 Feb 2005 10:44:39 -0700, Trenton D. Adams
> <trenta@athabascau.ca> wrote:
> 
>>Not so fast, removal of abandoned connectsion isn't working.  I'll make
>>another post for this.
>>
>>Trenton D. Adams wrote:
>>
>>>I figured it out.  The ManualPoolingDriverExample.java example helped
>>>quite a bit.  But, the documentation for how to get these things going
>>>is not easy to find, other than the examples and API.  But, a person
>>>shouldn't have to know the API all that well if all they want to do is
>>>use it. :)
>>>
>>>I decided to go with the following...
>>>
>>>    AbandonedConfig abandonedConfig;
>>>    ObjectPool connectionPool;
>>>    ConnectionFactory connectionFactory;
>>>    PoolableConnectionFactory poolableConnectionFactory;
>>>    PoolingDriver driver;
>>>
>>>    // setup the abandoned configuration
>>>    abandonedConfig = new AbandonedConfig();
>>>    abandonedConfig.setLogAbandoned(true);
>>>    abandonedConfig.setRemoveAbandoned(true);
>>>    abandonedConfig.setRemoveAbandonedTimeout(60);
>>>
>>>    // setup the AbandonedObjectPool
>>>    connectionPool = new AbandonedObjectPool(null, abandonedConfig);
>>>    ((GenericObjectPool)connectionPool).setMaxActive(maxConn);
>>>    ((GenericObjectPool)connectionPool).setMaxIdle(maxFree);
>>>    connectionFactory = new DriverManagerConnectionFactory(url,null);
>>>    poolableConnectionFactory = new PoolableConnectionFactory(
>>>        connectionFactory,connectionPool,null,
>>>        "SELECT 'ping' FROM dual",false,false);
>>>    try
>>>    {
>>>      Class.forName("org.apache.commons.dbcp.PoolingDriver");
>>>      dbcpURL = "jdbc:apache:commons:dbcp:" + poolname;
>>>      driver = (PoolingDriver) DriverManager.getDriver(dbcpURL);
>>>      driver.registerPool(name, connectionPool);
>>>    }
>>>    catch (Exception exception)
>>>    {
>>>      RemoteBannerServer.log(exception,
>>>          "error creating DBCP connection pool");
>>>    }
>>>
>>>This then allows a person to easily obtain a connection in the standard
>>>way like so...
>>>
>>>connection = DriverManager.getConnection(dbcpURL)
>>>
>>>
>>>poolname can be anything you like.  That way, the same JVM can use many
>>>different databases without worrying about the underlying driver or
>>>anything.  Just a reference to the poolname in the driver string and
>>>voila, you're in business.
>>>
>>>
>>>Andre Van Klaveren wrote:
>>>
>>>
>>>>Are you trying to configure it for use under Tomcat?
>>>>
>>>>Virtually,
>>>>Andre Van Klaveren
>>>>
>>>>
>>>>On Wed, 23 Feb 2005 09:45:55 -0700, Trenton D. Adams
>>>><trenta@athabascau.ca> wrote:
>>>>
>>>>
>>>>>Actually, that still doesn't get me anywhere because
>>>>>"org.apache.commons.dbcp.PoolableConnectionFactory" doesn't have any
>>>>>constructors that take abandoned configuration parameters.  Nor can I
>>>>>pass an AbandonedObjectPool object to one if it's contructors because
>>>>>that class's constructors don't take configuration parameters as
>>>>>parameters.
>>>>>
>>>>>Hmmm...
>>>>>
>>>>>Trenton D. Adams wrote:
>>>>>
>>>>>
>>>>>>Kle Miller pointed out how to get it working manually by constructing
>>>>>>everything myself.  Which is probably what I'll do for now, until
>>>>>>someone can tell me how the configuration file works.
>>>>>>
>>>>>>I found the JOCLContentHandler API documentation, which I had to
>>>>>>generate, was quite helpful.  I think I can get it working with a
>>>>>>configuration now.  Perhaps this documentation should be generated
with
>>>>>>the dbcp API documentation that's on the website?
>>>>>>
>>>>>>Trenton D. Adams wrote:
>>>>>>
>>>>>>
>>>>>>
>>>>>>>That list search really kinda bytes.  It can't find anything.
 I'm
>>>>>>>sure
>>>>>>>that what I'm about to ask has been asked many times.
>>>>>>>
>>>>>>>Ok, we have the configuration items at the following address...
>>>>>>>http://jakarta.apache.org/commons/dbcp/configuration.html
>>>>>>>
>>>>>>>But, there's nothing telling me how to configure them.  The example
>>>>>>>jocl
>>>>>>>configuration doesn't really say much.
>>>>>>>
>>>>>>>
>>>>>>>See this...
>>>>>>>----------------------
>>>>>>>  <!--
>>>>>>>     The next argument is the query to use to validate that a
>>>>>>>Connection is
>>>>>>>     still up and running.  It should return at least one row.
>>>>>>>     This functionality is optional. We'll just set it to null.
>>>>>>>   -->
>>>>>>>  <string null="true"/>
>>>>>>>  <!-- The default "read only" value for Connections. -->
>>>>>>>  <boolean value="false"/>
>>>>>>>  <!-- The default "auto commit" value for Connections. -->
>>>>>>>  <boolean value="true"/>
>>>>>>>----------------------
>>>>>>>
>>>>>>>I don't see an SQL query there, yet the comment says there's a
>>>>>>>query to
>>>>>>>validate the connection.
>>>>>>>
>>>>>>>Further, I'm really confused by "<boolean value="false"/>"
 what does
>>>>>>>something like that do?  It's not associated with a configuration
>>>>>>>parameter name or anything, how does that work?
>>>>>>>
>>>>>>>There doesn't appear to be anywhere that tells me how to *glue*
>>>>>>>everything together.  There's configuration item documentation,
>>>>>>>there's an example jocl configuration, but nothing to tell me
how I
>>>>>>>put one of the configuration items into the config file.
>>>>>>>
>>>>>>>All I'm trying to do is use a connection pool that supports removal
>>>>>>>and tracing of abandoned connections.  Does anyone know how to
get
>>>>>>>this working?
>>>>>>>
>>>>>>
>>>>>>
>>>>>--
>>>>>Trenton D. Adams
>>>>>Web Programmer Analyst
>>>>>Navy Penguins at your service!
>>>>>Athabasca University
>>>>>(780) 675-6195
>>>>>
>>>>>__
>>>>>   This communication is intended for the use of the recipient to
>>>>>whom it
>>>>>   is addressed, and may contain confidential, personal, and or
>>>>>privileged
>>>>>   information. Please contact us immediately if you are not the
>>>>>intended
>>>>>   recipient of this communication, and do not copy, distribute, or take
>>>>>   action relying on it. Any communications received in error, or
>>>>>   subsequent reply, should be deleted or destroyed.
>>>>>---
>>>>>
>>>>>---------------------------------------------------------------------
>>>>>To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
>>>>>For additional commands, e-mail: commons-user-help@jakarta.apache.org
>>>>>
>>>>>
>>>>
>>>>
>>>>---------------------------------------------------------------------
>>>>To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
>>>>For additional commands, e-mail: commons-user-help@jakarta.apache.org
>>>>
>>>
>>>
>>--
>>Trenton D. Adams
>>Web Programmer Analyst
>>Navy Penguins at your service!
>>Athabasca University
>>(780) 675-6195
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
>>For additional commands, e-mail: commons-user-help@jakarta.apache.org
>>
>>
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: commons-user-help@jakarta.apache.org
> 


-- 
Trenton D. Adams
Web Programmer Analyst
Navy Penguins at your service!
Athabasca University
(780) 675-6195

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


Mime
View raw message