Exception when getting instance variables

1
0
-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.

No answers yet.
Notifications