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 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> References: <4fa2aa0c$0$294$14726298@news.sunsite.dk> <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 Arne Vajh=F8j wrote: > markspace wrote: >> Arne Vajh=F8j 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. >=20 > It is not. >=20 > ADO.NET has it at provider level: >=20 > http://msdn.microsoft.com/en-us/library/system.data.isolationlevel.aspx >=20 > 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=20 > 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 >=20 >>> 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! >=20 > Which will be a good excuse to look into the different > sub classes of SQLException and transient versus > non transient. --=20 Lew