10 Replies Latest reply on May 26, 2015 8:49 AM by abhijithumbe

    HHH000262: Table not found: AuditTaskImpl

    manav

      I installed jBPM using "ant install.demo".  The installation appeared to work and I am able to start everything via "ant start.demo".  However, when I load the sample project into eclipse and run "com.sample.ProcessTest" as a JUnit test, I receive the following warnings.  (Table not found) Does anyone know what might be going on, or what I can try to do to discover what went wrong?


      SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".

      SLF4J: Defaulting to no-operation (NOP) logger implementation

      SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.

      May 18, 2015 10:40:40 AM org.hibernate.annotations.common.Version <clinit>

      INFO: HCANN000001: Hibernate Commons Annotations {4.0.2.Final}

      May 18, 2015 10:40:40 AM org.hibernate.Version logVersion

      INFO: HHH000412: Hibernate Core {4.2.17.Final}

      May 18, 2015 10:40:40 AM org.hibernate.cfg.Environment <clinit>

      INFO: HHH000206: hibernate.properties not found

      May 18, 2015 10:40:40 AM org.hibernate.cfg.Environment buildBytecodeProvider

      INFO: HHH000021: Bytecode provider name : javassist

      May 18, 2015 10:40:41 AM org.hibernate.cfg.Configuration addResource

      INFO: HHH000221: Reading mappings from resource: META-INF/JBPMorm.xml

      May 18, 2015 10:40:41 AM org.hibernate.cfg.Configuration addResource

      INFO: HHH000221: Reading mappings from resource: META-INF/Taskorm.xml

      May 18, 2015 10:40:41 AM org.hibernate.cfg.Configuration addResource

      INFO: HHH000221: Reading mappings from resource: META-INF/TaskAuditorm.xml

      May 18, 2015 10:40:41 AM org.hibernate.dialect.Dialect <init>

      INFO: HHH000400: Using dialect: org.hibernate.dialect.H2Dialect

      May 18, 2015 10:40:41 AM org.hibernate.engine.jdbc.internal.LobCreatorBuilder useContextualLobCreation

      INFO: HHH000423: Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4

      May 18, 2015 10:40:42 AM org.hibernate.engine.transaction.internal.TransactionFactoryInitiator initiateService

      INFO: HHH000268: Transaction strategy: org.hibernate.engine.transaction.internal.jta.CMTTransactionFactory

      May 18, 2015 10:40:42 AM org.hibernate.hql.internal.ast.ASTQueryTranslatorFactory <init>

      INFO: HHH000397: Using ASTQueryTranslatorFactory

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

      INFO: HHH000228: Running hbm2ddl schema update

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

      INFO: HHH000102: Fetching database metadata

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

      INFO: HHH000396: Updating schema

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Attachment

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: AuditTaskImpl

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: BAMTaskSummary

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: BooleanExpression

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Content

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: ContextMappingInfo

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: CorrelationKeyInfo

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: CorrelationPropertyInfo

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Deadline

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Delegation_delegates

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Escalation

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: EventTypes

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: I18NText

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: NodeInstanceLog

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Notification

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Notification_BAs

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Notification_Recipients

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Notification_email_header

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: OrganizationalEntity

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: PeopleAssignments_BAs

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: PeopleAssignments_ExclOwners

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: PeopleAssignments_PotOwners

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: PeopleAssignments_Recipients

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: PeopleAssignments_Stakeholders

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: ProcessInstanceInfo

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: ProcessInstanceLog

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Reassignment

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Reassignment_potentialOwners

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: SessionInfo

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Task

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: TaskEvent

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: VariableInstanceLog

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: WorkItemInfo

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: email_header

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: task_comment

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Attachment

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: AuditTaskImpl

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: BAMTaskSummary

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: BooleanExpression

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Content

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: ContextMappingInfo

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: CorrelationKeyInfo

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: CorrelationPropertyInfo

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Deadline

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Delegation_delegates

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Escalation

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: EventTypes

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: I18NText

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: NodeInstanceLog

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Notification

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Notification_BAs

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Notification_Recipients

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Notification_email_header

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: OrganizationalEntity

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: PeopleAssignments_BAs

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: PeopleAssignments_ExclOwners

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: PeopleAssignments_PotOwners

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: PeopleAssignments_Recipients

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: PeopleAssignments_Stakeholders

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: ProcessInstanceInfo

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: ProcessInstanceLog

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Reassignment

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Reassignment_potentialOwners

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: SessionInfo

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Task

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: TaskEvent

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: VariableInstanceLog

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: WorkItemInfo

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: email_header

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: task_comment

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Attachment

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: AuditTaskImpl

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: BAMTaskSummary

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: BooleanExpression

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Content

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: ContextMappingInfo

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: CorrelationKeyInfo

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: CorrelationPropertyInfo

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Deadline

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Delegation_delegates

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Escalation

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: EventTypes

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: I18NText

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: NodeInstanceLog

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Notification

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Notification_BAs

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Notification_Recipients

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Notification_email_header

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: OrganizationalEntity

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: PeopleAssignments_BAs

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: PeopleAssignments_ExclOwners

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: PeopleAssignments_PotOwners

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: PeopleAssignments_Recipients

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: PeopleAssignments_Stakeholders

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: ProcessInstanceInfo

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: ProcessInstanceLog

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Reassignment

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Reassignment_potentialOwners

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: SessionInfo

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: Task

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: TaskEvent

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: VariableInstanceLog

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: WorkItemInfo

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: email_header

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.DatabaseMetadata getTableMetadata

      INFO: HHH000262: Table not found: task_comment

      May 18, 2015 10:40:42 AM org.hibernate.tool.hbm2ddl.SchemaUpdate execute

      INFO: HHH000232: Schema update complete

      SLF4J: Failed to load class "org.slf4j.impl.StaticMDCBinder".

      SLF4J: Defaulting to no-operation MDCAdapter implementation.

      SLF4J: See http://www.slf4j.org/codes.html#no_static_mdc_binder for further details.

      Process started ...

      'krisv' completing task Self Evaluation: Please perform a self-evalutation.

      'john' completing task PM Evaluation: You need to evaluate krisv.

      'mary' completing task HR Evaluation: You need to evaluate krisv.

      Process instance completed

        • 1. Re: HHH000262: Table not found: AuditTaskImpl
          abhijithumbe

          These messages are logged because these tables are not exist in Database, and its expected behavior.

          • 2. Re: HHH000262: Table not found: AuditTaskImpl
            manav

            Thank you Abhijit.

             

            But when I start my demo, I can see below logs in server.log.

            2015-05-18 11:59:21,518 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 61) HHH000261: Table found: JBPM-DB.PUBLIC.NOTIFICATION_BAS

            2015-05-18 11:59:21,520 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 61) HHH000037: Columns: [task_id, entity_id]

            2015-05-18 11:59:21,521 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 61) HHH000108: Foreign keys: [fk_fc0uuy76t2bvxaxqysoo8xts7, fk_mfbsnbrhth4rjhqc2ud338s4i]

            2015-05-18 11:59:21,523 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 61) HHH000126: Indexes: [fk_fc0uuy76t2bvxaxqysoo8xts7_index_7, fk_mfbsnbrhth4rjhqc2ud338s4i_index_7]

            2015-05-18 11:59:21,530 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 61) HHH000261: Table found: JBPM-DB.PUBLIC.NOTIFICATION_RECIPIENTS

            2015-05-18 11:59:21,532 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 61) HHH000037: Columns: [task_id, entity_id]

            2015-05-18 11:59:21,533 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 61) HHH000108: Foreign keys: [fk_blf9jsrumtrthdaqnpwxt25eu, fk_3l244pj8sh78vtn9imaymrg47]

            2015-05-18 11:59:21,535 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 61) HHH000126: Indexes: [fk_3l244pj8sh78vtn9imaymrg47_index_1, fk_blf9jsrumtrthdaqnpwxt25eu_index_1]

            2015-05-18 11:59:21,542 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 61) HHH000261: Table found: JBPM-DB.PUBLIC.NOTIFICATION_EMAIL_HEADER

            2015-05-18 11:59:21,545 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 61) HHH000037: Columns: [emailheaders_id, notification_id, mapkey]

            2015-05-18 11:59:21,548 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 61) HHH000108: Foreign keys: [fk_eth4nvxn21fk1vnju85vkjrai, fk_ptaka5kost68h7l3wflv7w6y8]

            2015-05-18 11:59:21,551 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (ServerService Thread Pool -- 61) HHH000126: Indexes: [primary_key_f5, uk_ptaka5kost68h7l3wflv7w6y8_index_f].

             

             

            Also I can see table in H2 database. jdbc:h2:tcp://localhost/~/jbpm-db

             

            So I am confuse why eclipse is not able to access these tables?

            Can you please help me on this.

            • 3. Re: HHH000262: Table not found: AuditTaskImpl
              abhijithumbe

              Confirm eclipse is using same database(jbpm-db). If you want to use same database for both server and for code running inside IDE then you can use external DB's(mysql,Oracle.)

              1 of 1 people found this helpful
              • 4. Re: HHH000262: Table not found: AuditTaskImpl
                manav

                can you please where can i check if eclipse is using same database(jbpm-db).?

                • 5. Re: HHH000262: Table not found: AuditTaskImpl
                  abhijithumbe

                  It depends on your JUnit test case. are you using JbpmJUnitBaseTestCase class ?  If yes then it has hardcoded DB configuration:

                  ~~~~

                     protected PoolingDataSource setupPoolingDataSource() {

                          PoolingDataSource pds = new PoolingDataSource();

                          pds.setUniqueName("jdbc/jbpm-ds");

                          pds.setClassName("bitronix.tm.resource.jdbc.lrc.LrcXADataSource");

                          pds.setMaxPoolSize(5);

                          pds.setAllowLocalTransactions(true);

                          pds.getDriverProperties().put("user", "sa");

                          pds.getDriverProperties().put("password", "");

                          pds.getDriverProperties().put("url", "jdbc:h2:mem:jbpm-db;MVCC=true");

                          pds.getDriverProperties().put("driverClassName", "org.h2.Driver");

                          pds.init();

                          return pds;

                      }

                  ~~~~~

                  Can you share code of your test case ?

                  • 6. Re: HHH000262: Table not found: AuditTaskImpl
                    manav

                    package com.sample;

                     

                     

                    import java.util.List;

                     

                     

                    import org.jbpm.test.JbpmJUnitBaseTestCase;

                    import org.junit.Test;

                    import org.kie.api.runtime.KieSession;

                    import org.kie.api.runtime.manager.RuntimeEngine;

                    import org.kie.api.runtime.manager.RuntimeManager;

                    import org.kie.api.runtime.process.ProcessInstance;

                    import org.kie.api.task.TaskService;

                    import org.kie.api.task.model.TaskSummary;

                     

                     

                    /**

                    * This is a sample file to launch a process.

                    */

                    public class ProcessTest extends JbpmJUnitBaseTestCase {

                     

                     

                      @Test

                      public void testProcess() {

                      RuntimeManager manager = createRuntimeManager("sample.bpmn");

                      RuntimeEngine engine = getRuntimeEngine(null);

                      KieSession ksession = engine.getKieSession();

                      TaskService taskService = engine.getTaskService();

                     

                      ProcessInstance processInstance = ksession.startProcess("com.sample.bpmn.hello");

                     

                     

                      assertProcessInstanceActive(processInstance.getId(), ksession);

                      assertNodeTriggered(processInstance.getId(), "Task 1");

                     

                      // let john execute Task 1

                      List<TaskSummary> list = taskService.getTasksAssignedAsPotentialOwner("john", "en-UK");

                      TaskSummary task = list.get(0);

                      System.out.println("John is executing task " + task.getName());

                      taskService.start(task.getId(), "john");

                      taskService.complete(task.getId(), "john", null);

                     

                     

                      assertNodeTriggered(processInstance.getId(), "Task 2");

                     

                      // let mary execute Task 2

                      list = taskService.getTasksAssignedAsPotentialOwner("mary", "en-UK");

                      task = list.get(0);

                      System.out.println("Mary is executing task " + task.getName());

                      taskService.start(task.getId(), "mary");

                      taskService.complete(task.getId(), "mary", null);

                     

                     

                      assertProcessInstanceCompleted(processInstance.getId(), ksession);

                     

                      manager.disposeRuntimeEngine(engine);

                      manager.close();

                      }

                     

                      public ProcessTest() {

                      super(true, true);

                      }

                     

                     

                    }

                    • 7. Re: HHH000262: Table not found: AuditTaskImpl
                      manav

                      Hi Abhijit,

                       

                      Can you please tell me how can i use Local H2 db for testing?

                      • 8. Re: HHH000262: Table not found: AuditTaskImpl
                        abhijithumbe

                        Can you take a look at Features link, it may help you in using same DB.

                        • 9. Re: HHH000262: Table not found: AuditTaskImpl
                          tamachan

                          I'm also facing this problem... been trying to solve it for days now.

                           

                          Abhijit Humbe, you mentioned that its hardcoded in the JUnit test case? Is there any way I can change that? I'm also using MYSQL and not H2 for my database.

                          • 10. Re: HHH000262: Table not found: AuditTaskImpl
                            abhijithumbe

                            Hi,

                            I dont think we can modify JbpmJUnitBaseTestCase file without rebuilding jar file. You can write your own jBPM test case based on JbpmJUnitBaseTestCase.java which  will use MySql database.