Exception when getting instance variables
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
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
)
)
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.
No answers yet.