archiva-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Leitch, Oblio" <Oblio.Lei...@state.vt.us>
Subject RE: assistance getting Archiva standalone to use Postgres
Date Fri, 18 Jan 2013 19:30:08 GMT
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:olamy@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


Mime
View raw message