Re: Transaction Isolation Level.
Monday, November 26, 2001 05:49 AM
well, transaction isolation level is just that - it is the isolation level given to a transaction that is being executed. locking is another issue. if you want locking, you need to implement it. transaction isolation level in JDBC is not there for database-independent locking during transaction. it is there to specify how will a single client transaction handle database communication, i.e. during the transaction, what will be data read from the database. this is implemented in the driver and not on the database side. there is no database-independent way to do table locking from J2EE so you have to implement that yourself and it will not be database-independent (most likely since each RDBMS handles locking different than another RDBMS).