<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:12pt"><DIV>Quick update. No definitive progress, but some potential info that may lift the blame from JPA Persister. </DIV>
<DIV> </DIV>
<DIV>I installed SQL 2008 Express locally, and my test case does not crash my DB there. </DIV>
<DIV> </DIV>
<DIV>In addition, our DBA is seeing wierd behavior on our SQL Server since a .NET update was pushed down. </DIV>
<DIV> </DIV>
<DIV>We rolled back the update, and will test against the same server with debugging on Monday.<BR></DIV>
<DIV>I'll be looking into Hibernate vs JPA Persistence this weekend.</DIV>
<DIV> </DIV>
<DIV>Thanks!</DIV>
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt"><BR>
<DIV style="FONT-FAMILY: times new roman, new york, times, serif; FONT-SIZE: 12pt"><FONT size=2 face=Tahoma>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Mauricio Salatino <salaboy@gmail.com><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Rules Users List <rules-users@lists.jboss.org><BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Fri, October 16, 2009 8:51:45 AM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [rules-users] [droolsflow] JPAVariablePersister Crashing SQL Server RPC?<BR></FONT><BR>Great to hear that you are using it. <BR>Obviously need some improvements. I will try to help you guys on that.<BR>Would be nice to activate the debugging option of MS SqlServer to see the queries that are being generated. If you have that information please let me know.<BR>Greetings.<BR><BR>
<DIV class=gmail_quote>2009/10/16 Bill Tarr <SPAN dir=ltr><<A href="mailto:javatestcase@yahoo.com" rel=nofollow target=_blank ymailto="mailto:javatestcase@yahoo.com">javatestcase@yahoo.com</A>></SPAN><BR>
<BLOCKQUOTE style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex" class=gmail_quote>
<DIV>
<DIV style="FONT-FAMILY: arial, helvetica, sans-serif; FONT-SIZE: 12pt">
<DIV>Hi Mauricio,</DIV>
<DIV> </DIV>
<DIV>I don't actually have a stack trace. Every time I've run the test, it has completed without errors exactly once. </DIV>
<DIV> </DIV>
<DIV>There is nothing in the stack indicating anything bad happened, but immediately after SQL Server is unresponsive to any clients.<BR></DIV>
<DIV>As to Hibernate Mappings, you are ahead of me already. </DIV>
<DIV> </DIV>
<DIV>I am currently testing with annotated JPA entities (for Claims and Role) which mirror my real Hibernate mapped entities.</DIV>
<DIV> </DIV>
<DIV>I've haven't found anything absolute on this, but think you CAN'T use Hibernate mappings within JPA.</DIV>
<DIV> </DIV>
<DIV>That means we will need a new Variable Persister, but presumably one similar to the JPA Persister.</DIV>
<DIV> </DIV>
<DIV>I'll be testing more today, as I'll can and let you know if my DBA can get any more info to see if SQL Server is telling us anything useful.</DIV>
<DIV> </DIV>
<DIV>Thanks! And great work on the variable persister, the timing was perfect for us!</DIV>
<DIV> </DIV>
<DIV>Bill</DIV></DIV></DIV></BLOCKQUOTE></DIV></DIV></DIV></div><br>
</body></html>