This discussion is archived
1 Reply Latest reply: Nov 5, 2013 7:35 AM by dhalek RSS

40EA1: Transaction handling for mySQL

dhalek Explorer
Currently Being Moderated

Hello out there,

it seems that I cannot handle transactions with mySQL connections anymore.

In older versions I could do something like this:

 

/*sqldev:stmt*/begin;
select * from dt_log;
delete from dt_log where log_tsn=13068;
/*sqldev:stmt*/rollback;

 

Now these /*sqldev:stmt*/ hints do not work properly anymore. The first one seems to work. But the second one gives an error like this:

SELECT command denied to user 'tsn'@'pc259.vu2k.vertriebsunion.de' for table 'all_tab_cols'

Now, is this intended and if so, is there a way to use transactions on mySQL?

 

Regards,

dhalek

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points