2 Replies Latest reply on Mar 29, 2006 3:15 AM by Hannes Stillerich

    jbpm 3.1 MySql

    Srikanth Ramaswamy Newbie

      Hi

      I dowloaded jbpm-starter-kit 3.1 and jbpm 3.1 and i execute db mysql.create.sql in MySql 4.0

      I configure hibernate.cfg.xml in jbpm.sar (jbpm.sar.cfg.jar) and i replace datasouce "DefaultDataSource" instead of DefaultDS in jboss-service.xml under jbpm.sar\META-INF

       <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
      <property name="hibernate.connection.datasource">java:/DefaultDataSource</property>


      and i put new mysql datasource under deploy folder

      <datasources>
       <local-tx-datasource>
       <jndi-name>DefaultDataSource</jndi-name>
       <connection-url>jdbc:mysql://localhost:3306/jbpm3</connection-url>
       <driver-class>com.mysql.jdbc.Driver</driver-class>
       <user-name>root</user-name>
       <password>mysql</password>
       <connection-property name="autoReconnect">true</connection-property>
       </local-tx-datasource>
      
      </datasources>
      


      so when i run jbpm instance using run -c jbpm i am getting the below server console message and
      when i run http://localhost:8080/jbpm -- the userlist drop down is showing empty list it is not picking from MySql database. Please let me know what is wrong.

      18:39:02,055 INFO [Configuration] processing foreign key constraints
      18:39:02,368 INFO [DriverManagerConnectionProvider] Using Hibernate built-in connection pool (not for production use!)
      18:39:02,368 INFO [DriverManagerConnectionProvider] Hibernate connection pool size: 20
      18:39:02,368 INFO [DriverManagerConnectionProvider] autocommit mode: false
      18:39:02,399 INFO [DriverManagerConnectionProvider] using driver: com.mysql.jdbc.Driver at URL: jdbc:mysql://localhost:3306/jbpm3
      18:39:02,399 INFO [DriverManagerConnectionProvider] connection properties: {user=root, password=****}
      18:39:03,664 INFO [SettingsFactory] RDBMS: MySQL, version: 4.1.16-nt
      ect] Using dialect: org.hibernate.dialect.MySQLDialect
      sactionFactoryFactory] Using default transaction strategy (direct JDBC transactions)
      sactionManagerLookupFactory] No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional se
      recommended)
      ingsFactory] Automatic flush during beforeCompletion(): disabled
      ingsFactory] Automatic session close at end of transaction: disabled
      ingsFactory] JDBC batch size: 15
      ingsFactory] JDBC batch updates for versioned data: disabled
      ingsFactory] Scrollable result sets: enabled
      ingsFactory] JDBC3 getGeneratedKeys(): enabled
      ingsFactory] Connection release mode: null
      ingsFactory] Maximum outer join fetch depth: 2
      ingsFactory] Default batch fetch size: 1
      ingsFactory] Generate SQL with comments: disabled
      ingsFactory] Order SQL updates by primary key: disabled
      ingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
      ueryTranslatorFactory] Using ASTQueryTranslatorFactory
      ingsFactory] Query language substitutions: {}
      ingsFactory] Second-level cache: enabled
      ingsFactory] Query cache: disabled
      ingsFactory] Cache provider: org.hibernate.cache.EhCacheProvider
      ingsFactory] Optimize cache for minimal puts: disabled
      ingsFactory] Structured second-level cache entries: disabled
      ingsFactory] Statistics: disabled
      ingsFactory] Deleted entity synthetic identifier rollback: disabled
      ingsFactory] Default entity-mode: POJO
      ionFactoryImpl] building session factory
      cheProvider] Could not find configuration [org.jbpm.graph.def.Node]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.instantiation.Delegation]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.taskmgmt.def.Task]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.def.ExceptionHandler]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.module.def.ModuleDefinition]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.def.Action]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.def.Event]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.context.def.VariableAccess]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.def.Transition]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.taskmgmt.def.TaskController]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.taskmgmt.def.TaskMgmtDefinition.tasks]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.node.ProcessState.variableAccesses]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.events]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.taskmgmt.def.Swimlane.tasks]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.def.Node.leavingTransitions]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.taskmgmt.def.TaskController.variableAccesses]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.exceptionHandlers]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.node.Decision.decisionConditions]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.file.def.FileDefinition.processFiles]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.def.Transition.exceptionHandlers]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.actions]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.nodes]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.def.Node.arrivingTransitions]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.node.TaskNode.tasks]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.def.ProcessDefinition.definitions]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.def.Event.actions]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.taskmgmt.def.Task.events]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.def.Node.events]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.taskmgmt.def.TaskMgmtDefinition.swimlanes]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.def.SuperState.nodes]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.action.Script.variableAccesses]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.def.ExceptionHandler.actions]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.taskmgmt.def.Task.exceptionHandlers]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.def.Node.exceptionHandlers]; using defaults.
      cheProvider] Could not find configuration [org.jbpm.graph.def.Transition.events]; using defaults.
      ionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
      ionFactoryImpl] Checking 25 named queries
      rsistenceService] creating hibernate session
      rsistenceService] creating hibernate session
      rsistenceService] beginning hibernate transaction
      rsistenceService] beginning hibernate transaction
      Context] closing JbpmContext
      ices] closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@4aca27
      rsistenceService] committing hibernate transaction
      rsistenceService] closing hibernate session
      ices] closing service 'message': org.jbpm.msg.db.DbMessageService@f2f585
      andExecutorThread] waiting for more messages
      icNotifier] going to wait for (CMD_EXECUTOR, java.lang.Object@1a66c87)
      dulerThread] checking for timers
      Context] closing JbpmContext
      ices] closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@1f95673
      rsistenceService] committing hibernate transaction
      rsistenceService] closing hibernate session
      icNotifier] woke up
      ContextInfo] creating jbpm context with service factories '[message, scheduler, logging, persistence, authentication]'
      Context] creating JbpmContext
      rsistenceServiceFactory] creating persistence service
      rsistenceService] creating hibernate session
      rsistenceService] beginning hibernate transaction
      Context] closing JbpmContext
      ices] closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@14a8f44
      rsistenceService] committing hibernate transaction
      rsistenceService] closing hibernate session
      ices] closing service 'message': org.jbpm.msg.db.DbMessageService@3f377
      andExecutorThread] waiting for more messages
      icNotifier] going to wait for (CMD_EXECUTOR, java.lang.Object@1a66c87)
      ContextInfo] creating jbpm context with service factories '[message, scheduler, logging, persistence, authentication]'
      Context] creating JbpmContext
      rsistenceServiceFactory] creating persistence service
      rsistenceService] creating hibernate session
      rsistenceService] beginning hibernate transaction
      dulerThread] checking for timers
      Context] closing JbpmContext
      ices] closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@1fcb845
      rsistenceService] committing hibernate transaction
      rsistenceService] closing hibernate session
      icNotifier] woke up
      ContextInfo] creating jbpm context with service factories '[message, scheduler, logging, persistence, authentication]'
      Context] creating JbpmContext
      rsistenceServiceFactory] creating persistence service
      rsistenceService] creating hibernate session
      rsistenceService] beginning hibernate transaction
      Context] closing JbpmContext
      ices] closing service 'persistence': org.jbpm.persistence.db.DbPersistenceService@9036e
      rsistenceService] committing hibernate transaction
      rsistenceService] closing hibernate session
      ices] closing service 'message': org.jbpm.msg.db.DbMessageService@1c059f6
      andExecutorThread] waiting for more messages
      icNotifier] going to wait for (CMD_EXECUTOR, java.lang.Object@1a66c87)
      ContextInfo] creating jbpm context with service factories '[message, scheduler, logging, persistence, authentication]'
      Context] creating JbpmContext
      rsistenceServiceFactory] creating persistence service
      rsistenceService] creating hibernate session
      rsistenceService] beginning hibernate transaction
      dulerThread] checking for timers