change the websale to mssql, i met some problems
i deployed jbpm3.0 successfully. then i changed hsqldb to mssql.
an built build.deploy.xml successfully, and i can find jbpm tables and data in mssql.
but when deploy it under jboss.met errors
17:10:42,578 INFO [Configuration] processing association property references
17:10:42,578 INFO [Configuration] processing foreign key constraints
17:10:42,703 INFO [NamingHelper] JNDI InitialContext properties:{}
17:10:42,703 INFO [DatasourceConnectionProvider] Using datasource: java:/DefaultDS
17:10:42,718 INFO [SettingsFactory] RDBMS: HSQL Database Engine, version: 1.8.0
17:10:42,718 INFO [SettingsFactory] JDBC driver: HSQL Database Engine Driver, version: 1.8.0
17:10:42,750 INFO [Dialect] Using dialect: org.hibernate.dialect.HSQLDialect
17:10:42,750 INFO [SettingsFactory] JDBC batch size: 15
17:10:42,750 INFO [SettingsFactory] JDBC batch updates for versioned data: disabled
17:10:42,750 INFO [SettingsFactory] Scrollable result sets: enabled
17:10:42,750 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): disabled
17:10:42,750 INFO [SettingsFactory] Aggressive release : disabled
17:10:42,750 INFO [SettingsFactory] Default batch fetch size: 1
17:10:42,750 INFO [SettingsFactory] Generate SQL with comments: disabled
17:10:42,750 INFO [SettingsFactory] Order SQL updates by primary key: disabled
17:10:42,750 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
17:10:42,781 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
17:10:42,781 INFO [SettingsFactory] Query language substitutions: {}
17:10:42,781 INFO [TransactionFactoryFactory] Using default transaction strategy (direct JDBC transactions)
17:10:42,796 INFO [TransactionManagerLookupFactory] No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
17:10:42,796 INFO [SettingsFactory] Automatic flush during beforeCompletion(): disabled
17:10:42,796 INFO [SettingsFactory] Automatic session close at end of transaction: disabled
17:10:42,796 INFO [SettingsFactory] Second-level cache: enabled
17:10:42,796 INFO [SettingsFactory] Query cache: disabled
17:10:42,796 INFO [SettingsFactory] Cache provider: org.hibernate.cache.EhCacheProvider
17:10:42,796 INFO [SettingsFactory] Optimize cache for minimal puts: disabled
17:10:42,796 INFO [SettingsFactory] Structured second-level cache entries: enabled
17:10:42,812 INFO [SettingsFactory] Statistics: disabled
17:10:42,812 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disabled
17:10:42,812 INFO [SettingsFactory] Default entity-mode: pojo
17:10:42,984 INFO [SessionFactoryImpl] building session factory
17:10:43,312 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Node]; using defaults.
17:10:43,421 WARN [EhCacheProvider] Could not find configuration [org.jbpm.instantiation.Delegation]; using defaults.
17:10:43,562 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.Task]; using defaults.
17:10:43,671 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition]; using defaults.
17:10:43,781 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.ExceptionHandler]; using defaults.
17:10:43,781 WARN [EhCacheProvider] Could not find configuration [org.jbpm.module.def.ModuleDefinition]; using defaults.
17:10:44,062 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Action]; using defaults.
17:10:44,093 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Event]; using defaults.
17:10:44,140 WARN [EhCacheProvider] Could not find configuration [org.jbpm.context.def.VariableAccess]; using defaults.
17:10:44,203 WARN [EhCacheProvider] Could not find configuration [org.jbpm.graph.def.Transition]; using defaults.
17:10:44,343 WARN [EhCacheProvider] Could not find configuration [org.jbpm.taskmgmt.def.TaskController]; using defaults.
17:10:44,859 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
17:10:44,859 INFO [SessionFactoryImpl] Checking 0 named queries
17:10:44,859 INFO [JbpmService] binding JbpmSessionFactory 'java:/jbpm/JbpmSessionFactory' into JNDI...
17:10:44,859 DEBUG [JbpmService] Started jboss.jbpm:name=DefaultJbpm,service=JbpmService
17:10:44,953 INFO [JbpmQueue] Bound to JNDI name: queue/JbpmQueue
17:10:45,031 INFO [UILServerILService] JBossMQ UIL service available at : /0.0.0.0:8093
17:10:45,078 INFO [DLQ] Bound to JNDI name: queue/DLQ
17:10:45,265 INFO [ConnectionFactoryBindingService] Bound connection factory for resource adapter for ConnectionManager 'jboss.jca:name=JmsXA,service=ConnectionFactoryBinding to JNDI name 'java:JmsXA'
17:10:45,390 INFO [WrapperDataSourceService] Bound connection factory for resource adapter for ConnectionManager 'jboss.jca:name=MSSQLDS,service=DataSourceBinding to JNDI name 'java:MSSQLDS'
17:10:45,531 INFO [WrapperDataSourceService] Bound connection factory for resource adapter for ConnectionManager 'jboss.jca:name=MSSQLXADS,service=DataSourceBinding to JNDI name 'java:MSSQLXADS'
17:10:45,718 INFO [TomcatDeployer] deploy, ctxPath=/jbpm, warUrl=file:/E:/jboss-4.0.2/server/jbpm/tmp/deploy/tmp17520jbpm-exp.war/
17:10:45,968 INFO [FacesConfigurator] Reading standard config org/apache/myfaces/resource/standard-faces-config.xml
17:10:46,375 INFO [FacesConfigurator] Reading config jar:file:/C:/DOCUME~1/ADMINI~1/LOCALS~1/Temp/myfaces17521.jar!/META-INF/faces-config.xml
17:10:46,515 INFO [FacesConfigurator] Reading config jar:file:/C:/DOCUME~1/ADMINI~1/LOCALS~1/Temp/myfaces17522.jar!/META-INF/faces-config.xml
17:10:46,578 INFO [FacesConfigurator] Reading config /WEB-INF/faces-config.xml
17:10:46,656 DEBUG [ApplicationFactory] New ApplicationFactory instance created
17:10:47,015 INFO [StartupServletContextListener] ServletContext 'E:\jboss-4.0.2\server\jbpm\.\tmp\deploy\tmp17520jbpm-exp.war\' initialized.
17:10:47,046 DEBUG [Scheduler] starting the scheduler
17:10:47,046 DEBUG [JbpmSessionFactory] fetching JbpmSessionFactory from 'java:/jbpm/JbpmSessionFactory'
17:10:47,125 DEBUG [SchedulerThread] checking for timers
17:10:47,296 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=file:/E:/jboss-4.0.2/server/jbpm/deploy/jmx-console.war/
17:10:47,421 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
17:10:47,421 ERROR [JDBCExceptionReporter] Table not found: JBPM_TIMER in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where timer0_.EXCEPTION_ is null order by timer0_.DUEDATE_ asc]
17:10:47,421 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
17:10:47,421 ERROR [JDBCExceptionReporter] Table not found: JBPM_TIMER in statement [select timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where timer0_.EXCEPTION_ is null order by timer0_.DUEDATE_ asc]
17:10:47,437 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarException: could not execute query using iterate
17:10:47,437 ERROR [JbpmSession] java.lang.NullPointerException
17:10:47,437 ERROR [JDBCTransaction] Could not toggle autocommit
org.hibernate.HibernateException: Session is closed
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:103)
at org.hibernate.transaction.JDBCTransaction.toggleAutoCommit(JDBCTransaction.java:158)
at org.hibernate.transaction.JDBCTransaction.rollback(JDBCTransaction.java:148)
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
it seemed missed table jbpm_timer, but i checked mssql ,and i can find jbpm_timer in mssql,
the jbpm version i use is jbpm-starters-kit-with-eclipse-3.0.
wish for you help.
