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 (?) 
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 
-- 
View this message in context: http://www.nabble.com/Eclipselink-1.0.1.-transaction-bug-%28-%29-tp20221728p20227478.html
Sent from the EclipseLink - Users mailing list archive at Nabble.com.

Back to the top