Did you try last suggested workaround from http://jira.springsource.org/browse/SPR-8870 "If you remove the connection validation from the pool configuration" ?
in $ARCHIVA_BASE/conf/jetty.xml inside <New class="org.apache.tomcat.jdbc.pool.DataSource"> change/add <Set name="testOnBorrow">false</Set> <Set name="testOnReturn">false</Set> 2013/1/18 Leitch, Oblio <oblio.lei...@state.vt.us>: > 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 > -- Olivier Lamy Talend: http://coders.talend.com http://twitter.com/olamy | http://linkedin.com/in/olamy