Java app hangs retrieving process definition

[michaelholtzman]

I have successfully stored process definitions in Sybase. However, when I try to retrieve a process definition, jbpm hangs (process is not responding in windows task manager)

processName = "Example Process";
 console("Launch: Getting process definition");
 processDefinition =
 jbpmSession
 .getGraphSession()
 .findLatestProcessDefinition(processName);

It never returns from this call. There are clearly process definitions in the database table with NAME_ set to "Example Process", confirmed using ISQL.

HELP! Thanx.

[kukeltje]

Please turn on hibernate debugging and see where it realy stalls.

[michaelholtzman]

Umm, okay, how do I turn on hibernate debugging?

[koen.aers]

Look in the log4j.properties file.

# Hibernate debugging levels and their output
log4j.logger.org.hibernate=INFO

INFO should become DEBUG. Have a look at the Log4J user manual for more info.

Regards,
Koen

[michaelholtzman]

I turned on debug, and when this statement is executed:

console("Creating instance of '" + processName + "'");

 // Let's open a new persistence session
 jbpmSession = jbpmSessionFactory.openJbpmSession();
// jbpmSession.beginTransaction();

 // Now we can query the database for the process definition that we deployed above.
 console("Launch: Getting process definition");
 processDefinition =
 jbpmSession
 .getGraphSession()
 .findLatestProcessDefinition(processName);
 console("Retrieved process definition '" + processDefinition.getName() + "'");

it produces this:

===> Creating instance of 'Example Process'
14:06:45,419 DEBUG ? : opened session at timestamp: 4637714044596224
===> Launch: Getting process definition
14:06:45,435 DEBUG ? : iterate: select pd from org.jbpm.graph.def.ProcessDefinition as pd where pd.name = :name order by
 pd.version desc
14:06:45,435 DEBUG ? : named parameters: {name=Example Process}

It seems like it never returns from the query. Any suggestions about what might be causing this? Thanx.

[koen.aers]

This looks to me like a Hibernate/Sybase issue. Did you already have a look at the Hibernate forums if there is any info on e.g. drivers? I have never seen the problem but then I never worked with Sybase.
Sorry I can't be of further help...

Success,
Koen

[koen.aers]

Well I have another suggestion. Try to run this HQL query from another client such as a JUnit test and see if it stalls too.

Regards,
Koen