I experienced problems using JBPM (that uses Hibernate) and Hibernate 3. In concrete, the problem arise in the query:
Code:
<query name="GraphSession.findLatestProcessDefinitionQuery">
<![CDATA[
select pd, pd.version
from org.jbpm.graph.def.ProcessDefinition as pd
where pd.name = :name
order by pd.version desc
]]>
</query>
The jbpm class do:
Code:
Query query = session.getNamedQuery("GraphSession.findLatestProcessDefinitionQuery");
query.setString("name", name);
query.setMaxResults(1);
processDefinition = (ProcessDefinition) query.uniqueResult();
In this point a ClassCastException is thrown due to uniqueResult returns a list instead of a single row.
Someone have experimented some similar with Informix ?
Thanks in advance ..
(I know .. I could to change the jbpm code ... but this is the last solution)