1 Reply Latest reply on Nov 5, 2013 3:35 PM by dhalek

    40EA1: Transaction handling for mySQL


      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'@'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?