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:


select * from dt_log;
delete from dt_log where log_tsn=13068;


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'@'' for table 'all_tab_cols'

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





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