springframework-developer Mailing List for Spring Framework (Page 200)

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Most large enterprise applications will suffer from deadlock exceptions
especially when delegating SQL to an ORM mapping tool that decides when =
to
flush SQL and in what order to issue statements. Because SQL execution =
order
is out of the hands of the developer, the only other means we have at
preventing deadlocks is careful specification of page/row level locking.

Many people want to respond to a deadlock exception by simply retrying =
the
query. They don't always realize that once a deadlock exception occurs, =
the
transaction is rolling back (at least in the databases that I am =
familiar
with). A retry can be effective, but the entire transaction must be =
retried.

That said, a means of differentiating a deadlock exception from other =
types
of fatal (to the transaction) exceptions would be useful.

> -----Original Message-----
> From: spr...@li...
> [mailto:spr...@li...] On =
Behalf
> Of tho...@tr...
> Sent: Wednesday, December 01, 2004 6:04 PM
> To: spr...@li...
> Subject: Re: [Springframework-developer] Fw: [Springframework-user]
> DeadlockLoserDataAccessException
>=20
> Forgot that the issue was regarding DeadlockLoserDataAccessException.  =
You
> could
> still use the custom translation - just modify the codes and exception
> thrown.
> Don't know if this is common enough to warrant its own exception =
category.
> What do yuo think?
>=20
> Thomas
>=20
>=20
> Quoting tho...@tr...:
>=20
> > Craig & Juergen,
> >
> > We recently added categories for OptimisticLockingFailure and
> > CannotAcquireLock.
> >  We could also add a category for CannotSerializeTransaction - I =
could
> add it
> > for next release.  In the meantime you can use our custom =
translation
> feature
> > -
> > here is an example of an sql-error-codes.xml file with a custom
> translation
> > added for Oracle:
> >
> > <beans>
> >
> >   <bean id=3D"Oracle"
> class=3D"org.springframework.jdbc.support.SQLErrorCodes">
> >     <property name=3D"badSqlGrammarCodes">
> >       <value>900,903,904,917,936,942,17006</value>
> >     </property>
> >     <property name=3D"dataIntegrityViolationCodes">
> >       <value>1,1400,1722,2291</value>
> >     </property>
> >     <property name=3D"cannotAcquireLockCodes">
> >       <value>54</value>
> >     </property>
> >     <property name=3D"customTranslations">
> >       <list>
> >         <bean
> >
> > =
class=3D"org.springframework.jdbc.support.CustomSQLErrorCodesTranslation"=
>
> >         <property name=3D"errorCodes">
> >           <value>8177</value></property>
> >         <property name=3D"exceptionClass">
> >
> >
> =
<value>org.springframework.dao.CannotSerializeTransactionException</value=
>
> >         </property>
> >       </bean>
> >     </list>
> >   </property>
> >   </bean>
> >
> > </beans>
> >
> > This will catch any ORA-08177 errors and throw a
> > CannotSerializeTransactionException.
> >
> > Thomas
> >
> >
> >
> > Quoting "j=FCrgen h=F6ller [werk3AT]" <jue...@we...>:
> >
> > > Thomas, everybody,
> > >
> > > A valid point. Any ideas on this?
> > >
> > > Juergen
> > >
> > >
> > > ________________________________
> > >
> > > Von: spr...@li... im Auftrag =
von
> Craig
> > > Shearer
> > > Gesendet: Mi 01.12.2004 22:38
> > > An: spr...@li...
> > > Betreff: [Springframework-user] DeadlockLoserDataAccessException
> > >
> > >
> > >
> > > Hello all Springers
> > >
> > > We're using Spring in conjunction with Hibernate, and MySQL, and =
we're
> > > trying to deal with deadlock situations. Right now, when the =
database
> > > encounters a deadlock, it gets thrown as an
> > > UncategorizedDataAccessException. What we'd like is for deadlocks =
to
> be
> > > thrown as the specific DeadlockLoserDataAccessException.
> > >
> > > So, I did a little reading on this, and read some of the Spring
> source. It
> > > appears that although the DeadlockLoserDataAccessException class
> exists, it
> > > is not thrown anywhere. Now, I've read the source code for the
> > SQLErrorCodes
> > > class, expecting to be able to supply a customised =
sql-error-codes.xml
> > file,
> > > but it appears there is no facility to specify deadlock codes.
> > >
> > > Does anybody have any comment on this? We could enhance the
> SQLErrorCodes
> > > class ourselves and submit it as a patch, or perhaps somebody else =
has
> a
> > > solution. (Or am I on the wrong track entirely?)
> > >
> > > Regards,
> > >
> > > Craig Shearer
> > >
> > > Senior Technical Architect
> > > GFG Group
> > > http://www.gfg-group.com
> > > mailto:csh...@gf...
> > >
> > > Phone: +64 (0) 9 966 7097
> > > Mobile: +64 (0) 27 4936 334
> > >
> > >
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > SF email is sponsored by - The IT Product Guide
> > > Read honest & candid reviews on hundreds of IT Products from real
> users.
> > > Discover which products truly live up to the hype. Start reading =
now.
> > > http://productguide.itmanagersjournal.com/
> > > _______________________________________________
> > > Springframework-user mailing list
> > > Spr...@li...
> > > https://lists.sourceforge.net/lists/listinfo/springframework-user
> > >
> > >
> > >
> > >
> > > -------------------------------------------------------
> > > SF email is sponsored by - The IT Product Guide
> > > Read honest & candid reviews on hundreds of IT Products from real
> users.
> > > Discover which products truly live up to the hype. Start reading =
now.
> > > http://productguide.itmanagersjournal.com/
> > > _______________________________________________
> > > Springframework-developer mailing list
> > > Spr...@li...
> > > =
https://lists.sourceforge.net/lists/listinfo/springframework-developer
> > >
> >
> >
> >
> >
> >
> > -------------------------------------------------------
> > SF email is sponsored by - The IT Product Guide
> > Read honest & candid reviews on hundreds of IT Products from real =
users.
> > Discover which products truly live up to the hype. Start reading =
now.
> > http://productguide.itmanagersjournal.com/
> > _______________________________________________
> > Springframework-developer mailing list
> > Spr...@li...
> > =
https://lists.sourceforge.net/lists/listinfo/springframework-developer
> >
>=20
>=20
>=20
>=20
>=20
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real =
users.
> Discover which products truly live up to the hype. Start reading now.
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> Springframework-developer mailing list
> Spr...@li...
> https://lists.sourceforge.net/lists/listinfo/springframework-developer

2003	Jan	Feb (55)	Mar (100)	Apr (203)	May (330)	Jun (190)	Jul (302)	Aug (323)	Sep (197)	Oct (245)	Nov (490)	Dec (330)
2004	Jan (194)	Feb (400)	Mar (416)	Apr (415)	May (359)	Jun (381)	Jul (491)	Aug (311)	Sep (291)	Oct (273)	Nov (355)	Dec (266)
2005	Jan (306)	Feb (303)	Mar (520)	Apr (346)	May (255)	Jun (221)	Jul (171)	Aug (247)	Sep (147)	Oct (125)	Nov (165)	Dec (65)
2006	Jan (90)	Feb (53)	Mar (121)	Apr (103)	May (113)	Jun (103)	Jul (104)	Aug (67)	Sep (78)	Oct (82)	Nov (78)	Dec (70)
2007	Jan (77)	Feb (76)	Mar (63)	Apr (30)	May (47)	Jun (41)	Jul (44)	Aug (44)	Sep (49)	Oct (33)	Nov (25)	Dec (21)
2008	Jan (45)	Feb (13)	Mar (15)	Apr (12)	May (9)	Jun (33)	Jul (30)	Aug (7)	Sep (20)	Oct (17)	Nov (20)	Dec (10)
2009	Jan (8)	Feb (5)	Mar (12)	Apr (17)	May (19)	Jun (97)	Jul (77)	Aug (33)	Sep (24)	Oct (41)	Nov (16)	Dec (32)
2010	Jan (24)	Feb (14)	Mar (50)	Apr (71)	May (70)	Jun (64)	Jul (45)	Aug (62)	Sep (32)	Oct (4)	Nov (12)	Dec (2)
2011	Jan (1)	Feb (3)	Mar (4)	Apr (3)	May (6)	Jun (1)	Jul (4)	Aug (3)	Sep (4)	Oct (6)	Nov (3)	Dec (3)
2012	Jan (4)	Feb (8)	Mar (6)	Apr (10)	May (2)	Jun (3)	Jul (11)	Aug (10)	Sep (4)	Oct	Nov (1)	Dec (1)
2013	Jan (4)	Feb (1)	Mar (9)	Apr (1)	May (8)	Jun (2)	Jul (5)	Aug (2)	Sep	Oct (3)	Nov (10)	Dec (8)
2014	Jan (3)	Feb (12)	Mar (9)	Apr (12)	May (2)	Jun	Jul (3)	Aug (1)	Sep (1)	Oct (4)	Nov	Dec (2)
2015	Jan (1)	Feb (3)	Mar (4)	Apr (9)	May (2)	Jun (2)	Jul	Aug (2)	Sep (7)	Oct (9)	Nov (7)	Dec (9)
2016	Jan (7)	Feb (5)	Mar (5)	Apr (5)	May (8)	Jun (4)	Jul (5)	Aug (4)	Sep (6)	Oct (7)	Nov (2)	Dec (3)
2017	Jan (7)	Feb (8)	Mar (7)	Apr (3)	May (4)	Jun (3)	Jul (5)	Aug (8)	Sep (4)	Oct (2)	Nov (3)	Dec
2018	Jan	Feb	Mar	Apr (1)	May	Jun (1)	Jul	Aug	Sep	Oct	Nov (1)	Dec
2019	Jan	Feb (1)	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec (1)
2021	Jan	Feb (1)	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2022	Jan	Feb (1)	Mar	Apr	May	Jun	Jul	Aug	Sep (1)	Oct	Nov	Dec
2024	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov (1)	Dec
2025	Jan	Feb	Mar	Apr	May (1)	Jun	Jul (2)	Aug (5)	Sep (2)	Oct	Nov	Dec (1)
2026	Jan (1)	Feb	Mar (1)	Apr	May	Jun	Jul (1)	Aug	Sep	Oct	Nov	Dec

springframework-developer Mailing List for Spring Framework (Page 200)

springframework-developer — Spring Framework developers list