Re: [GENERAL] how to use transaction isolation

2008-04-11 Thread Gong
On 4/11/08, Jan de Visser <[EMAIL PROTECTED]> wrote: >Your commit at (2) ends the transaction, and the second select runs in >a new one. >jan -- I got it. I didn't notice it is the *TRANSACTION* isolation. Thanks a lot! -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) T

Re: [GENERAL] how to use transaction isolation

2008-04-11 Thread Jan de Visser
On 4/10/08, Gong <[EMAIL PROTECTED]> wrote: > > > In the java code below, I set the transaction isolation to serialization. > > public class IsolationTest { > > private static String select = "select * from tmp where url = 'aaa'"; > > public static void main(String[] args) throws Exception{

Re: [GENERAL] how to use transaction isolation

2008-04-10 Thread Jan de Visser
On 4/10/08, Gong <[EMAIL PROTECTED]> wrote: > > > In the java code below, I set the transaction isolation to serialization. > > public class IsolationTest { > > private static String select = "select * from tmp where url = 'aaa'"; > > public static void main(String[] args) throws Exception{

[GENERAL] how to use transaction isolation

2008-04-10 Thread Gong
In the java code below, I set the transaction isolation to serialization. public class IsolationTest { private static String select = "select * from tmp where url = 'aaa'"; public static void main(String[] args) throws Exception{ //ConncetionFactory is a factory class for managi