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

Re: JDBC transaction isolation

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!npeer03.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
From	Lew <lewbloch@gmail.com>
Newsgroups	comp.lang.java.programmer
Subject	Re: JDBC transaction isolation
Date	Thu, 3 May 2012 14:00:06 -0700 (PDT)
Organization	http://groups.google.com
Lines	42
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>
NNTP-Posting-Host	69.28.149.29
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1
Content-Transfer-Encoding	quoted-printable
X-Trace	posting.google.com 1336078910 17454 127.0.0.1 (3 May 2012 21:01:50 GMT)
X-Complaints-To	groups-abuse@google.com
NNTP-Posting-Date	Thu, 3 May 2012 21:01:50 +0000 (UTC)
In-Reply-To	<4fa2d5c7$0$288$14726298@news.sunsite.dk>
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=69.28.149.29; posting-account=CP-lKQoAAAAGtB5diOuGlDQk0jIwmH0T
User-Agent	G2/1.0
X-Received-Bytes	2495
Xref	csiph.com comp.lang.java.programmer:14217

Show key headers only | 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