commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andre Van Klaveren <nyb...@gmail.com>
Subject Re: dbcp configurations
Date Thu, 24 Feb 2005 18:45:00 GMT
Are you setting timeBetweenEvictionRunsMillis?


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


Mime
View raw message