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.lei...@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:ol...@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.lei...@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:ol...@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.lei...@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:ol...@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
