to deploy the jbpm3.0.1 to jboss4.0.3, db is ms sqlserver,,
hi:
i try to deploy the jbpm3.0.1 to jboss4.0.3, db is ms sqlserver, jdbc jtds-1.1 .
but it gives error:
16:03:12,930 INFO [FacesConfigurator] Reading config jar:file:/C:/DOCUME~1/ADMINI~1/LOCALS~1/Temp/myfaces23649.jar!/MET
A-INF/faces-config.xml
16:03:13,055 INFO [FacesConfigurator] Reading config /WEB-INF/faces-config.xml
16:03:13,289 DEBUG [ApplicationFactory] New ApplicationFactory instance created
16:03:14,039 INFO [StartupServletContextListener] ServletContext 'D:\jboss-4.0.3\server\jbpm\.\tmp\deploy\tmp23647jbpm-
exp.war\' initialized.
16:03:14,086 DEBUG [Scheduler] starting the scheduler
16:03:14,086 DEBUG [JbpmSessionFactory] fetching JbpmSessionFactory from 'java:/jbpm/JbpmSessionFactory'
16:03:14,289 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
16:03:14,367 DEBUG [SchedulerThread] checking for timers
16:03:14,633 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:03:14,648 ERROR [JDBCExceptionReporter] Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER
timer0_ where timer0_.EXCEPTION_ is null order by timer0_.DUEDATE_ asc]
16:03:14,648 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
16:03:14,648 ERROR [JbpmSession] java.lang.NullPointerException
16:03:14,664 ERROR [JbpmSession] couldn't rollback hibernate transaction
org.hibernate.TransactionException: Transaction not successfully started
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:149)
at org.jbpm.db.JbpmSession.handleException(JbpmSession.java:177)
at org.jbpm.db.JbpmSession.commitTransaction(JbpmSession.java:106)
at org.jbpm.db.JbpmSession.commitTransactionAndClose(JbpmSession.java:129)
at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:121)
at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:34)
16:03:14,680 WARN [JbpmSession] can't pop current session: are you calling JbpmSession.close() multiple times ?
16:03:14,695 INFO [SchedulerThread] runtime exception while executing timers
java.lang.RuntimeException: couldn't commit transaction
at org.jbpm.db.JbpmSession.commitTransaction(JbpmSession.java:107)
at org.jbpm.db.JbpmSession.commitTransactionAndClose(JbpmSession.java:129)
at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:121)
at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:34)
Caused by: java.lang.NullPointerException
at org.jbpm.db.JbpmSession.commitTransaction(JbpmSession.java:102)
... 3 more
16:03:15,023 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
16:03:15,195 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
16:03:15,211 INFO [JkMain] Jk running ID=0 time=0/125 config=null
16:03:15,211 INFO [Server] JBoss (MX MicroKernel) [4.0.3 (build: CVSTag=JBoss_4_0_3 date=200510042324)] Started in 29s:
876ms
16:03:19,695 DEBUG [SchedulerThread] checking for timers
16:03:19,695 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
16:03:19,695 ERROR [JDBCExceptionReporter] Table not found in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER
timer0_ where timer0_.EXCEPTION_ is null order by timer0_.DUEDATE_ asc]
16:03:19,695 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
16:03:19,695 ERROR [JbpmSession] java.lang.NullPointerException
16:03:19,695 ERROR [JbpmSession] couldn't rollback hibernate transaction
org.hibernate.TransactionException: Transaction not successfully started
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:149)
at org.jbpm.db.JbpmSession.handleException(JbpmSession.java:177)
at org.jbpm.db.JbpmSession.commitTransaction(JbpmSession.java:106)
at org.jbpm.db.JbpmSession.commitTransactionAndClose(JbpmSession.java:129)
at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:121)
at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:34)
16:03:19,695 WARN [JbpmSession] can't pop current session: are you calling JbpmSession.close() multiple times ?
16:03:19,695 INFO [SchedulerThread] runtime exception while executing timers
java.lang.RuntimeException: couldn't commit transaction
at org.jbpm.db.JbpmSession.commitTransaction(JbpmSession.java:107)
at org.jbpm.db.JbpmSession.commitTransactionAndClose(JbpmSession.java:129)
at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread.java:121)
at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:34)
Caused by: java.lang.NullPointerException
at org.jbpm.db.JbpmSession.commitTransaction(JbpmSession.java:102)
... 3 more
16:03:24,695 DEBUG [SchedulerThread] checking for timers
in db ,the table jbpm_timer is exist.
CREATE TABLE [dbo].[JBPM_TIMER] (
[ID_] [numeric](19, 0) IDENTITY (1, 1) NOT NULL ,
[NAME_] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[DUEDATE_] [datetime] NULL ,
[REPEAT_] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[TRANSITIONNAME_] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[EXCEPTION_] [varchar] (4000) COLLATE Chinese_PRC_CI_AS NULL ,
[ACTION_] [numeric](19, 0) NULL ,
[TOKEN_] [numeric](19, 0) NULL ,
[PROCESSINSTANCE_] [numeric](19, 0) NULL ,
[TASKINSTANCE_] [numeric](19, 0) NULL ,
[GRAPHELEMENTTYPE_] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[GRAPHELEMENT_] [numeric](19, 0) NULL
) ON [PRIMARY]