[
https://issues.apache.org/jira/browse/OPENJPA-969?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12680495#action_12680495
]
Michael Dick commented on OPENJPA-969:
--------------------------------------
Hi Fay, which application server are you using when you see the hang?
The manual may be out of date, the managed runtime classes do a lot of work to
enable the application to use a single datasource (suspending the current
transaction if needed).
> In the J2ee environment, when the sequence table is used for identity, if
> only one datasource is created, the application hangs.
> ---------------------------------------------------------------------------------------------------------------------------------
>
> Key: OPENJPA-969
> URL: https://issues.apache.org/jira/browse/OPENJPA-969
> Project: OpenJPA
> Issue Type: Bug
> Components: jdbc
> Affects Versions: 2.0.0
> Reporter: Fay Wang
> Assignee: Fay Wang
>
> The openjpa manual states clearly that a second unmanaged DataSource is
> required for updating sequence table (page 205: 4.2.1. Managed and XA
> DataSources):
> "When using a managed DataSource, you should also configure a second
> unmanaged DataSource that OpenJPA can use to perform tasks that are
> independent of the global transaction. The most common of these tasks is
> updating the sequence table OpenJPA uses to generate unique primary key
> values for your datastore identity objects. Configure the second DataSource
> using the non-jta-data-source persistence.xml element, or OpenJPA's various
> "2" connection properties, such as openjpa.ConnectionFactory2Name or
> openjpa.Connection2DriverName. These properties are outlined in
> Chapter 2, Configuration [161]."
> Openjpa, however, does not this rule when Sequence table is involved. As a
> result, the application hangs when only one datasource is configured. This is
> not very user-friendly. An error message should be thrown when this situation
> is detected.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
