Hi, The SAVEPOINT concept worked for me. Thanks a tonn!!
It would be of great help if you can help me out on how to release locks on tables and resources in SOCI.. Sent from my iPhone. Brevity may be excused. Thank You. Regards, Medhavi Mahansaria. > On 27-Nov-2014, at 8:42 pm, Mateusz Loskot <mate...@loskot.net> wrote: > > On 27 November 2014 at 13:14, Medhavi Mahansaria > <medhavi1...@yahoo.co.in> wrote: >> >> I would like to know how to configure savepoint and commit work release >> option using SOCI. > > Do you mean savepoint as SAVEPOINT syntax in SQL? > There is no built-in support for that in SOCI, but you should be able > to execute such statements > > sql.once << "SAVEPOINT myname"; > ... > sql.once << "ROLLBACK TO SAVEPOINT myname"; > > > It should be easy to create a RAII wrapper for this, > similar to soci::transaction > http://soci.sourceforge.net/doc/3.1/statements.html#transactions > > I'd be interested to know if SAVEPOINT statements worked for you, > so please let me know. > > Best regards, > -- > Mateusz Loskot, http://mateusz.loskot.net > > ------------------------------------------------------------------------------ > Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server > from Actuate! Instantly Supercharge Your Business Reports and Dashboards > with Interactivity, Sharing, Native Excel Exports, App Integration & more > Get technology previously reserved for billion-dollar corporations, FREE > http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk > _______________________________________________ > soci-users mailing list > soci-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/soci-users ------------------------------------------------------------------------------ Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=157005751&iu=/4140/ostg.clktrk _______________________________________________ soci-users mailing list soci-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/soci-users
