archiva-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Olivier Lamy <ol...@apache.org>
Subject Re: assistance getting Archiva standalone to use Postgres
Date Fri, 18 Jan 2013 16:05:07 GMT
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

2013/1/15 Leitch, Oblio <Oblio.Leitch@state.vt.us>:
> Yep.  I installed Firebug so I can see what's going on.  I get this message:
>
> Error 500 org.apache.cxf.interceptor.Fault: Unable to get object 'org.apache.archiva.redback.users.jdo.JdoUser',
id 'admin', fetch-group 'null' from jdo store.
>
> Which, I think, is more specifically this:
>
> Caused by: javax.jdo.JDODataStoreException: Transaction failed to start
> NestedThrowables:
> org.postgresql.util.PSQLException: Cannot change transaction isolation level in the middle
of a transaction.
>         at org.jpox.store.rdbms.RDBMSNonmanagedTransaction.begin(RDBMSNonmanagedTransaction.java:344)
>         at org.apache.archiva.redback.components.jdo.PlexusJdoUtils.getObjectById(PlexusJdoUtils.java:238)
>         ... 53 more
> Caused by: org.postgresql.util.PSQLException: Cannot change transaction isolation level
in the middle of a transaction.
>         at org.postgresql.jdbc2.AbstractJdbc2Connection.setTransactionIsolation(AbstractJdbc2Connection.java:929)
>
> -----Original Message-----
> From: Olivier Lamy [mailto:olamy@apache.org]
> Sent: Friday, January 11, 2013 3:17 PM
> To: users@archiva.apache.org
> Subject: Re: assistance getting Archiva standalone to use Postgres
>
> even with admin user ?
> You can use this tool http://squirrel-sql.sourceforge.net to have a look at the database
content.
>
> 2013/1/11 Leitch, Oblio <Oblio.Leitch@state.vt.us>:
>> I'm using the 1.4 js version.  I can't see anything in the logs which indicate a
problem, and the ui seems to complete just fine, except for login.
>>
>>
>> -----Original Message-----
>> From: Olivier Lamy [mailto:olamy@apache.org]
>> Sent: Thursday, January 10, 2013 3:37 PM
>> To: users@archiva.apache.org
>> Subject: Re: assistance getting Archiva standalone to use Postgres
>>
>> which archiva version are you using ?
>>
>> nothing in logs ? what the ui says ?
>>
>> 2013/1/10 Leitch, Oblio <Oblio.Leitch@state.vt.us>:
>>> Ok, this worked for me; it's now running, there are tables in the database, and
things look ok.  However, I can't seem to login, or register new users, or any of that.  What's
more, there doesn't seem to be anything in the logs that indicate there are any errors.  How
do I figure out what's going on?
>>>
>>> -----Original Message-----
>>> From: Olivier Lamy [mailto:olamy@apache.org]
>>> Sent: Monday, December 31, 2012 8:23 AM
>>> To: users@archiva.apache.org
>>> Subject: Re: assistance getting Archiva standalone to use Postgres
>>>
>>> Oh I missed something.
>>> Have a look at the file conf/wrapper.conf You will see some lines
>>> wrapper.java.classpath.24=%REPO_DIR%/ant-launcher-1.8.3.jar
>>> ...
>>> Add one with
>>> wrapper.java.classpath.x=%REPO_DIR%/postgresql-9.2-1002.jdbc4.jar
>>> x will be last x + 1
>>
>>
>>
>> --
>> Olivier Lamy
>> Talend: http://coders.talend.com
>> http://twitter.com/olamy | http://linkedin.com/in/olamy
>
>
>
> --
> Olivier Lamy
> Talend: http://coders.talend.com
> http://twitter.com/olamy | http://linkedin.com/in/olamy



-- 
Olivier Lamy
Talend: http://coders.talend.com
http://twitter.com/olamy | http://linkedin.com/in/olamy

Mime
View raw message