4 Replies Latest reply on Jan 26, 2006 12:08 PM by Alejandro Guizar

    change the websale to mssql, i  met some problems

    jan jan Newbie

      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.