[cgiapp] Re: Combining DBIx::Simple and CGI::Session

[Mark Stosberg]

> >>>> Use 2 handles, 1 via DBIx::Simple for all normal queries, and 1  
> >>>> via DBI
> >>>> just for use with CGI::Session?
> >>>
> >>> Actually, another possibility is to use 2 DBIx::Simple-based  
> >>> handles,
> >>> one for all normal queries, and one to pass to CGI::Session but  
> >>> not ever
> >>> use via DBIx::Simple.
> >>
> >> I asked the author about this. I think it's not that the dual-life
> >> My recommendation is to share the handle between DBIx::Simple and
> >> CGI::Simple and test that your application doesn't blow up.
> >
> > OK. Thanx for checking.
> 
> Is there a risk that a transaction will span the app and the session  
> with a single connection? You may wish to rollback one and commit the  
> other...

I can't see how this would come up without some intentionally bad
design. 

    Mark

-- 
http://mark.stosberg.com/bike