Ok, I tried that, but I got: java.lang.NumberFormatException: For input string: "READ_COMMITTED"
So I used the Int value 2 from http://docs.oracle.com/javase/6/docs/api/constant-values.html#java.sql.Connection.TRANSACTION_NONE But, it's still causing the same error: org.postgresql.util.PSQLException: Cannot change transaction isolation level in the middle of a transaction. After more searching, I found that this could be an issue with Spring: http://jira.springsource.org/browse/SPR-8870 One person seems to think that it's fixed (http://youtrack.jetbrains.com/issue/TW-18517); I've asked for their reference. Thoughts? -----Original Message----- From: Olivier Lamy [mailto:ol...@apache.org] Sent: Friday, January 18, 2013 11:05 AM To: users@archiva.apache.org Subject: Re: assistance getting Archiva standalone to use Postgres you can try configuring defaultTransactionIsolation attribute for jdbc-pool in conf/jetty.xml <New id="users" class="org.eclipse.jetty.plus.jndi.Resource"> <Arg>jdbc/users</Arg> <Arg> <New class="org.apache.tomcat.jdbc.pool.DataSource"> ... <Set name="defaultTransactionIsolation">READ_COMMITTED </Set> ... </New> </Arg> </New> One of the following value: NONE READ_COMMITTED READ_UNCOMMITTED REPEATABLE_READ SERIALIZABLE Try with READ_COMMITTED see doc here: http://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html
