2 Replies Latest reply on Jun 13, 2007 9:22 AM by Martin Weiler

    jbpm using oracle DB probleme

    mohammed lethrech Newbie

      hi,
      i m using jbpm 3.1.3 whith oracle9i DB, i have created my schema and configured my datasource but i have the following error when i start my jboss4.0.4 :

      2007 06 13 - 12:00:41 ERROR ?.? [ORA-00923: Mot-clé FROM absent à l'emplacement prévu
      ]]
      2007 06 13 - 12:00:41 ERROR ?.? [ORA-00923: Mot-clé FROM absent à l'emplacement prévu
      ]
      2007 06 13 - 12:00:41 INFO org.apache.commons.logging.impl.Log4JLogger.error [2007 06 13 - 12:00:41 ERROR ?.? [org.hibernate.exception.SQLGrammarException: could not execute query using iterate]]
      2007 06 13 - 12:00:41 ERROR ?.? [org.hibernate.exception.SQLGrammarException: could not execute query using iterate]
      2007 06 13 - 12:00:41 INFO org.apache.commons.logging.impl.Log4JLogger.info [2007 06 13 - 12:00:41 INFO ?.? [runtime exception while executing timers]
      org.jbpm.JbpmException: couldn't find timers from the database
       at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:99)
       at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:107)
       at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:71)
      Caused by: org.hibernate.exception.SQLGrammarException: could not execute query using iterate
       at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
       at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
       at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:424)
       at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:380)
       at org.hibernate.engine.query.HQLQueryPlan.performIterate(HQLQueryPlan.java:224)
       at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1192)
       at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:46)
       at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.java:93)
       ... 2 more
      Caused by: java.sql.SQLException: ORA-00923: Mot-clé FROM absent à l'emplacement prévu


      my data source is as follow:
      <datasources>
       <local-tx-datasource>
       <jndi-name>jbpmDS</jndi-name>
       <connection-url>jdbc:oracle:thin:@192.168.10.134:1521:DB1</connection-url>
       <driver-class>oracle.jdbc.OracleDriver</driver-class>
       <user-name>jbpmtest</user-name>
       <password>jbpmtest</password>
       <min-pool-size>5</min-pool-size>
       <max-pool-size>20</max-pool-size>
       <idle-timeout-minutes>0</idle-timeout-minutes>
       <prepared-statement-cache-size>32</prepared-statement-cache-size>
       <metadata>
       <type-mapping>Oracle9i</type-mapping>
       </metadata>
       </local-tx-datasource>
      
      </datasources>
      


      can you help me
      thank s a lot