Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-users] Eclipselink 1.0.1. transaction bug (?) 
Thx for the follow up.

As it turns out replacing the PL/SQL stored procedure call by a 'plain'
JDBC insert statement resolves the issue. The stored proc doesn't issue
a commit. It don't think it is related to the fact that the PL/SQL proc
is now 'owned' by the schema referenced in the persistence unit (right?)
- the actual procedure is granted from another user with execute rights.


On Wed, 2008-10-29 at 06:47 -0700, James Sutherland wrote:
> As your output shows the JDBC connections autocommit is false throughout, so
> EclipseLink does not appear to be committing the transaction.  It would seem
> your stored procedure is triggering the commit, does it call commit?
> 
> Try executing the same through JDBC and see if the same behavior occurs.
> 
> 
> 
> Jan Vissers wrote:
> > 
> > See for initial case:
> > http://dev.eclipse.org/mhonarc/lists/eclipselink-users/msg01394.html
> > 
> > I've written a JUnit test that shows the following:
> > 
> > Using the setup below:
> > 
> > -begintransaction (early)
> > stored proc call 1 -> no records committed
> > stored proc call 2 -> record as initiated by call 1 committed
> > stored proc call 3 -> record as initiated by call 2 committed
> > -committransaction -> record as initiated by call 3 committed
> > 
> > What I'm wondering now is whether this is intended behavior, or a bug?
> > 
> > Here's the 'FINEST' output:
> > 
> > [EL Finest]: 2008.10.29
> > 07:40:23.905--ServerSession(1769630074)--Thread(Thread[main,5,main])--End
> > deploying Persistence Unit guidecontrol-web; state Deployed; factoryCount
> > 1
> > [EL Finer]: 2008.10.29
> > 07:40:26.139--ServerSession(1769630074)--Thread(Thread[main,5,main])--client
> > acquired
> > [EL Finer]: 2008.10.29
> > 07:40:26.154--ClientSession(1656840897)--Connection(1020345553)--Thread(Thread[main,5,main])--begin
> > transaction
> > 2008-10-29 07:40:33,204 main DEBUG dao.jpa.ImageJPADAO  - Connection
> > information: 1020345553 - autocommit(false)
> > [EL Finest]: 2008.10.29
> > 07:40:38.270--UnitOfWork(1488476344)--Thread(Thread[main,5,main])--Execute
> > query ValueReadQuery()
> > [EL Fine]: 2008.10.29
> > 07:40:38.331--ClientSession(1656840897)--Connection(1020345553)--Thread(Thread[main,5,main])--BEGIN
> > ? := cil_api.create_image(p_image_id=>?, p_image_type_id=>?,
> > p_collection_id=>?, p_description=>?, p_extension_high_res=>?,
> > p_extension_low_res_small=>?, p_extension_low_res_large=>?,
> > p_extension_low_res_medium=>?); END;
> > 	bind => [=> function_result, null, 201, 10000, GDPD_KLDOD, jpg, jpg, jpg,
> > jpg]
> > 2008-10-29 07:40:50,277 main DEBUG dao.jpa.ImageJPADAO  - Connection
> > information: 1020345553 - autocommit(false)
> > [EL Finest]: 2008.10.29
> > 07:41:02.053--UnitOfWork(1488476344)--Thread(Thread[main,5,main])--Execute
> > query ValueReadQuery()
> > [EL Fine]: 2008.10.29
> > 07:41:02.054--ClientSession(1656840897)--Connection(1020345553)--Thread(Thread[main,5,main])--BEGIN
> > ? := cil_api.create_image(p_image_id=>?, p_image_type_id=>?,
> > p_collection_id=>?, p_description=>?, p_extension_high_res=>?,
> > p_extension_low_res_small=>?, p_extension_low_res_large=>?,
> > p_extension_low_res_medium=>?); END;
> > 	bind => [=> function_result, null, 201, 10000, GDPD_JANNEMAN, jpg, jpg,
> > jpg, jpg]
> > 2008-10-29 07:41:09,512 main DEBUG dao.jpa.ImageJPADAO  - Connection
> > information: 1020345553 - autocommit(false)
> > [EL Finest]: 2008.10.29
> > 07:41:16.028--UnitOfWork(1488476344)--Thread(Thread[main,5,main])--Execute
> > query ValueReadQuery()
> > [EL Fine]: 2008.10.29
> > 07:41:16.030--ClientSession(1656840897)--Connection(1020345553)--Thread(Thread[main,5,main])--BEGIN
> > ? := cil_api.create_image(p_image_id=>?, p_image_type_id=>?,
> > p_collection_id=>?, p_description=>?, p_extension_high_res=>?,
> > p_extension_low_res_small=>?, p_extension_low_res_large=>?,
> > p_extension_low_res_medium=>?); END;
> > 	bind => [=> function_result, null, 201, 10000, PIETERMAN, jpg, jpg, jpg,
> > jpg]
> > [EL Finer]: 2008.10.29
> > 07:41:34.268--UnitOfWork(1488476344)--Thread(Thread[main,5,main])--begin
> > unit of work commit
> > [EL Finer]: 2008.10.29
> > 07:41:34.284--ClientSession(1656840897)--Connection(1020345553)--Thread(Thread[main,5,main])--commit
> > transaction
> > [EL Finer]: 2008.10.29
> > 07:41:34.299--UnitOfWork(1488476344)--Thread(Thread[main,5,main])--end
> > unit of work commit
> > [EL Finer]: 2008.10.29
> > 07:41:34.299--UnitOfWork(1488476344)--Thread(Thread[main,5,main])--resume
> > unit of work
> > 
> > 
> > -J.
> > 
> 
> 
> -----
> ---
> http://wiki.eclipse.org/User:James.sutherland.oracle.com James Sutherland 
> http://www.eclipse.org/eclipselink/
>  EclipseLink ,  http://www.oracle.com/technology/products/ias/toplink/
> TopLink 
> Wiki:  http://wiki.eclipse.org/EclipseLink EclipseLink , 
> http://wiki.oracle.com/page/TopLink TopLink 
> Forums:  http://forums.oracle.com/forums/forum.jspa?forumID=48 TopLink , 
> http://www.nabble.com/EclipseLink-f26430.html EclipseLink 
> Book:  http://en.wikibooks.org/wiki/Java_Persistence Java Persistence

Back to the top