Hi, > By the way: I am using MVCC=TRUE. MULTI_THREADED=YES is no option for > me because I have problems with the possible deadlock situation > (discussed in some other threads).
What's make you think that MVCC vs MULTI_THREADED settings will affect your chances to get an DeadLock ? If I'm not missing something two connections can end in a DeadLock situation in any mode as consequence of resource locking order only . >> - Does another connection pool support such a feature? > It seems to me that PostgreSQL supports this (table 31-2): > http://www.postgresql.org/files/documentation/books/pghandbuch/html/jdbc-datasource.htm Apache DBCP (http://commons.apache.org/dbcp/configuration.html) support the following connection factory setting: Parameter Default Description defaultAutoCommit true The default auto-commit state of connections created by this pool. defaultReadOnly driver default The default read-only state of connections created by this pool. If not set then the setReadOnly method will not be called. (Some drivers don't support read only mode, ex: Informix) defaultTransactionIsolation driver default The default TransactionIsolation state of connections created by this pool. One of the following: (see javadoc <http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Connection.html#field_summary>) * NONE * READ_COMMITTED * READ_UNCOMMITTED * REPEATABLE_READ * SERIALIZABLE defaultCatalog The default catalog of connections created by this pool. Maybe unrelated but in C3P (http://www.mchange.com/projects/c3p0/index.html#configuring_unresolved) there are some interesting setting to deal with connection closing leaks like: * autoCommitOnClose <http://www.mchange.com/projects/c3p0/index.html#autoCommitOnClose> * forceIgnoreUnresolvedTransactions <http://www.mchange.com/projects/c3p0/index.html#forceIgnoreUnresolvedTransactions> Regards, Dario. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
