I am back on the same dev server today, no issues now.
I am using JTDS 1.2.2, which I agree is generally better than the MS version.
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.
Anyway, I've got some other issues with JPAVariablePersister, so I'm going to
start another thread, hopefully you can help me again :-)
________________________________
From: Mauricio Salatino <salaboy(a)gmail.com>
To: Rules Users List <rules-users(a)lists.jboss.org>
Sent: Sat, October 17, 2009 7:06:46 AM
Subject: Re: [rules-users] [droolsflow] JPAVariablePersister Crashing SQL Server RPC?
Hmm...
Interesting.. what JDBC driver are you using?
I remember having troubles with the microsoft one, then I tried with JTDS and everything
works fine.
But this was about a year ago, with other problem.
2009/10/17 Bill Tarr <javatestcase(a)yahoo.com>
Quick update. No definitive progress, but some potential info that may lift the blame
from JPA Persister.
I installed SQL 2008 Express locally, and my test case does not crash my DB there.
In addition, our DBA is seeing wierd behavior on our SQL Server since a .NET update was
pushed down.
We rolled back the update, and will test against the same server with debugging on
Monday.
I'll be looking into Hibernate vs JPA Persistence this weekend.
Thanks!
________________________________
From: Mauricio Salatino <salaboy(a)gmail.com>
To: Rules Users List <rules-users(a)lists.jboss.org>
Sent: Fri, October 16, 2009 8:51:45 AM
Subject: Re: [rules-users] [droolsflow] JPAVariablePersister Crashing SQL Server RPC?
Great to hear that you are using it.
Obviously need some improvements. I will try to help you guys on that.
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.
Greetings.
2009/10/16 Bill Tarr <javatestcase(a)yahoo.com>
Hi Mauricio,
>
>I don't actually have a stack trace. Every time I've run the test, it has
completed without errors exactly once.
>
>There is nothing in the stack indicating anything bad happened, but immediately after
SQL Server is unresponsive to any clients.
>
>As to Hibernate Mappings, you are ahead of me already.
>
>I am currently testing with annotated JPA entities (for Claims and Role) which mirror
my real Hibernate mapped entities.
>
>I've haven't found anything absolute on this, but think you CAN'T use
Hibernate mappings within JPA.
>
>That means we will need a new Variable Persister, but presumably one similar to the
JPA Persister.
>
>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.
>
>Thanks! And great work on the variable persister, the timing was perfect for us!
>
>Bill
_______________________________________________
rules-users mailing list
rules-users(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/rules-users
--
-
http://salaboy.wordpress.com
-
http://www.jbug.com.ar
- Salatino "Salaboy" Mauricio -