12:42 a.m.
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&...]