jbpm using oracle DB probleme

[lethrech]

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

[kukeltje]

cool.... mot-clé.... word-key?

[mputz]

did you set the hibernate db dialect in jbpm-configs.jar/hibernate.cfg.xml?