Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » DML without transaction
DML without transaction [message #1059035] Thu, 16 May 2013 07:10 Go to next message
Daniel Elstner is currently offline Daniel Elstner
Messages: 2
Registered: May 2013
Junior Member
Hi,

I try to set up a DML statement on our persistence unit.
The persistence unit throws an exception:
javax.persistence.TransactionRequiredException:
Exception Description: No transaction is currently active

The problem is, that the database behind the persistence unit
does not support transactions. If i start a transaction and
commit/rollback it, even with a select statement, nothing happens.

I wonder if there is a way to work around this.

Database we use is an old informix database.

Kind regards and thanks in advance,
Daniel

Report message to a moderator

Re: DML without transaction [message #1060024 is a reply to message #1059035] Wed, 22 May 2013 10:55 Go to previous messageGo to next message
James Sutherland is currently offline James Sutherland
Messages: 1844
Registered: July 2009
Senior Member
Does you database throw an error if you try to start a transaction, or just not support rollback?

James : Wiki : Book : Blog

Report message to a moderator

Re: DML without transaction [message #1060582 is a reply to message #1059035] Mon, 27 May 2013 03:35 Go to previous message
Daniel Elstner is currently offline Daniel Elstner
Messages: 2
Registered: May 2013
Junior Member
It throws an error...

Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.0.1 (Build 20080905)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Transactions not supported
Error Code: -79744


Rollback is not needed. Without transaction I can execute select statements
but I can't execute DML.

If i try to execute DML without transaction it throws the following exception:
javax.persistence.TransactionRequiredException: 
Exception Description: No transaction is currently active

Report message to a moderator

Previous Topic:EclipseLink DBWS with JPQL
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 27 22:55:44 EDT 2013

Powered by FUDForum. Page generated in 0.01492 seconds