[storm] Storm and DBUtils

[Christopher Armstrong]

On Sat, Mar 1, 2008 at 11:58 AM, Sean Allen <sean at ardishealth.com> wrote:
>
>  On Feb 29, 2008, at 4:56 PM, Christopher Armstrong wrote:
>
>  > On Fri, Feb 29, 2008 at 4:29 PM, Sean Allen <sean at ardishealth.com>
>  > wrote:
>  >> Before I start in on this, I wanted to see if anyone had done any
>  >> work
>  >> on integrating DBUtils and Storm.
>  >>
>  >> If not, away I go, but if someone has, please point me in the proper
>  >> direction.
>  >
>  > I'm not sure if it makes sense to integrate the two; Storm provides
>  > many of the features already. All you need to do is make sure that
>  > Store objects are not shared between threads. Reconnection is done by
>  > Storm itself. Pooling is unnecessary. Managing thread-specific Store
>  > instances is something that's left up to you (or the framework), but
>  > we provide storm.zope to help with this (as well as zope transaction
>  > integration) for Zope users. It'd be great to add support for more
>  > thread-managing frameworks over time.
>
>  I'm particular interested in the persistent connection aspect of
>  DBUtils which I cant find any implementation of in Storm.
>
>  Am I wrong on that?

The latest release of Storm automatically reconnects when the
connection to the SQL server is lost. The statement that is being run
at the time the connection is lost will fail (with an exception type
which you can use to retry a transaction), but the next transaction
will work.

-- 
Christopher Armstrong
International Man of Twistery
http://radix.twistedmatrix.com/
http://twistedmatrix.com/
http://canonical.com/