HI Bill,<br>Can you paste here the full stack trace?<br>I don't test it in SQL Server, but if the problem persist I'm interested in solve it.<br>Some thoughts:<br>1) does JPA take the Hibernate Mappings as JPA entities without adding them at the persistence.xml file?, I think yes, but I'm not sure<br>
2) if not, probably we need to create a new persister for hibernate mapped entities.<br><br><br><div class="gmail_quote">On Thu, Oct 15, 2009 at 9:26 PM, Bill Tarr <span dir="ltr"><<a href="mailto:javatestcase@yahoo.com">javatestcase@yahoo.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Has anyone successfully used JPAVariablePersister on Sql Server? The quick hits are we are running MSSQL 2008, and after introducing JPAVariablePersister (which is described very well in <a href="http://blog.athico.com/2009/09/drools-flow-variable-persistence.html" target="_blank">http://blog.athico.com/2009/09/drools-flow-variable-persistence.html</a>) every time I run my test case, the DB becomes non-responsive, returning from any JDBC pings:<br>
<br>
java.sql.SQLException: I/O Error: DB server closed connection.<br>
<br>
You can't even connect through MSSQL Management Studios, looks like RPC service has gone down. Haven't been able to do much troubleshooting yet (slow going when you need to get a DBA to reboot your sever every time.)<br>
<br>
I've already tested out the JPAKnowledgeService with some success. Setting up my session with the following code, I can see the SessionInfo, ProcessInstanceInfo, ProcessInstanceInfo_eventTypes tables storing data, looks pretty solid, and I can grab the processes again.<br>
<br>
EntityManagerFactory emf = Persistence.createEntityManagerFactory("org.drools.persistence.jpa");<br>
env = KnowledgeBaseFactory.newEnvironment();<br>
env.set(EnvironmentName.ENTITY_MANAGER_FACTORY, emf);<br>
session = JPAKnowledgeService.newStatefulKnowledgeSession(knowledgeBase, null, env);<br>
<br>
Map<String, Object> parameterMap = new HashMap<String, Object>();<br>
parameterMap.put("claim", claim);<br>
processInstance = session.startProcess(CLAIMS_DEMO, parameterMap);<br>
<br>
I want to store my variable separately though, as we already have them as Hibernate DTOs. So I added the following code, as well as adding JPAVariablePersister to my persistence.xml.<br>
<br>
VariablePersistenceStrategyFactory.getVariablePersistenceStrategy()<br>
.setPersister("javax.persistence.Entity",<br>
"org.drools.persistence.processinstance.persisters.JPAVariablePersister");<br>
<br>
The code appears to run through. This time, I can see data in the SessionInfo, ProcessInstanceInfo, ProcessInstanceInfo_eventTypes tables, as well as additional data in VariableInstanceInfo, and my two entities (Claim, which has a List of Role.) The data looks pretty good, and my process logs hit the expected nodes.<br>
<br>
Anyway, I'll post more as I learn it. Let me know if anyone else is running into this.<br>
<br>
Thanks!<br>
<br>
Bill<br>
<br>
<br>
<br>
<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>
</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>