Hi Bill,
just now I'll only pick up your table and complete what I can.
> Select for update supported
> ---------------------------
> Oracle YES 0)
> Sybase ?
> Informix ?
> DB2 ?
> Postgres ?
> mySQL ?
> BerkelyDB ?
> SQL Server ?
Informix YES 1)
MySQL MyISAM NO 2)
MySQL BDB/BerkelyDB ? 3)
MySQL InnoDB YES 4)
Sybase YES 5)
SQL Server YES 6)
0) Oracle has 1 Option regarding waiting for the lock:
SELECT ... FOR UPDATE NOWAIT
1) Informix has 2 Options regarding waiting for the lock:
SELECT ... FOR UPDATE NOWAIT and
SELECT ... FOR UPDATE WAIT <time>
2) MySQL non transactional table types only support a
LOCK TABLE feature, which will isolate at the cost of
drastically reduced concurrency.
3) Not documented, had no time to test.
BDB is a transactional table type.
See http://www.sleepycat.com/
or http://www.mysql.com/doc/B/D/BDB.html
4) InnoDB is a full transactional table type.
The SELECT ... FOR UPDATE has no NOWAIT or WAIT option.
InnoDB has deadlock detection.
See http://www.innodb.com/
or http://www.mysql.com/doc/I/n/InnoDB.html
5) As of many open/closed problem reports (-:) and release
bulletins on the Sybase site http://www.sybase.com/.
6) As of the same source as 5)
regards
Georg
___ ___
| + | |__ Georg Rehfeld Woltmanstr. 12 20097 Hamburg
|_|_\ |___ [EMAIL PROTECTED] +49 (40) 23 53 27 10
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
