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&...]