JBoss Community

Why I can't run jbpm4.3 examples on oracle server?

reply from zhang june in jBPM - View the full discussion

Below is a part of the stack trace. Script was going to update the content of the oracle table. Where is the sql statement from?

 

10:08:36,203 FIN | [HibernateSessionResource] ----- beginning hibernate tx 5003359 --------------------------------------------------------
10:08:36,250 FIN | [SQL]
    select
        *
    from
        ( select
            propertyim0_.KEY_ as KEY1_2_,
            propertyim0_.VERSION_ as VERSION2_2_,
            propertyim0_.VALUE_ as VALUE3_2_
        from
            JBPM4_PROPERTY propertyim0_ )
    where
        rownum <= ?
10:08:36,500 FST | [StringType] returning 'db.version' as column: KEY1_2_
10:08:36,500 FST | [IntegerType] returning '0' as column: VERSION2_2_
10:08:36,500 FST | [StringType] returning '4.3' as column: VALUE3_2_
10:08:36,578 FIN | [SQL]
    select
        this_.KEY_ as KEY1_2_0_,
        this_.VERSION_ as VERSION2_2_0_,
        this_.VALUE_ as VALUE3_2_0_
    from
        JBPM4_PROPERTY this_
    where
        this_.KEY_=?
10:08:36,578 FST | [StringType] binding 'next.dbid' to parameter: 1
10:08:36,593 FST | [StringType] returning 'next.dbid' as column: KEY1_2_0_
10:08:36,593 FST | [IntegerType] returning '2' as column: VERSION2_2_0_
10:08:36,593 FST | [StringType] returning '20001' as column: VALUE3_2_0_
10:08:36,593 FIN | [SQL]
    select
        this_.KEY_ as KEY1_2_0_,
        this_.VERSION_ as VERSION2_2_0_,
        this_.VALUE_ as VALUE3_2_0_
    from
        JBPM4_PROPERTY this_
    where
        this_.KEY_=?
10:08:36,593 FST | [StringType] binding 'db.version' to parameter: 1
10:08:36,609 FST | [StringType] returning 'db.version' as column: KEY1_2_0_
10:08:36,609 INF | [CheckDbCmd] jBPM version info: library[4.3], schema[4.3]
10:08:36,609 FIN | [HibernateSessionResource] ----- committing hibernate tx 19439176 -------------------------------------------------------


***********************************deploymentId = repositoryService.createDeployment()
        .addResourceFromClasspath("org/jbpm/examples/java/process.jpdl.xml")
        .deploy();   *********************************************************************************************************************************
       
10:11:39,562 FIN | [HibernateSessionResource] ----- beginning hibernate tx 17087715 --------------------------------------------------------
10:11:40,000 FIN | [DatabaseDbidGenerator] last id -2 was consumed.  acquiring new block...
10:11:40,000 FIN | [HibernateSessionResource] ----- beginning hibernate tx 25916056 --------------------------------------------------------
10:11:40,281 FIN | [SQL]
    select
        propertyim0_.KEY_ as KEY1_2_,
        propertyim0_.VERSION_ as VERSION2_2_,
        propertyim0_.VALUE_ as VALUE3_2_
    from
        JBPM4_PROPERTY propertyim0_
    where
        propertyim0_.KEY_='next.dbid'
10:11:40,281 FST | [StringType] returning 'next.dbid' as column: KEY1_2_
10:11:40,281 FST | [IntegerType] returning '2' as column: VERSION2_2_
10:11:40,281 FST | [StringType] returning '20001' as column: VALUE3_2_
10:11:40,328 FIN | [SQL]
    update
        JBPM4_PROPERTY
    set
        VERSION_=?,
        VALUE_=?
    where
        KEY_=?
        and VERSION_=?
10:11:40,328 FST | [IntegerType] binding '3' to parameter: 1
10:11:40,328 FST | [StringType] binding '30001' to parameter: 2
10:11:40,328 FST | [StringType] binding 'next.dbid' to parameter: 3
10:11:40,328 FST | [IntegerType] binding '2' to parameter: 4
10:11:40,328 FIN | [HibernateSessionResource] ----- committing hibernate tx 25831799 -------------------------------------------------------
10:11:40,328 FIN | [DatabaseDbidGenerator] acquired new id block [20001-30000]
10:11:40,359 FIN | [SQL]
    select
        lob_.DBID_,
        lob_.DBVERSION_ as DBVERSION2_5_,
        lob_.BLOB_VALUE_ as BLOB3_5_
    from
        JBPM4_LOB lob_
    where
        lob_.DBID_=?
10:11:40,375 FST | [LongType] binding '20002' to parameter: 1
10:11:41,640 FIN | [SQL]
    insert
    into
        JBPM4_DEPLOYMENT
        (NAME_, TIMESTAMP_, STATE_, DBID_)
    values
        (?, ?, ?, ?)
10:11:41,640 FST | [TextType] binding null to parameter: 1
10:11:41,640 FST | [LongType] binding '0' to parameter: 2
10:11:41,640 FST | [StringType] binding 'active' to parameter: 3
10:11:41,640 FST | [LongType] binding '20001' to parameter: 4
10:11:41,656 WRN | [JDBCExceptionReporter] SQL Error: 904, SQLState: 42000
10:11:41,656 SEV | [JDBCExceptionReporter] ORA-00904: 无效列名

10:11:41,656 WRN | [JDBCExceptionReporter] SQL Error: 904, SQLState: 42000
10:11:41,656 SEV | [JDBCExceptionReporter] ORA-00904: 无效列名

Reply to this message by going to Community

Start a new discussion in jBPM at Community