Could you please tell me where the document is on how
to configure and start and access Avalon's connection
pool.
Thank you,
Randy Speh
--- Berin Loritsch <[EMAIL PROTECTED]> wrote:
> Randy Speh wrote:
>
> > Thanks for the info. Would you mind telling me
> the
> > differences between Avalon and Fulcrum/Commons.
> >
> > I just wasn't aware of Avalon for some reason.
> I've
> > been submerged in Turbine, Torque, Fulcrum and
> Commons
> > code.
>
>
> Honestly, I can only tell you what Avalon does (I
> wrote
> the code for the DB pooling). I don't know what
> Fulcrum
> is much less what it does. As for Commons, I have
> only
> had a cursory look at it, so I am not the one to
> answer this.
>
>
> >
> > Thanks,
> > Randy
> > --- Berin Loritsch <[EMAIL PROTECTED]> wrote:
> >
> >>Randy Speh wrote:
> >>
> >>
> >>>I would be very interested to see what your
> >>>
> >>connection
> >>
> >>>pooling code looks like. I been trying to choose
> >>>
> >>the
> >>
> >>>most appropriate connection pooling technique and
> >>>
> >>have
> >>
> >>>been considering adapting one myself. Although,
> >>>
> >>I'd
> >>
> >>>really rather use something from the open source
> >>>community.
> >>>
> >>>
> >>
> >>Currently there is dbcp in Commons, Turbine
> >>connection pooling,
> >>and Avalon connection pooling.
> >>
> >>Both DBCP and Avalon provide similar semantics
> >>inspired by
> >>the official JDBC DataSource specifications--when
> >>you "close"
> >>the connection, it returns the Connection to the
> >>pool. Turbine
> >>(if I recall) makes you explicitly return it to
> the
> >>pool yourself.
> >>
> >>I won't get involved with which is the best
> pattern.
> >>
> >>Beyond that basic difference, there is alot of
> >>difference in the
> >>manner that the connection pools are configured.
> >>Since I don't
> >>have any real information on DBCP and Turbine
> >>pooling, I won't
> >>talk about them. Here is what Avalon's
> >>Configuration looks like:
> >>
> >><connection>
> >> <pool-controller min="2" max="10" grow="2">
> >> <keep-alive>SELECT 1 FROM DUAL</keep-alive>
> >> </pool-controller>
> >>
> >>
> <driver>oracle.jdbc.driver.OracleDriver</driver>
> >>
>
>><dburl>jdbc:oracle:thin:@localhost:1521:ORCL</dburl>
> >> <user>scott</user>
> >> <password>tiger</password>
> >></connection>
> >>
> >>The Pool Controller specifies how many connections
> >>the pool starts
> >>with ("min"), the absolute maximum number of
> >>connections ("max"),
> >>and how many new connections it creates at a time
> >>when it needs
> >>more ("grow"). It is important to note that the
> >>maximum is absolute.
> >>The pool will not go beyond that maximum number.
> >>The reason being
> >>that some drivers have license restrictions and it
> >>helps the pool
> >>to not violate the license. The last part
> >>("keep-alive") is the
> >>query used by the pool to determine if the
> >>connection has been closed
> >>by the server. We found out that not all
> databases
> >>are created
> >>equal, and while "SELECT 1" works for many
> >>databases, Oracle requires
> >>that "1" be selected from the dummy table "DUAL",
> >>and others like
> >>Informix require you to select from an
> application's
> >>table.
> >>
> >>You can determine for yourself if this is
> >>desirable--and possibly
> >>DBCP might steal ideas to narrow the differences.
> >>Who knows....
> >>
> >>
> >>--
> >>
> >>"They that give up essential liberty to obtain a
> >>little temporary safety
> >> deserve neither liberty nor safety."
> >> - Benjamin Franklin
> >>
> >>
> >>--
> >>To unsubscribe, e-mail:
>
>><mailto:[EMAIL PROTECTED]>
> >>For additional commands, e-mail:
> >><mailto:[EMAIL PROTECTED]>
> >>
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Send your FREE holiday greetings online!
> > http://greetings.yahoo.com
> >
> > --
> > To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> > For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
> >
> > .
> >
> >
>
>
>
> --
>
> "They that give up essential liberty to obtain a
> little temporary safety
> deserve neither liberty nor safety."
> - Benjamin Franklin
>
>
> --
> To unsubscribe, e-mail:
> <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail:
> <mailto:[EMAIL PROTECTED]>
>
__________________________________________________
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
