Re: [rules-users] How to remove a persisted session from the database ?

Yeah thanks ! I had figured it out, but how do you get your "transactional context" ? I ended up doing the following, in case someone else needs to do the same: within a class... public void deleteSession(StatefulKnowledgeSession session) { initTransactionManager(); this.txm.begin(); registerRollbackSync(); SessionInfo info = jpm.getApplicationScopedEntityManager().find(org.drools.persistence.session.SessionInfo.class, new Integer(session.getId())); System.out.println("This is the sessionInfo: " + info); jpm.getApplicationScopedEntityManager().remove(info); jpm.getApplicationScopedEntityManager().flush(); this.txm.commit(); } private void initTransactionManager() { Object tm = environment.get( EnvironmentName.TRANSACTION_MANAGER ); this.txm = new JtaTransactionManager( environment.get( EnvironmentName.TRANSACTION ), environment.get( EnvironmentName.TRANSACTION_SYNCHRONIZATION_REGISTRY ), tm ); this.jpm = new DefaultJpaManager(this.environment); } private static class SynchronizationImpl implements TransactionSynchronization { JPAKnowledgeSessionLookup service = getInstance(); public SynchronizationImpl(JPAKnowledgeSessionLookup service) { this.service = service; } public void afterCompletion(int status) { if ( status != TransactionManager.STATUS_COMMITTED ) { this.service.rollback(); } this.service.jpm.endCommandScopedEntityManager(); } public void beforeCompletion() { } } Thanks On Wed, Sep 15, 2010 at 1:33 PM, drooRam <rajeshram7(a)yahoo.com&gt; wrote: