jdbc connection query cache

Hi, I realized that the cache paramter that I can specify when I open a jdbc connection works very well. The first time execution of a perpareStatement() takes very long, but additional calls use the cached version. I have many queries that contain something like this ... where id in ( 1, 2, 3,

JDBC transaction isolation level

hello, I wanted to set the transaction isolation level of a jdbc connection to java.sql.Connection.TRANSACTION_READ_UNCOMMITTED. As I discovered some error-messages like "too many lock requests" I wondered, why there are any lock-requests when I use this isolation-level (dirty reads are ok for