Transactions with datasnap, dbexpress and mysql

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

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Adrian Mercieca Tue, 25 Mar 2008 15:06

#189

Author: 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.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads