Transactions with datasnap, dbexpress and mysql

Article View: borland.public.cppbuilder.database.dbexpress

Article #189

Back to borland.public.cppbuilder.database.dbexpress Previous Next

#189

From: Adrian Mercieca
Date: Tue, 25 Mar 2008 15:06

18 lines
1549 bytes

Hi,

Does anyone know if the codegear dbexpress driver for mysql works well 
with transactions?

Are they supported at all?

Reading the TransactionsSupported property returns true, but when I did 
a test to invoke a stored procedure that updates some tables from within 
a datasnap application, the subsequent rollback call I'm doing (for 
testing purposes) is failing completely - the updates are still 
committed to the database despite calling StartTransaction on the 
connection before invoking the stored procedure and then calling 
Rollback when the stored proc returns!

Any clues?

Tks - Adrian.

Technical Details

Message-ID: <47e91468$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!ecngs!feeder2.ecngs.de!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: fb4e2,23c013b71641e47c,start
X-Google-Attributes: gidfb4e2,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Tue, 25 Mar 2008 16:06:11 +0100
From: Adrian Mercieca <amercieca@gmail.com>
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.dbexpress
Subject: Transactions with datasnap, dbexpress and mysql
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 195.158.111.182
Message-ID: <47e91468$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1206457448 195.158.111.182 (25 Mar 2008 08:04:08 -0700)
Lines: 18
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!ecngs!feeder2.ecngs.de!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail