[jboss-user] [jBPM] - Why I can't run jbpm4.3 examples on oracle server?

[zhang june]

zhang june [http://community.jboss.org/people/june20100606] replied to the discussion

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

To view the discussion, visit: http://community.jboss.org/message/555099#555099

--------------------------------------------------------------
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
[http://community.jboss.org/message/555099#555099]

Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100730/97b4b9a3/attachment.html