[Dbix-class] Manual Transaction Handling for Sybase ?

Jonathan Yu jonathan.i.yu at gmail.com
Wed Jul 8 19:57:25 GMT 2009


On Wed, Jul 8, 2009 at 3:53 PM, Rob Kinyon<rob.kinyon at gmail.com> wrote:
> On Wed, Jul 8, 2009 at 15:52, Jonathan Yu<jonathan.i.yu at gmail.com> wrote:
>> On Wed, Jul 8, 2009 at 3:49 PM, Robert
>> Heinzmann<Robert.Heinzmann at 1und1.de> wrote:
>>> Found a solution,
>>>
>>> the Problem is the "begin". If I skip the "begin", I can just run "commit / rollback" at the end.
>> Hm, does this mean that a transaction is automatically created upon
>> connection with the database?
>>
>> Perhaps this is an issue with DBD::Sybase; you might want to mail the
>> maintainer and ask for guidance there. Certainly beginning a
>> transaction automatically without your knowledge seems like strange
>> behaviour.
>
> It's arguable that this is actually the correct-est behavior. And, I
> think this is a Sybase thing, not a DBD::Sybase thing. Oracle also
> auto-starts transactions in many situations.
Could DBD::Sybase or maybe DBIx::Class be patched to ignore the first
->begin, so that everything works normally even for Sybase?
>
> Rob
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
>



More information about the DBIx-Class mailing list