db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject Re: AW: Derby Locking vs. Oracle's and MySQL's
Date Thu, 16 Oct 2008 02:49:02 GMT
Markus Junginger <Markus.Junginger@mobilexag.de> writes:

> Jørgen, thanks so much for your verification and clarification! 
>
> Because our application causing the locking issues is highly
> concurrent, I assume we would be better off migrating to MySQL. I
> will look into MySQL a little deeper; I would like to have
> serializable isolation level for a few tables.  At a first glance,
> MySQL should handle this as well:
> http://dev.mysql.com/doc/refman/5.1/en/innodb-transaction-isolation.html

Unless the following anomaly would be an issue (mvcc isn't quite
serializable):

http://pveentjer.wordpress.com/2008/10/04/breaking-oracle-serializable

Dag

Mime
View raw message