Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Oracle UCP autoCommit property - clarification #1202

Closed
mattjlewis opened this issue Dec 11, 2019 · 3 comments
Closed

Oracle UCP autoCommit property - clarification #1202

mattjlewis opened this issue Dec 11, 2019 · 3 comments
Assignees
Labels
bug Something isn't working P1

Comments

@mattjlewis
Copy link

I am using Helidon 1.4.0 and am having issues with transaction rollbacks when updating multiple entities in one transaction (and have made note of the issue 1146 - I am yet to test with 2.0-SNAPSHOT).
While investigating this, I noticed that the JDBC connection property autoCommit is set to true. Should this be false? I cannot see a way to change this property via configuration properties as I think it can only be configured via setConnectionProperties(Properties).

@m0mus m0mus added help wanted Extra attention is needed question Further information is requested and removed help wanted Extra attention is needed labels Dec 12, 2019
@ljnelson
Copy link
Member

@mattjlewis and I have been in extensive conversations around this. Suffice it to say I think there is a real issue involved, but not at the JPA level. That is, Helidon's (2.0-SNAPSHOT) JPA support is OK, but the enlistment of even single-database resources into a JTA transaction is problematic. #1146 definitely addresses the JPA issues related to this, but not the underlying how-do-I-get-a-javax.sql.DataSource-as-used-by-Hibernate-or-EclipseLink-to-participate-properly-in-a-JTA-transaction bits.

@ljnelson ljnelson added P1 bug Something isn't working and removed question Further information is requested labels Dec 13, 2019
@ljnelson
Copy link
Member

See #1316.

@ljnelson
Copy link
Member

Fixed with #1376.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working P1
Projects
Archived in project
Development

No branches or pull requests

3 participants