On 3 Jul 2015, at 5:16pm, Kumar Suraj <surajnitk at gmail.com> wrote:

> So whats the solution here. I am giving 4 statements because i need insert
> to be transactional. Some other process could be inserting in the same db
> and so we need insert and row id values to be in one transaction.  Is there
> any other way i can achieve it.

Just issue your SQL commands as four separate commands.  The database knows 
that they all came from the same connection and it will keep the database 
locked for you until you COMMIT.

Simon.

Reply via email to