[
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.
