[jboss-user] [JBoss jBPM] - 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

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4053919#4053919

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4053919