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 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
