Re: insert blocking? - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: insert blocking?
Date
Msg-id 1021330394.2635.35.camel@inspiron.cramers
Whole thread Raw
In response to insert blocking?  (Haug Bürger <buerger@iml.fhg.de>)
List pgsql-jdbc
Haug,

you will need to execute the insert within a transaction to get the
insert to block

ie:
con.setAutoCommit(false)
execute("begin; lock table")
executeUpdate("insert ...."
con.commit()

Dave

On Mon, 2002-05-13 at 05:36, Haug Bürger wrote:
> Hi,
>
> i use a prepared statement to insert a new record. Is it possible
> that an insert blocks? In other words can the
> myInsertStmt.executeUpdate() call block?
>
> thanks
>     Haug
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
>




pgsql-jdbc by date:

Previous
From: tony
Date:
Subject: Re: dreamweaver mx
Next
From: Bruno Lamouret
Date:
Subject: Re: select * from mytable where myfield=null;