<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:12pt"><DIV><FONT face="arial, helvetica, sans-serif">I am back on the same dev server today, no issues now. </FONT></DIV>
<DIV><FONT face="arial, helvetica, sans-serif"></FONT> </DIV>
<DIV><FONT face="arial, helvetica, sans-serif">I am using JTDS 1.2.2, which I agree is generally better than the MS version. </FONT></DIV>
<DIV><FONT face="arial, helvetica, sans-serif"></FONT> </DIV>
<DIV><FONT face="arial, helvetica, sans-serif">Our DBA thinks the .NET update (or something else) reset the number of allowed connections from 32,676 to 5. That could be it. Anyway, unless we can recreate, its a dead issue.</FONT></DIV>
<DIV><FONT face="arial, helvetica, sans-serif"></FONT> </DIV>
<DIV><FONT face="arial, helvetica, sans-serif">Anyway, I've got some other issues with </FONT><FONT size=2 face=Tahoma><FONT size=3 face="arial, helvetica, sans-serif">JPAVariablePersister, so I'm going to start another thread, hopefully you can help me again :-)</FONT></FONT></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> Sat, October 17, 2009 7:06:46 AM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [rules-users] [droolsflow] JPAVariablePersister Crashing SQL Server RPC?<BR></FONT><BR>Hmm...<BR>Interesting.. what JDBC driver are you using? <BR>I remember having troubles with the microsoft one, then I tried with JTDS and everything works fine.<BR>But this was about a year ago, with other problem.<BR><BR><BR>
<DIV class=gmail_quote>2009/10/17 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>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>
<DIV class=im>
<HR SIZE=1>
<B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Mauricio Salatino <<A href="mailto:salaboy@gmail.com" rel=nofollow target=_blank ymailto="mailto:salaboy@gmail.com">salaboy@gmail.com</A>><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Rules Users List <<A href="mailto:rules-users@lists.jboss.org" rel=nofollow target=_blank ymailto="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</A>><BR></DIV><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Fri, October 16, 2009 8:51:45 AM
<DIV class=im><BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [rules-users] [droolsflow] JPAVariablePersister Crashing SQL Server RPC?<BR></DIV></FONT>
<DIV class=im><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></DIV><BR></DIV><BR>_______________________________________________<BR>rules-users mailing list<BR><A href="mailto:rules-users@lists.jboss.org" rel=nofollow target=_blank ymailto="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</A><BR><A href="https://lists.jboss.org/mailman/listinfo/rules-users" rel=nofollow target=_blank>https://lists.jboss.org/mailman/listinfo/rules-users</A><BR><BR></BLOCKQUOTE></DIV><BR><BR clear=all><BR>-- <BR>- http://salaboy.wordpress.com<BR>- http://www.jbug.com.ar<BR>- Salatino "Salaboy" Mauricio -<BR></DIV></DIV></div><br>
</body></html>