Below is the debug information that calls the persistencesessionFactory.OpenPersistencesession (), from here we can learn from: 1) What is the table structure of JBPM, see how HBM file can be 2) JBPM how to use Hibernate, such as What is the optimizer, what connection pool is used, etc.
15: 11: 33,653 DEBUG HibernateSessionFactory: creating the hibernate session factory15: 11: 33,754 INFO Environment: Hibernate 2.1.715: 11: 33,774 INFO Environment: hibernate.properties not found15: 11: 33,804 INFO Environment: using CGLIB reflection optimizer15: 11: 33,814 INFO Environment: using JDK 1.4 java.sql.Timestamp handling15: 11: 33,864 INFO Configuration: Mapping resource: org / jbpm / persistence / hibernate / SequenceBlock.hbm.xml15: 11: 34,905 INFO Binder: Mapping class: org.jbpm. persistence.hibernate.SequenceBlock -> JBPM_SEQUENCEBLOCK15: 11: 35,476 INFO Configuration: Mapping resource: org / jbpm / model / definition / impl / ActionImpl.hbm.xml15: 11: 35,596 INFO Binder: Mapping class: org.jbpm.model.definition .impl.ActionImpl -> JBPM_ACTION15: 11: 35,807 INFO Configuration: Mapping resource: org / jbpm / model / definition / impl / DefinitionImpl.hbm.xml15: 11: 36,007 INFO Binder: Mapping class: org.jbpm.model.definition. Impl.definitionImpl -> JBPM_DEFINITION15: 11: 36, 257 Info Configuration: mapp ing resource: org / jbpm / model / definition / impl / NodeImpl.hbm.xml15: 11: 36,397 INFO Binder: Mapping class: org.jbpm.model.definition.impl.NodeImpl -> JBPM_NODE15: 11: 36,598 INFO Binder: Mapping subclass: org.jbpm.model.definition.impl.StateImpl -> JBPM_NODE15: 11: 36,628 INFO Binder: Mapping subclass: org.jbpm.model.definition.impl.StartStateImpl -> JBPM_NODE15: 11: 36,628 INFO Binder: Mapping subclass: org.jbpm.model.definition.impl.EndStateImpl -> JBPM_NODE15: 11: 36,658 INFO Binder: Mapping subclass: org.jbpm.model.definition.impl.ProcessStateImpl -> JBPM_NODE15: 11: 36,678 INFO Binder: Mapping subclass: org. JBPM.Model.definition.impl.milestoneImpl ->
JBPM_NODE15: 11: 36,708 INFO Binder: Mapping subclass: org.jbpm.model.definition.impl.DecisionImpl -> JBPM_NODE15: 11: 36,728 INFO Binder: Mapping subclass: org.jbpm.model.definition.impl.ForkImpl -> JBPM_NODE15: 11: 36,748 INFO Binder: Mapping subclass: org.jbpm.model.definition.impl.JoinImpl -> JBPM_NODE15: 11: 36,758 INFO Configuration: Mapping resource: org / jbpm / model / definition / impl / TransitionImpl.hbm.xml15: 11 : 36,938 INFO Binder: Mapping class: org.jbpm.model.definition.impl.TransitionImpl -> JBPM_TRANSITION15: 11: 36,958 INFO Configuration: Mapping resource: org / jbpm / model / definition / impl / SwimlaneImpl.hbm.xml15: 11: 37,068 INFO Binder: Mapping class: org.jbpm.model.definition.impl.SwimlaneImpl -> JBPM_SWIMLANE15: 11: 37,068 INFO Configuration: Mapping resource: org / jbpm / model / definition / impl / TypeImpl.hbm.xml15: 11: 37,158 Info Binder: mapping class: org.jbpm.model.definition.impl.typeImpl -> jbpm_type15: 11: 37,168 info configuration: mapping resource: ORG / JBPM / MODEL / Definition /impl/VariableImpl.hbm.xml15:11:37,229 INFO Binder: Mapping class: org.jbpm.model.definition.impl.VariableImpl -> JBPM_VARIABLE15: 11: 37,229 INFO Configuration: Mapping resource: org / jbpm / model / definition / impl / DelegationImpl.hbm.xml15: 11: 37,279 INFO Binder: Mapping class: org.jbpm.model.definition.impl.DelegationImpl -> JBPM_DELEGATION15: 11: 37,299 INFO Configuration: Mapping resource: org / jbpm / model / definition / impl /FILEIMPL.HBM.XML15:11:37,379 Info Binder: mapping class: org.jbpm.model.definition.impl.fileImpl ->
JBPM_FILE15: 11: 37,409 INFO Configuration: Mapping resource: org / jbpm / model / execution / impl / ProcessInstanceImpl.hbm.xml15: 11: 37,509 INFO Binder: Mapping class: org.jbpm.model.execution.impl.ProcessInstanceImpl -> JBPM_PROCESSINSTANCE15 : 11: 37,589 INFO Configuration: Mapping resource: org / jbpm / model / execution / impl / TokenImpl.hbm.xml15: 11: 37,699 INFO Binder: Mapping class: org.jbpm.model.execution.impl.TokenImpl -> JBPM_TOKEN15: 11: 37,759 INFO Configuration: Mapping resource: org / jbpm / model / execution / impl / VariableInstanceImpl.hbm.xml15: 11: 37,900 INFO Binder: Mapping class: org.jbpm.model.execution.impl.VariableInstanceImpl -> JBPM_VARIABLEINSTANCE15: 11 : 37,980 INFO Configuration: Mapping resource: org / jbpm / model / log / impl / InvocationLogImpl.hbm.xml15: 11: 38,090 INFO Binder: Mapping class: org.jbpm.model.log.impl.InvocationLogImpl -> JBPM_INVOKELOG15: 11: 38, 130 Info Configuration: mapping resource: ORG / JBPM / MODEL / LOG / IMPL / EXECUTIONLOGIMPL.HBM.XML15: 11: 38, 290 Info Binder: mapping class: org.jbpm.model.log.impl.ExecutionLogImpl -> JBPM_EXELOG15: 11: 38,320 INFO Binder: Mapping subclass: org.jbpm.model.log.impl.VariableCreationLogImpl -> JBPM_EXELOG15: 11: 38,320 INFO Binder: Mapping subclass: org.jbpm.model.log.impl.VariableUpdateLogImpl -> JBPM_EXELOG15: 11: 38,340 INFO Binder: Mapping subclass: org.jbpm.model.log.impl.ActionLogImpl -> JBPM_EXELOG15: 11: 38,350 INFO Binder: Mapping subclass: org. jbpm.model.log.impl.StateLogImpl -> JBPM_EXELOG15: 11: 38,360 INFO Binder: Mapping subclass: org.jbpm.model.log.impl.EndOfTokenLogImpl -> JBPM_EXELOG15: 11: 38,380 INFO Binder: Mapping subclass: org.jbpm. MODEL.LOG.IMPL.MESSAGELOGIMPL ->
JBPM_EXELOG15: 11: 38,410 INFO Binder: Mapping subclass: org.jbpm.model.log.impl.SubTokenLogImpl -> JBPM_EXELOG15: 11: 38,440 INFO Configuration: Mapping resource: org / jbpm / model / scheduler / impl / JobImpl.hbm.xml15 : 11: 38,561 INFO Binder: Mapping class: org.jbpm.model.scheduler.impl.JobImpl -> JBPM_JOB15: 11: 38,571 INFO Configuration: processing one-to-many association mappings15: 11: 38,581 INFO Binder: Mapping collection: org .jbpm.model.definition.impl.DefinitionImpl.actions -> JBPM_ACTION15: 11: 38,581 INFO Binder: Mapping collection: org.jbpm.model.definition.impl.DefinitionImpl.swimlanes -> JBPM_SWIMLANE15: 11: 38,591 INFO Binder: Mapping collection : org.jbpm.model.definition.impl.DefinitionImpl.types -> JBPM_TYPE15: 11: 38,591 INFO Binder: Mapping collection: org.jbpm.model.definition.impl.DefinitionImpl.nodes -> JBPM_NODE15: 11: 38,591 INFO Binder: Mapping collection: org.jbpm.model.definition.impl.definitionImpl.variables -> jbpm_variable15: 11: 38,601 Info Binder: mapping colle ction: org.jbpm.model.definition.impl.NodeImpl.actions -> JBPM_ACTION15: 11: 38,601 INFO Binder: Mapping collection: org.jbpm.model.definition.impl.NodeImpl.leavingTransitions -> JBPM_TRANSITION15: 11: 38,601 INFO Binder : Mapping collection: org.jbpm.model.definition.impl.TransitionImpl.actions -> JBPM_ACTION15: 11: 38,611 INFO Binder: Mapping collection: org.jbpm.model.definition.impl.TypeImpl.variables -> JBPM_VARIABLE15: 11: 38,611 INFO Binder: Mapping collection: org.jbpm.model.execution.impl.TokenImpl.children -> JBPM_TOKEN15: 11: 38,611 INFO Binder: Mapping collection: org.jbpm.model.execution.impl.TokenImpl.variableInstances ->
JBPM_VARIABLEINSTANCE15: 11: 38,621 INFO Binder: Mapping collection: org.jbpm.model.execution.impl.TokenImpl.invocationLogs -> JBPM_INVOKELOG15: 11: 38,621 INFO Binder: Mapping collection: org.jbpm.model.execution.impl.VariableInstanceImpl.updateLogs -> JBPM_EXELOG15: 11: 38,621 INFO Binder: Mapping collection: org.jbpm.model.log.impl.InvocationLogImpl.executionLogs -> JBPM_EXELOG15: 11: 38,621 INFO Configuration: processing one-to-one association property references15: 11: 38,621 INFO Configuration: processing foreign key constraints15: 11: 38,861 INFO dialect: Using dialect: net.sf.hibernate.dialect.HSQLDialect15: 11: 38,941 INFO SettingsFactory: Use outer join fetching: true15: 11: 38,961 INFO DriverManagerConnectionProvider: Using Hibernate built-in connection pool (not for production use!) 15: 11: 38,971 INFO DriverManagerConnectionProvider: Hibernate connection pool size: 2015: 11: 39,011 INFO DriverManagerConnectionProvider: using driver: org.hsqldb.jdbcDriver at URL: jdbc: hsqldb : .15: 11: 39,011 Info DriverManagerConnectionProvider: Connection Properties: {user = sa, password =
} 15: 11: 39,071 INFO TransactionManagerLookupFactory: No TransactionManagerLookup configured (in JTA environment, use of process level read-write cache is not recommended) 15: 11: 40,834 INFO SettingsFactory: Use scrollable result sets: true15: 11: 40,844 INFO SettingsFactory: Use JDBC3 getGeneratedKeys (): false15: 11: 40,854 INFO SettingsFactory: Optimize cache for minimal puts: false15: 11: 40,864 INFO SettingsFactory: Query language substitutions: {} 15: 11: 40,864 INFO SettingsFactory: cache provider: net.sf.hibernate .cache.EhCacheProvider15: 11: 40,884 INFO Configuration: instantiating and configuring caches15: 11: 41,685 INFO SessionFactoryImpl: building session factory15: 11: 42,566 INFO ReflectHelper: reflection optimizer disabled for: org.jbpm.model.definition.impl.SwimlaneImpl, BulkBeanException : Cannot Find Specified Property (Property SetDefinition) 15: 11: 42,646 Info ReflectHelper: Reflection Optimizer Disabled for: Org.jbpm.Model.log.Impl.EndoftOkenLogimpl, Bulkbeanexceptio n: Can not find specified property (property setToken) 15: 11: 42,686 INFO ReflectHelper: reflection optimizer disabled for: org.jbpm.model.execution.impl.ProcessInstanceImpl, BulkBeanException: Can not find specified property (property setDefinition) 15: 11: 42,767 INFO ReflectHelper: reflection optimizer disabled for: org.jbpm.model.definition.impl.StateImpl, BulkBeanException: Can not find specified property (property setDefinition) 15: 11: 42,837 INFO ReflectHelper: reflection optimizer disabled for: org.jbpm.model.execution . IMPL.VARIABLEINSTANCEIMPL, BULKBEANEXCEINSTANCEIMPL, BULKBEANEXCEPTION: Cannot Find Specified Property (Property Setty) 15: 11: 42,917 Info ReflectHelper: Reflection Optimizer Disabled for:
org.jbpm.model.definition.impl.ForkImpl, BulkBeanException: Can not find specified property (property setCorrespondingJoin) 15: 11: 43,087 INFO ReflectHelper: reflection optimizer disabled for: org.jbpm.model.execution.impl.TokenImpl, BulkBeanException: Can not find specified property (property setProcessInstance) 15: 11: 43,297 INFO ReflectHelper: reflection optimizer disabled for: org.jbpm.model.definition.impl.StartStateImpl, BulkBeanException: Can not find specified property (property setDefinition) 15: 11: 43,438 INFO ReflectHelper: reflection optimizer disabled for: org.jbpm.model.log.impl.ActionLogImpl, BulkBeanException: Can not find specified property (property setAction) 15: 11: 43,588 INFO ReflectHelper: reflection optimizer disabled for: org.jbpm.model.definition.impl. DefinitionImpl, BulkBeanException: Can not find specified property (property setDefinition) 15: 11: 43,638 INFO ReflectHelper: reflection optimizer disabled for: org.jbpm.model.definition.impl.DelegationImpl, BulkBeanEx ception: Can not find specified property (property setDefinition) 15: 11: 43,758 INFO ReflectHelper: reflection optimizer disabled for: org.jbpm.model.definition.impl.JoinImpl, BulkBeanException: Can not find specified property (property setDefinition) 15: 11: 43,808 INFO ReflectHelper: reflection optimizer disabled for: org.jbpm.model.definition.impl.DecisionImpl, BulkBeanException: Can not find specified property (property setDefinition) 15: 11: 43,878 INFO ReflectHelper: reflection optimizer disabled for: org.jbpm.model.definition . IMPL.ProcessStateImpl, BulkbeaneXception: Cannot Find Specified Property (Property SetDefinition) 15: 11: 43,918 Info ReflectHelper: Reflection Optimizer Disabled for:
org.jbpm.model.log.impl.InvocationLogImpl, BulkBeanException: Can not find specified property (property setToken) 15: 11: 44,018 INFO ReflectHelper: reflection optimizer disabled for: org.jbpm.model.definition.impl.TransitionImpl, BulkBeanException: Can not find specified property (property setDefinition) 15: 11: 44,068 INFO ReflectHelper: reflection optimizer disabled for: org.jbpm.model.definition.impl.NodeImpl, BulkBeanException: Can not find specified property (property setDefinition) 15: 11: 44,129 INFO ReflectHelper: reflection optimizer disabled for: org.jbpm.model.definition.impl.EndStateImpl, BulkBeanException: Can not find specified property (property setDefinition) 15: 11: 44,259 INFO ReflectHelper: reflection optimizer disabled for: org.jbpm.model.definition.impl. MilestoneImpl, BulkBeanException: Can not find specified property (property setDefinition) 15: 11: 44,289 INFO ReflectHelper: reflection optimizer disabled for: org.jbpm.model.definition.impl.ActionImpl, BulkBeanException: C annot find specified property (property setElement) 15: 11: 44,319 INFO ReflectHelper: reflection optimizer disabled for: org.jbpm.model.definition.impl.TypeImpl, BulkBeanException: Can not find specified property (property setDefinition) 15: 11: 44,369 INFO ReflectHelper : reflection optimizer disabled for: org.jbpm.model.log.impl.StateLogImpl, BulkBeanException: Can not find specified property (property setPrevious) 15: 11: 46,021 INFO SessionFactoryObjectFactory: not binding factory to JNDI, no JNDI name configured15: 11: 46,302 INFO HibernateSessionFactory: no JBPM_ tables in the database, creating the tables for you ... 15: 11: 46,322 INFO dialect: Using dialect: net.sf.hibernate.dialect.HSQLDialect15: 11: 46,332 INFO Configuration:
processing one-to-many association mappings15: 11: 46,332 INFO Configuration: processing one-to-one association property references15: 11: 46,342 INFO Configuration: processing foreign key constraints15: 11: 46,352 INFO Configuration: processing one-to-many association mappings15 : 11: 46,352 INFO Configuration: processing one-to-one association property references15: 11: 46,352 INFO Configuration: processing foreign key constraints15: 11: 46,362 INFO SchemaExport: Running hbm2ddl schema export15: 11: 46,372 INFO SchemaExport: exporting generated schema to database15 : 11: 46,372 INFO DriverManagerConnectionProvider: Using Hibernate built-in connection pool (not for production use!) 15: 11: 46,372 INFO DriverManagerConnectionProvider: Hibernate connection pool size: 2015: 11: 46,372 INFO DriverManagerConnectionProvider: using driver: org.hsqldb.jdbcDriver AT URL: JDBC: HSQLDB: .15: 11: 46,372 Info DriverManagerConnectionProvider: Connection Properties: {user = sa, password =} 15: 11: 46,582 Info SchemaExport: schema export complete15: 11: 46,602 INFO DriverManagerConnectionProvider: cleaning up connection pool: jdbc: hsqldb: .15: 11: 46,602 DEBUG HibernateSessionFactory: created the JBPM_ database tables successfully15: 11: 46,612 DEBUG HibernateSessionFactory: created the hibernate session factory15: 11 : 46,612 DEBUG JbpmConfiguration: for key 'jbpm.persistence.session.factory', an object of type 'org.jbpm.persistence.hibernate.HibernateSessionFactory' was instantiated15: 11: 46,632 INFO Configuration: Mapping resource: org / jbpm / persistence / Hibernate / sequenceblock.hbm.xml15: 11: 46,742 info binder: mapping class: org.jbpm.persistence.hibernate.sequenceBlock ->
JBPM_SEQUENCEBLOCK15: 11: 46,742 INFO Configuration: processing one-to-many association mappings15: 11: 46,752 INFO Configuration: processing one-to-one association property references15: 11: 46,752 INFO Configuration: processing foreign key constraints15: 11: 46,752 INFO Dialect: Using dialect: net.sf.hibernate.dialect.HSQLDialect15: 11: 46,762 INFO SettingsFactory: use outer join fetching: true15: 11: 46,762 INFO DriverManagerConnectionProvider: Using Hibernate built-in connection pool (! not for production use) 15:11: 46,762 INFO DriverManagerConnectionProvider: Hibernate connection pool size: 2015: 11: 46,762 INFO DriverManagerConnectionProvider: using driver: org.hsqldb.jdbcDriver at URL: jdbc: hsqldb: .15: 11: 46,772 INFO DriverManagerConnectionProvider: connection properties: {user = sa, password =
