[rules-users] [droolsflow] JPAVariablePersister Crashing SQL Server RPC?

[Mauricio Salatino]

yes of course,


2009/10/19 Bill Tarr <javatestcase at yahoo.com>

> 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 at gmail.com>
> *To:* Rules Users List <rules-users at 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 at 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 at gmail.com>
>> *To:* Rules Users List <rules-users at 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 at 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 at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/rules-users
>>
>>
>
>
> --
> - http://salaboy.wordpress.com
> - http://www.jbug.com.ar
> - Salatino "Salaboy" Mauricio -
>
>
> _______________________________________________
> rules-users mailing list
> rules-users at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/rules-users
>
>


-- 
- http://salaboy.wordpress.com
- http://www.jbug.com.ar
- Salatino "Salaboy" Mauricio -
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/rules-users/attachments/20091019/62c010ae/attachment.html