[rules-users] Expected Transaction Rollback Behavior of Drools 6

Alexander Herwix alex at herwix.com
Thu Sep 5 15:08:53 EDT 2013


Hey guys,

I have a question regarding the expected transaction rollback behavior of drools 6 in an JTA-Environment. It looks like I have successfully configured drools within my app, however when I create a KieSession within a Transaction and roll it back, there is still some data persisted to the DB. 

e.g. session info (the last record should be rolled back)

ID	LAST_MODIFICATION_DATE	RULES_BYTE_ARRAY  	START_DATE	OPTLOCK
1	2013-09-05 20:22:48.363	aced000577500a060805100418005246080010001a3c18002000320608011000180042231a190a044d41494e10001801200028ffffffffffffffffff01400022060a044d41494e52090a0744454641554c5422026800	2013-09-05 20:22:47.485	1
2	2013-09-05 20:22:48.624	aced000577500a060805100418005246080010001a3c18002000320608011000180042231a190a044d41494e10001801200028ffffffffffffffffff01400022060a044d41494e52090a0744454641554c5422026800	2013-09-05 20:22:48.615	1
3	2013-09-05 20:24:18.346	aced000577500a060805100418005246080010001a3c18002000320608011000180042231a190a044d41494e10001801200028ffffffffffffffffff01400022060a044d41494e52090a0744454641554c5422026800	2013-09-05 20:24:18.334	1
4	2013-09-05 20:26:31.309	aced000577500a060805100418005246080010001a3c18002000320608011000180042231a190a044d41494e10001801200028ffffffffffffffffff01400022060a044d41494e52090a0744454641554c5422026800	2013-09-05 20:26:31.301	1
5	2013-09-05 20:26:31.347	aced000577500a060805100418005246080010001a3c18002000320608011000180042231a190a044d41494e10001801200028ffffffffffffffffff01400022060a044d41494e52090a0744454641554c5422026800	2013-09-05 20:26:31.337	1
6	null	aced0005775e0a060805100418005254080010001a4a18002000320608011000180042231a190a044d41494e10001801200028ffffffffffffffffff01400022060a044d41494e52090a0744454641554c545a0c0a0a0805320608001000180122026800	2013-09-05 20:36:01.164	0

similar for process instances started in those sessions

INSTANCE_ID	LAST_MODIFICATION_DATE	LAST_READ_DATE	PROCESS_ID  	PROCESS_INSTANCE_BYTE_ARRAY  	START_DATE	STATE	OPTLOCK
1	2013-09-05 20:22:48.45	2013-09-05 20:22:47.91	com.sample.ruleflow	aced00057a0000015f000852756c65466c6f770a060805100418004ab401080012486f72672e64726f6f6c732e636f72652e6d61727368616c6c696e672e696d706c2e53657269616c697a61626c65506c616365686f6c6465725265736f6c76657253747261746567791a66aced0005737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a6578700000000577040000000a7400057465737433740005746573743274000a536f6d65537472696e67740004746573747400057465737434785293010a0852756c65466c6f7710011a13636f6d2e73616d706c652e72756c65666c6f77200128033a0e08021004220608011a0208012801420b0a016610001a0400000000420b0a016d10001a0400000001420b0a017810001a0400000002420b0a017910001a0400000003420b0a017a10001a040000000460006a01316a013572050a0131100172050a0134100172050a01351001	2013-09-05 20:22:47.901	1	1
2	2013-09-05 20:22:48.626	2013-09-05 20:22:48.623	com.sample.ruleflow	aced00057a0000015f000852756c65466c6f770a060805100418004ab401080012486f72672e64726f6f6c732e636f72652e6d61727368616c6c696e672e696d706c2e53657269616c697a61626c65506c616365686f6c6465725265736f6c76657253747261746567791a66aced0005737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a6578700000000577040000000a7400057465737433740005746573743274000a536f6d65537472696e67740004746573747400057465737434785293010a0852756c65466c6f7710021a13636f6d2e73616d706c652e72756c65666c6f77200128033a0e08021004220608011a0208022801420b0a016610001a0400000000420b0a016d10001a0400000001420b0a017810001a0400000002420b0a017910001a0400000003420b0a017a10001a040000000460006a01316a013572050a0131100172050a0134100172050a01351001	2013-09-05 20:22:48.622	1	1
3	2013-09-05 20:24:18.348	2013-09-05 20:24:18.344	com.sample.ruleflow	aced00057a0000015f000852756c65466c6f770a060805100418004ab401080012486f72672e64726f6f6c732e636f72652e6d61727368616c6c696e672e696d706c2e53657269616c697a61626c65506c616365686f6c6465725265736f6c76657253747261746567791a66aced0005737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a6578700000000577040000000a7400057465737433740005746573743274000a536f6d65537472696e67740004746573747400057465737434785293010a0852756c65466c6f7710031a13636f6d2e73616d706c652e72756c65666c6f77200128033a0e08021004220608011a0208032801420b0a016610001a0400000000420b0a016d10001a0400000001420b0a017810001a0400000002420b0a017910001a0400000003420b0a017a10001a040000000460006a01316a013572050a0131100172050a0134100172050a01351001	2013-09-05 20:24:18.343	1	1
4	2013-09-05 20:26:31.31	2013-09-05 20:26:31.308	com.sample.ruleflow	aced00057a0000015f000852756c65466c6f770a060805100418004ab401080012486f72672e64726f6f6c732e636f72652e6d61727368616c6c696e672e696d706c2e53657269616c697a61626c65506c616365686f6c6465725265736f6c76657253747261746567791a66aced0005737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a6578700000000577040000000a7400057465737433740005746573743274000a536f6d65537472696e67740004746573747400057465737434785293010a0852756c65466c6f7710041a13636f6d2e73616d706c652e72756c65666c6f77200128033a0e08021004220608011a0208042801420b0a016610001a0400000000420b0a016d10001a0400000001420b0a017810001a0400000002420b0a017910001a0400000003420b0a017a10001a040000000460006a01316a013572050a0131100172050a0134100172050a01351001	2013-09-05 20:26:31.307	1	1
5	2013-09-05 20:26:31.348	2013-09-05 20:26:31.346	com.sample.ruleflow	aced00057a0000015f000852756c65466c6f770a060805100418004ab401080012486f72672e64726f6f6c732e636f72652e6d61727368616c6c696e672e696d706c2e53657269616c697a61626c65506c616365686f6c6465725265736f6c76657253747261746567791a66aced0005737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a6578700000000577040000000a7400057465737433740005746573743274000a536f6d65537472696e67740004746573747400057465737434785293010a0852756c65466c6f7710051a13636f6d2e73616d706c652e72756c65666c6f77200128033a0e08021004220608011a0208052801420b0a016610001a0400000000420b0a016d10001a0400000001420b0a017810001a0400000002420b0a017910001a0400000003420b0a017a10001a040000000460006a01316a013572050a0131100172050a0134100172050a01351001	2013-09-05 20:26:31.345	1	1
6	null	null	com.sample.ruleflow	null	2013-09-05 20:36:01.168	0	0

Does anyone know if this the expected behavior of drools or if this might indicate some problems with my configuration? There are no errors thrown. 

Thanks for any help in advance :)

Cheers, Alex
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20130905/66069f19/attachment-0001.html 


More information about the rules-users mailing list