1 Reply Latest reply: Nov 5, 2013 9:35 AM by dhalek RSS

    40EA1: Transaction handling for mySQL

    dhalek

      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