How to get knowledge sessions from database.

[wailwinmoe]

Dear all,

I would like to get all the knowledge sessions that stored in sessioninfo table in database.

Which method should I use to get these session informations from database?

Or do I need to write customized query to get these sessions?

If you have any idea, kindly help me.

Best regards,

Wai Lwin Moe

[swiderski.maciej]

use JPAKnowledgeService.loadStatefulKnowledgeSession to load ksession from data base.

HTH

[wailwinmoe]

Hi

Yes, JPAKnowledgeService.loadStatefulKnowledgeSession method is to load ksession.

In order to load ksession, I need to know the session id. Session id is stored in sessioninfo table in database.

But, I want to get session id from database.

If you have any suggestion, kindly let me know.

Best regards,

Wai Lwin Moe

[ctkcin]

From where you are trying to load knowledgeSession?

do you have taskid or workitemid?

It depends on you requirement. provide code and scenario. If you have taskid then use code like this.

Long workItemId = loadedClient.getTask(taskId).getTaskData().getWorkItemId();

int sessionId = loadedClient.getTask(taskId).getTaskData().getProcessSessionId();

[wailwinmoe]

Hi

I do not have taskid or workitemid.

I want to get sessionid in project intialization. I have only kBase which loads jbpm files and entityManager.

If you have any idea, kindly tell me.

Best regards,

Wai Lwin Moe.

[ctkcin]

In that case, you can execute query to load all sessions

Select * from sessioninfo;

OR

you can use kBase.getStatefulKnowledgeSessions() method to load all session in knowledgebase.