jbpm 3.1 MySql
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
