Exception when getting instance variables

Q&A
1

Hi all.

The following error happens when getting instance variables (bonita_history and bonita_journal) by Java application:

17:33:06,826 WARNING [JDBCExceptionReporter] SQL Error: 933, SQLState: 42000
17:33:06,826 SEVERE [JDBCExceptionReporter] ORA-00933: SQL command not properly ended

…

Caused by: java.io.IOException: The hierarchy of org.hibernate.exception.SQLGrammarException is different in your current classPath
at org.jboss.serial.classmetamodel.StreamingClass.readStream(StreamingClass.java:80)
at org.jboss.serial.objectmetamodel.ObjectDescriptorFactory.readObjectDescriptionFromStreaming(ObjectDescriptorFactory.java:381)
at org.jboss.serial.objectmetamodel.ObjectDescriptorFactory.objectFromDescription(ObjectDescriptorFactory.java:82)
at org.jboss.serial.objectmetamodel.DataContainer$DataContainerInput.readObject(DataContainer.java:845)
at org.jboss.serial.persister.RegularObjectPersister.readSlotWithFields(RegularObjectPersister.java:353)
at org.jboss.serial.persister.ObjectInputStreamProxy.defaultReadObject(ObjectInputStreamProxy.java:78)
at java.lang.Throwable.readObject(Throwable.java:914)
… 72 more

Source Code:

AccessorUtil.getQueryRuntimeAPI().getProcessInstanceVariables(processInstanceUUID);

Query:

/* named HQL query getOverdueEvents */ select outgoingev0_.DBID_ as col_0_0_ from BN_OEI_ outgoingev0_ where outgoingev0_.OVERDUE<>-1 and outgoingev0_.OVERDUE<? and outgoingev0_.LOCKED=0

/* named HQL query getOverdueEvents */ select
outgoingev0_.DBID_ as col_0_0_
from
BN_OEI_ outgoingev0_
where
outgoingev0_.OVERDUE<>-1
and outgoingev0_.OVERDUE<?
and outgoingev0_.LOCKED=0

/* named HQL query getNextExpressionEventDueDate */ select
min(incomingev0_.ENABLE_TIME_) as col_0_0_
from
BN_IEI_ incomingev0_ cross
join
BN_OEI_ outgoingev1_
where
incomingev0_.NAME=outgoingev1_.NAME
and (
incomingev0_.EXPR is not null
)
and (
incomingev0_.COR_KEY1_ is null
)
and (
outgoingev1_.COR_KEY1_ is null
)
and (
incomingev0_.COR_KEY2_ is null
)
and (
outgoingev1_.COR_KEY2_ is null
)
and (
incomingev0_.COR_KEY3_ is null
)
and (
outgoingev1_.COR_KEY3_ is null
)
and (
incomingev0_.COR_KEY4_ is null
)
and (
outgoingev1_.COR_KEY4_ is null
)
and (
incomingev0_.COR_KEY5_ is null
)
and (
outgoingev1_.COR_KEY5_ is null
)
and incomingev0_.LOCKED=0
and outgoingev1_.LOCKED=0
and (
outgoingev1_.PROC_NAME is null
or outgoingev1_.PROC_NAME=incomingev0_.PROC_NAME
)
and (
outgoingev1_.ACT_NAME is null
or outgoingev1_.ACT_NAME=incomingev0_.ACT_NAME
)
and (
outgoingev1_.DBID_ not in (
select
incompatib2_.OUTGOING_ID
from
BN_INCOMP_EVENTS incompatib2_
where
incomingev0_.DBID_=incompatib2_.INCOMING_ID
)
)

App Server: JBoss-5.1.0.GA
Java version: 1.7.0_75
Oracle version: 11g

Any help is welcome.

Thanks.