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]>
