Board index » jbuilder » transaction/commit/abort with borland components?
transaction/commit/abort with borland components?
2004-07-15 08:38:38 PM
I have a problem with the borland database componenets.
I am supposed to do a query for editing a single row
select * from x where x.y = 'something' for update;
this sql query locks the row (on database side) so noone else can use
delete, update or for update on it.
BUT, for the lock to work it requires a 'begin transaction;" sql statement.
and to open the lock 'abort;' or 'commit;'
so, is there a way to do a simple query or statement without using the
queryDescriptors wich are kinda overkill for this (and propably use
their own transaction/commit behaviour).
OR is there a way of telling the database object to do this, i tried
.setUseTransactions(), but its only used with .saveChanges() and i NEED
the lock with simple select statememts.
any ideas welcome