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:

  1. 17:33:06,826 WARNING [JDBCExceptionReporter] SQL Error: 933, SQLState: 42000
  2. 17:33:06,826 SEVERE [JDBCExceptionReporter] ORA-00933: SQL command not properly ended
  3.  
  4. ...
  5.  
  6. Caused by: java.io.IOException: The hierarchy of org.hibernate.exception.SQLGrammarException is different in your current classPath
  7. at org.jboss.serial.classmetamodel.StreamingClass.readStream(StreamingClass.java:80)
  8. at org.jboss.serial.objectmetamodel.ObjectDescriptorFactory.readObjectDescriptionFromStreaming(ObjectDescriptorFactory.java:381)
  9. at org.jboss.serial.objectmetamodel.ObjectDescriptorFactory.objectFromDescription(ObjectDescriptorFactory.java:82)
  10. at org.jboss.serial.objectmetamodel.DataContainer$DataContainerInput.readObject(DataContainer.java:845)
  11. at org.jboss.serial.persister.RegularObjectPersister.readSlotWithFields(RegularObjectPersister.java:353)
  12. at org.jboss.serial.persister.ObjectInputStreamProxy.defaultReadObject(ObjectInputStreamProxy.java:78)
  13. at java.lang.Throwable.readObject(Throwable.java:914)
  14. ... 72 more

Source Code:

  1. AccessorUtil.getQueryRuntimeAPI().getProcessInstanceVariables(processInstanceUUID);

Query:

  1. /* named HQL query getOverdueEvents */ SELECT
  2. outgoingev0_.DBID_ AS col_0_0_
  3. FROM
  4. BN_OEI_ outgoingev0_
  5. WHERE
  6. outgoingev0_.OVERDUE<>-1
  7. AND outgoingev0_.OVERDUE<?
  8. AND outgoingev0_.LOCKED=0
  9.  
  10. /* named HQL query getOverdueEvents */ SELECT
  11. outgoingev0_.DBID_ AS col_0_0_
  12. FROM
  13. BN_OEI_ outgoingev0_
  14. WHERE
  15. outgoingev0_.OVERDUE<>-1
  16. AND outgoingev0_.OVERDUE<?
  17. AND outgoingev0_.LOCKED=0
  18.  
  19. /* named HQL query getNextExpressionEventDueDate */ SELECT
  20. MIN(incomingev0_.ENABLE_TIME_) AS col_0_0_
  21. FROM
  22. BN_IEI_ incomingev0_ CROSS
  23. JOIN
  24. BN_OEI_ outgoingev1_
  25. WHERE
  26. incomingev0_.NAME=outgoingev1_.NAME
  27. AND (
  28. incomingev0_.EXPR IS NOT NULL
  29. )
  30. AND (
  31. incomingev0_.COR_KEY1_ IS NULL
  32. )
  33. AND (
  34. outgoingev1_.COR_KEY1_ IS NULL
  35. )
  36. AND (
  37. incomingev0_.COR_KEY2_ IS NULL
  38. )
  39. AND (
  40. outgoingev1_.COR_KEY2_ IS NULL
  41. )
  42. AND (
  43. incomingev0_.COR_KEY3_ IS NULL
  44. )
  45. AND (
  46. outgoingev1_.COR_KEY3_ IS NULL
  47. )
  48. AND (
  49. incomingev0_.COR_KEY4_ IS NULL
  50. )
  51. AND (
  52. outgoingev1_.COR_KEY4_ IS NULL
  53. )
  54. AND (
  55. incomingev0_.COR_KEY5_ IS NULL
  56. )
  57. AND (
  58. outgoingev1_.COR_KEY5_ IS NULL
  59. )
  60. AND incomingev0_.LOCKED=0
  61. AND outgoingev1_.LOCKED=0
  62. AND (
  63. outgoingev1_.PROC_NAME IS NULL
  64. OR outgoingev1_.PROC_NAME=incomingev0_.PROC_NAME
  65. )
  66. AND (
  67. outgoingev1_.ACT_NAME IS NULL
  68. OR outgoingev1_.ACT_NAME=incomingev0_.ACT_NAME
  69. )
  70. AND (
  71. outgoingev1_.DBID_ NOT IN (
  72. SELECT
  73. incompatib2_.OUTGOING_ID
  74. FROM
  75. BN_INCOMP_EVENTS incompatib2_
  76. WHERE
  77. incomingev0_.DBID_=incompatib2_.INCOMING_ID
  78. )
  79. )

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