yes of course,<br><br><br><div class="gmail_quote">2009/10/19 Bill Tarr <span dir="ltr"><<a href="mailto:javatestcase@yahoo.com">javatestcase@yahoo.com</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div><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 face="Tahoma" size="2"><font face="arial, helvetica, sans-serif" size="3">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 face="Tahoma" size="2"><div class="im">
<hr size="1">
<b><span style="font-weight: bold;">From:</span></b> Mauricio Salatino <<a href="mailto:salaboy@gmail.com" target="_blank">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" target="_blank">rules-users@lists.jboss.org</a>><br>
</div><b><span style="font-weight: bold;">Sent:</span></b> Sat, October 17, 2009 7:06:46 AM<div><div></div><div class="h5"><br><b><span style="font-weight: bold;">Subject:</span></b> Re: [rules-users] [droolsflow] JPAVariablePersister Crashing SQL Server RPC?<br>
</div></div></font><div><div></div><div class="h5"><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">javatestcase@yahoo.com</a>></span><br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); 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 face="Tahoma" size="2">
<div>
<hr size="1">
<b><span style="font-weight: bold;">From:</span></b> Mauricio Salatino <<a href="mailto:salaboy@gmail.com" rel="nofollow" target="_blank">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">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><br><b><span style="font-weight: bold;">Subject:</span></b> Re: [rules-users] [droolsflow] JPAVariablePersister Crashing SQL Server RPC?<br></div></font>
<div><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">javatestcase@yahoo.com</a>></span><br>
<blockquote style="border-left: 1px solid rgb(204, 204, 204); 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">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>- <a href="http://salaboy.wordpress.com" target="_blank">http://salaboy.wordpress.com</a><br>
- <a href="http://www.jbug.com.ar" target="_blank">http://www.jbug.com.ar</a><br>- Salatino "Salaboy" Mauricio -<br></div></div></div></div></div><br>
</div><br>_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br> - <a href="http://salaboy.wordpress.com">http://salaboy.wordpress.com</a><br> - <a href="http://www.jbug.com.ar">http://www.jbug.com.ar</a><br> - Salatino "Salaboy" Mauricio -<br>