<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hey guys,<div><br></div><div>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. </div><div><br></div><div>e.g. session info (the last record should be rolled back)</div><div><br></div><div></div><div><div><table cellspacing="0" cellpadding="0" style="background-color: rgb(255, 255, 255); border-collapse: collapse; border: 1px solid rgb(172, 168, 153); color: rgb(0, 0, 0); font-family: Arial, sans-serif; font-size: 12px; line-height: 16px; position: static; z-index: auto; "><tbody><tr><th style="text-align: left; background-color: rgb(236, 233, 216); padding: 2px; border: 1px solid rgb(172, 168, 153); "><a href="http://localhost:8080/bpm/dbconsole/query.do?jsessionid=d42b410097a59e3824369f06db99e2c4#" class="sortHeader" style="text-decoration: none; color: rgb(0, 0, 255);">ID<span class="sortArrow"> </span></a></th><th style="text-align: left; background-color: rgb(236, 233, 216); padding: 2px; border: 1px solid rgb(172, 168, 153); "><a href="http://localhost:8080/bpm/dbconsole/query.do?jsessionid=d42b410097a59e3824369f06db99e2c4#" class="sortHeader" style="text-decoration: none; color: rgb(0, 0, 255);">LAST_MODIFICATION_DATE<span class="sortArrow"> </span></a></th><th style="text-align: left; background-color: rgb(236, 233, 216); padding: 2px; border: 1px solid rgb(172, 168, 153); "><a href="http://localhost:8080/bpm/dbconsole/query.do?jsessionid=d42b410097a59e3824369f06db99e2c4#" class="sortHeader" style="text-decoration: none; color: rgb(0, 0, 255);">RULES_BYTE_ARRAY<span class="sortArrow"> </span></a></th><th style="text-align: left; background-color: rgb(236, 233, 216); padding: 2px; border: 1px solid rgb(172, 168, 153); "><a href="http://localhost:8080/bpm/dbconsole/query.do?jsessionid=d42b410097a59e3824369f06db99e2c4#" class="sortHeader" style="text-decoration: none; color: rgb(0, 0, 255);">START_DATE<span class="sortArrow"> </span></a></th><th style="text-align: left; background-color: rgb(236, 233, 216); padding: 2px; border: 1px solid rgb(172, 168, 153); "><a href="http://localhost:8080/bpm/dbconsole/query.do?jsessionid=d42b410097a59e3824369f06db99e2c4#" class="sortHeader" style="text-decoration: none; color: rgb(0, 0, 255);">OPTLOCK<span class="sortArrow"> </span></a></th></tr><tr><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">1</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:22:48.363</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">aced000577500a060805100418005246080010001a3c18002000320608011000180042231a190a044d41494e10001801200028ffffffffffffffffff01400022060a044d41494e52090a0744454641554c5422026800</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:22:47.485</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">1</td></tr><tr><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:22:48.624</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">aced000577500a060805100418005246080010001a3c18002000320608011000180042231a190a044d41494e10001801200028ffffffffffffffffff01400022060a044d41494e52090a0744454641554c5422026800</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:22:48.615</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">1</td></tr><tr><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">3</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:24:18.346</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">aced000577500a060805100418005246080010001a3c18002000320608011000180042231a190a044d41494e10001801200028ffffffffffffffffff01400022060a044d41494e52090a0744454641554c5422026800</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:24:18.334</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">1</td></tr><tr><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">4</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:26:31.309</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">aced000577500a060805100418005246080010001a3c18002000320608011000180042231a190a044d41494e10001801200028ffffffffffffffffff01400022060a044d41494e52090a0744454641554c5422026800</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:26:31.301</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">1</td></tr><tr><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">5</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:26:31.347</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">aced000577500a060805100418005246080010001a3c18002000320608011000180042231a190a044d41494e10001801200028ffffffffffffffffff01400022060a044d41494e52090a0744454641554c5422026800</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:26:31.337</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">1</td></tr><tr><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">6</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); "><i>null</i></td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">aced0005775e0a060805100418005254080010001a4a18002000320608011000180042231a190a044d41494e10001801200028ffffffffffffffffff01400022060a044d41494e52090a0744454641554c545a0c0a0a0805320608001000180122026800</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:36:01.164</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">0</td></tr></tbody></table><div><br></div></div></div><div>similar for process instances started in those sessions</div><div><br></div><div><table cellspacing="0" cellpadding="0" style="background-color: rgb(255, 255, 255); border-collapse: collapse; border: 1px solid rgb(172, 168, 153); color: rgb(0, 0, 0); font-family: Arial, sans-serif; font-size: 12px; line-height: 16px; "><tbody><tr><th style="text-align: left; background-color: rgb(236, 233, 216); padding: 2px; border: 1px solid rgb(172, 168, 153); "><a href="http://localhost:8080/bpm/dbconsole/query.do?jsessionid=d42b410097a59e3824369f06db99e2c4#" class="sortHeader" style="text-decoration: none; color: rgb(0, 0, 255);">INSTANCE_ID<span class="sortArrow"> </span></a></th><th style="text-align: left; background-color: rgb(236, 233, 216); padding: 2px; border: 1px solid rgb(172, 168, 153); "><a href="http://localhost:8080/bpm/dbconsole/query.do?jsessionid=d42b410097a59e3824369f06db99e2c4#" class="sortHeader" style="text-decoration: none; color: rgb(0, 0, 255);">LAST_MODIFICATION_DATE<span class="sortArrow"> </span></a></th><th style="text-align: left; background-color: rgb(236, 233, 216); padding: 2px; border: 1px solid rgb(172, 168, 153); "><a href="http://localhost:8080/bpm/dbconsole/query.do?jsessionid=d42b410097a59e3824369f06db99e2c4#" class="sortHeader" style="text-decoration: none; color: rgb(0, 0, 255);">LAST_READ_DATE<span class="sortArrow"> </span></a></th><th style="text-align: left; background-color: rgb(236, 233, 216); padding: 2px; border: 1px solid rgb(172, 168, 153); "><a href="http://localhost:8080/bpm/dbconsole/query.do?jsessionid=d42b410097a59e3824369f06db99e2c4#" class="sortHeader" style="text-decoration: none; color: rgb(0, 0, 255);">PROCESS_ID<span class="sortArrow"> </span></a></th><th style="text-align: left; background-color: rgb(236, 233, 216); padding: 2px; border: 1px solid rgb(172, 168, 153); "><a href="http://localhost:8080/bpm/dbconsole/query.do?jsessionid=d42b410097a59e3824369f06db99e2c4#" class="sortHeader" style="text-decoration: none; color: rgb(0, 0, 255);">PROCESS_INSTANCE_BYTE_ARRAY<span class="sortArrow"> </span></a></th><th style="text-align: left; background-color: rgb(236, 233, 216); padding: 2px; border: 1px solid rgb(172, 168, 153); "><a href="http://localhost:8080/bpm/dbconsole/query.do?jsessionid=d42b410097a59e3824369f06db99e2c4#" class="sortHeader" style="text-decoration: none; color: rgb(0, 0, 255);">START_DATE<span class="sortArrow"> </span></a></th><th style="text-align: left; background-color: rgb(236, 233, 216); padding: 2px; border: 1px solid rgb(172, 168, 153); "><a href="http://localhost:8080/bpm/dbconsole/query.do?jsessionid=d42b410097a59e3824369f06db99e2c4#" class="sortHeader" style="text-decoration: none; color: rgb(0, 0, 255);">STATE<span class="sortArrow"> </span></a></th><th style="text-align: left; background-color: rgb(236, 233, 216); padding: 2px; border: 1px solid rgb(172, 168, 153); "><a href="http://localhost:8080/bpm/dbconsole/query.do?jsessionid=d42b410097a59e3824369f06db99e2c4#" class="sortHeader" style="text-decoration: none; color: rgb(0, 0, 255);">OPTLOCK<span class="sortArrow"> </span></a></th></tr><tr><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">1</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:22:48.45</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:22:47.91</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">com.sample.ruleflow</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">aced00057a0000015f000852756c65466c6f770a060805100418004ab401080012486f72672e64726f6f6c732e636f72652e6d61727368616c6c696e672e696d706c2e53657269616c697a61626c65506c616365686f6c6465725265736f6c76657253747261746567791a66aced0005737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a6578700000000577040000000a7400057465737433740005746573743274000a536f6d65537472696e67740004746573747400057465737434785293010a0852756c65466c6f7710011a13636f6d2e73616d706c652e72756c65666c6f77200128033a0e08021004220608011a0208012801420b0a016610001a0400000000420b0a016d10001a0400000001420b0a017810001a0400000002420b0a017910001a0400000003420b0a017a10001a040000000460006a01316a013572050a0131100172050a0134100172050a01351001</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:22:47.901</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">1</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">1</td></tr><tr><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:22:48.626</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:22:48.623</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">com.sample.ruleflow</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">aced00057a0000015f000852756c65466c6f770a060805100418004ab401080012486f72672e64726f6f6c732e636f72652e6d61727368616c6c696e672e696d706c2e53657269616c697a61626c65506c616365686f6c6465725265736f6c76657253747261746567791a66aced0005737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a6578700000000577040000000a7400057465737433740005746573743274000a536f6d65537472696e67740004746573747400057465737434785293010a0852756c65466c6f7710021a13636f6d2e73616d706c652e72756c65666c6f77200128033a0e08021004220608011a0208022801420b0a016610001a0400000000420b0a016d10001a0400000001420b0a017810001a0400000002420b0a017910001a0400000003420b0a017a10001a040000000460006a01316a013572050a0131100172050a0134100172050a01351001</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:22:48.622</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">1</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">1</td></tr><tr><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">3</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:24:18.348</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:24:18.344</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">com.sample.ruleflow</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">aced00057a0000015f000852756c65466c6f770a060805100418004ab401080012486f72672e64726f6f6c732e636f72652e6d61727368616c6c696e672e696d706c2e53657269616c697a61626c65506c616365686f6c6465725265736f6c76657253747261746567791a66aced0005737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a6578700000000577040000000a7400057465737433740005746573743274000a536f6d65537472696e67740004746573747400057465737434785293010a0852756c65466c6f7710031a13636f6d2e73616d706c652e72756c65666c6f77200128033a0e08021004220608011a0208032801420b0a016610001a0400000000420b0a016d10001a0400000001420b0a017810001a0400000002420b0a017910001a0400000003420b0a017a10001a040000000460006a01316a013572050a0131100172050a0134100172050a01351001</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:24:18.343</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">1</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">1</td></tr><tr><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">4</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:26:31.31</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:26:31.308</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">com.sample.ruleflow</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">aced00057a0000015f000852756c65466c6f770a060805100418004ab401080012486f72672e64726f6f6c732e636f72652e6d61727368616c6c696e672e696d706c2e53657269616c697a61626c65506c616365686f6c6465725265736f6c76657253747261746567791a66aced0005737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a6578700000000577040000000a7400057465737433740005746573743274000a536f6d65537472696e67740004746573747400057465737434785293010a0852756c65466c6f7710041a13636f6d2e73616d706c652e72756c65666c6f77200128033a0e08021004220608011a0208042801420b0a016610001a0400000000420b0a016d10001a0400000001420b0a017810001a0400000002420b0a017910001a0400000003420b0a017a10001a040000000460006a01316a013572050a0131100172050a0134100172050a01351001</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:26:31.307</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">1</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">1</td></tr><tr><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">5</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:26:31.348</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:26:31.346</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">com.sample.ruleflow</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">aced00057a0000015f000852756c65466c6f770a060805100418004ab401080012486f72672e64726f6f6c732e636f72652e6d61727368616c6c696e672e696d706c2e53657269616c697a61626c65506c616365686f6c6465725265736f6c76657253747261746567791a66aced0005737200136a6176612e7574696c2e41727261794c6973747881d21d99c7619d03000149000473697a6578700000000577040000000a7400057465737433740005746573743274000a536f6d65537472696e67740004746573747400057465737434785293010a0852756c65466c6f7710051a13636f6d2e73616d706c652e72756c65666c6f77200128033a0e08021004220608011a0208052801420b0a016610001a0400000000420b0a016d10001a0400000001420b0a017810001a0400000002420b0a017910001a0400000003420b0a017a10001a040000000460006a01316a013572050a0131100172050a0134100172050a01351001</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:26:31.345</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">1</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">1</td></tr><tr><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">6</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); "><i>null</i></td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); "><i>null</i></td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">com.sample.ruleflow</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); "><i>null</i></td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">2013-09-05 20:36:01.168</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">0</td><td style="line-height: 1.4; padding: 2px; text-align: left; vertical-align: top; border: 1px solid rgb(172, 168, 153); ">0</td></tr></tbody></table><div><br></div></div><div>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. </div><div><br></div><div>Thanks for any help in advance :)</div><div><br></div><div>Cheers, Alex</div></body></html>