openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tim McConnell (JIRA)" <j...@apache.org>
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

    [ https://issues.apache.org/jira/browse/OPENJPA-903?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12676499#action_12676499
] 

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,
etc...

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: https://issues.apache.org/jira/browse/OPENJPA-903
>             Project: OpenJPA
>          Issue Type: Sub-task
>          Components: jdbc
>    Affects Versions: 2.0.0
>         Environment: Windows 2003 Server, maven 2.0.9, Java 1.5.0.15, 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.


Mime
View raw message