Groups > comp.lang.java.programmer > #14217

Re: JDBC transaction isolation

From	Lew <lewbloch@gmail.com>
Newsgroups	comp.lang.java.programmer
Subject	Re: JDBC transaction isolation
Date	2012-05-03 14:00 -0700
Organization	http://groups.google.com
Message-ID	<12060445.34.1336078806378.JavaMail.geo-discussion-forums@pbbpg8> (permalink)
References	<jnu4pj$ncr$1@dont-email.me> <4fa2aa0c$0$294$14726298@news.sunsite.dk> <jnujl6$os4$1@dont-email.me> <4fa2d5c7$0$288$14726298@news.sunsite.dk>

Show all headers | View raw

Arne Vajhøj wrote:
> markspace wrote:
>> Arne Vajhøj wrote:
>>> You let the database do it - not the driver.
>>
>> Yes, OK. Driver/DB thing. At some lower level than my app.
>>
>>> It is a classic database topic.
>>
>>
>> Hmm, I'll try to find some other sources then, if it's a general topic
>> and not restricted to JDBC implementations.
> 
> It is not.
> 
> ADO.NET has it at provider level:
> 
> http://msdn.microsoft.com/en-us/library/system.data.isolationlevel.aspx
> 
> Almost all database have it at the SQL level:

But not all DBMSes support all four transaction levels.

> http://dev.mysql.com/doc/refman/5.5/en/set-transaction.html
> http://www.postgresql.org/docs/9.1/static/sql-set-transaction.html and 
> http://www.postgresql.org/docs/9.1/static/transaction-iso.html
> http://msdn.microsoft.com/en-us/library/ms173763.aspx
> http://docs.oracle.com/cd/B10500_01/server.920/a96524/c21cnsis.htm
> 
>>> The code is good in the sense that it will prevent duplicates.
>>>
>>> For more serious usage you should consider to retry a couple of times
>>> in case of a transaction timeout.
>>
>> Ah, ok. Something else to check into. Thanks!
> 
> Which will be a good excuse to look into the different
> sub classes of SQLException and transient versus
> non transient.

-- 
Lew

Thread

JDBC transaction isolation markspace <-@.> - 2012-05-03 07:30 -0700
  Re: JDBC transaction isolation Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 11:53 -0400
    Re: JDBC transaction isolation markspace <-@.> - 2012-05-03 11:43 -0700
      Re: JDBC transaction isolation Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 15:00 -0400
        Re: JDBC transaction isolation Lew <lewbloch@gmail.com> - 2012-05-03 14:00 -0700
          Re: JDBC transaction isolation Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 17:13 -0400
        Re: JDBC transaction isolation "Richard Maher" <maher_rj@hotspamnotmail.com> - 2012-05-04 06:23 +0800
          Re: JDBC transaction isolation Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 19:57 -0400
            Re: JDBC transaction isolation Richard Maher <maherrj@googlemail.com> - 2012-05-03 19:08 -0700
              Re: JDBC transaction isolation Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 22:34 -0400
                Re: JDBC transaction isolation Richard Maher <maherrj@googlemail.com> - 2012-05-03 20:11 -0700
                Re: JDBC transaction isolation Richard Maher <maherrj@googlemail.com> - 2012-05-03 22:33 -0700
                Re: JDBC transaction isolation Arne Vajhøj <arne@vajhoej.dk> - 2012-05-04 08:27 -0400
                Re: JDBC transaction isolation Lew <lewbloch@gmail.com> - 2012-05-04 06:58 -0700
          Re: JDBC transaction isolation Lew <lewbloch@gmail.com> - 2012-05-03 17:15 -0700
            Re: JDBC transaction isolation Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 21:22 -0400
              Re: JDBC transaction isolation Lew <lewbloch@gmail.com> - 2012-05-03 18:32 -0700

csiph-web