openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tim McConnell (JIRA)" <>
Subject [jira] Commented: (OPENJPA-903) org.apache.openjpa.persistence.exception.TestException hangs when run using PostgreSQL 8.3 database
Date Wed, 25 Feb 2009 04:21:01 GMT


Tim McConnell commented on OPENJPA-903:

Ok, I finally see what's happening here. For this testcase to work across multiple databases,
two things have to be configured correctly for each database. They are:

1. A locking timeout has to be available and set for each database (or database server). For
example, the default setting for Derby is derby.locks.waitTimeout=60 (i.e., 60 seconds), which
is at the server level. For DB2, it can be set at a database level, but the default is LOCKTIMEOUT=-1,
which disables it. Likewise for PostgreSQL the setting is at a server, not database, granularity,

2. The sql-error-state-codes.xml file has to be properly populated with the appropriate lock
and optimistic key values that correlate the database-dependent SQL codes and states to an
optimistic lock. 

I'll provide another patch tomorrow. Thanks

> org.apache.openjpa.persistence.exception.TestException hangs when run using PostgreSQL
8.3 database 
> ----------------------------------------------------------------------------------------------------
>                 Key: OPENJPA-903
>                 URL:
>             Project: OpenJPA
>          Issue Type: Sub-task
>          Components: jdbc
>    Affects Versions: 2.0.0
>         Environment: Windows 2003 Server, maven 2.0.9, Java, PostgreSQL 8.3.5
>            Reporter: Tim McConnell
>            Assignee: Tim McConnell
>         Attachments: OPENJPA-903.patch
> Seems to be hanging in the testThrowsOptimisticException() testcase -- see below:
> -------------------------------------------------------
>  T E S T S
> -------------------------------------------------------
> Running org.apache.openjpa.persistence.exception.TestException
> 31  test  INFO   [main] openjpa.Runtime - Starting OpenJPA 2.0.0-SNAPSHOT
> 484  test  INFO   [main] openjpa.jdbc.JDBC - Using dictionary class "org.apache.openjpa.jdbc.sql.PostgresDictionary"
(PostgreSQL 8.3.5 ,PostgreSQL Native Driver PostgreSQL 8.3 JDBC3 with SSL (build 603)).

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message