[prev in list] [next in list] [prev in thread] [next in thread]
List: jboss-user
Subject: Re: [jboss-user] [jBPM] - Why I can't run jbpm4.3 examples on
From: zhang june <do-not-reply () jboss ! com>
Date: 2010-07-30 5:42:46
Message-ID: 108996463.222321280468644930.JavaMail.jive () clearspace02 ! app ! mwc ! hst ! phx2 ! redhat ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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]
[Attachment #5 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; \
margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: \
1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; \
-webkit-border-radius: 6px;"> <tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" \
style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: \
6px; -webkit-border-radius: 6px;"> <tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px \
solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; \
-moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; \
-webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; \
margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag \
-->
<!-- Email clients will render the images when the message is read so any \
image -->
<!-- must be made available on a public server, so that all recipients can \
load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: \
none; color: #E1E1E1">JBoss Community</a></h1> </td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; \
color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; \
-moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; \
-webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: \
17px; font-weight: normal;"> Why I can't run jbpm4.3 examples on oracle server?
</h3>
<span style="margin-bottom: 10px;">
reply from <a href="http://community.jboss.org/people/june20100606">zhang \
june</a> in <i>jBPM</i> - <a \
href="http://community.jboss.org/message/555099#555099">View the full discussion</a> \
</span> <hr style="margin: 20px 0; border: none; background-color: #dadada; height: \
1px;">
<div class="jive-rendered-content"><p>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? \
</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>10:08:36,203 \
FIN | [HibernateSessionResource] ----- beginning hibernate tx 5003359 \
--------------------------------------------------------<br/>10:08:36,250 FIN | [SQL] \
<br/>    select<br/>        * \
<br/>    from<br/>        ( \
select<br/>            \
propertyim0_.KEY_ as \
KEY1_2_,<br/>            \
propertyim0_.VERSION_ as \
VERSION2_2_,<br/>            \
propertyim0_.VALUE_ as VALUE3_2_ <br/>        \
from<br/>            \
JBPM4_PROPERTY propertyim0_ ) <br/>    \
where<br/>        rownum <= ?<br/>10:08:36,500 \
FST | [StringType] returning 'db.version' as column: KEY1_2_<br/>10:08:36,500 FST | \
[IntegerType] returning '0' as column: VERSION2_2_<br/>10:08:36,500 FST | \
[StringType] returning '4.3' as column: VALUE3_2_<br/>10:08:36,578 FIN | [SQL] \
<br/>    select<br/>        \
this_.KEY_ as KEY1_2_0_,<br/>        \
this_.VERSION_ as VERSION2_2_0_,<br/>        \
this_.VALUE_ as VALUE3_2_0_ <br/>    \
from<br/>        JBPM4_PROPERTY this_ \
<br/>    where<br/>        \
this_.KEY_=?<br/>10:08:36,578 FST | [StringType] binding 'next.dbid' to parameter: \
1<br/>10:08:36,593 FST | [StringType] returning 'next.dbid' as column: \
KEY1_2_0_<br/>10:08:36,593 FST | [IntegerType] returning '2' as column: \
VERSION2_2_0_<br/>10:08:36,593 FST | [StringType] returning '20001' as column: \
VALUE3_2_0_<br/>10:08:36,593 FIN | [SQL] <br/>    \
select<br/>        this_.KEY_ as \
KEY1_2_0_,<br/>        this_.VERSION_ as \
VERSION2_2_0_,<br/>        this_.VALUE_ as \
VALUE3_2_0_ <br/>    \
from<br/>        JBPM4_PROPERTY this_ \
<br/>    where<br/>        \
this_.KEY_=?<br/>10:08:36,593 FST | [StringType] binding 'db.version' to parameter: \
1<br/>10:08:36,609 FST | [StringType] returning 'db.version' as column: \
KEY1_2_0_<br/>10:08:36,609 INF | [CheckDbCmd] jBPM version info: library[4.3], \
schema[4.3]<br/>10:08:36,609 FIN | [HibernateSessionResource] ----- committing \
hibernate tx 19439176 \
-------------------------------------------------------</p><p><br/>***********************************deploymentId \
= repositoryService.createDeployment()<br/>        \
.addResourceFromClasspath("org/jbpm/examples/java/process.jpdl.xml")<br/>        \
.deploy();   \
************************************************************************************** \
*******************************************<br/>        \
<br/>10:11:39,562 FIN | [HibernateSessionResource] ----- beginning hibernate tx \
17087715 --------------------------------------------------------<br/>10:11:40,000 \
FIN | [DatabaseDbidGenerator] last id -2 was consumed.  acquiring new \
block...<br/>10:11:40,000 FIN | [HibernateSessionResource] ----- beginning hibernate \
tx 25916056 --------------------------------------------------------<br/>10:11:40,281 \
FIN | [SQL] <br/>    \
select<br/>        propertyim0_.KEY_ as \
KEY1_2_,<br/>        propertyim0_.VERSION_ as \
VERSION2_2_,<br/>        propertyim0_.VALUE_ as \
VALUE3_2_ <br/>    from<br/>        \
JBPM4_PROPERTY propertyim0_ <br/>    \
where<br/>        \
propertyim0_.KEY_='next.dbid'<br/>10:11:40,281 FST | [StringType] returning \
'next.dbid' as column: KEY1_2_<br/>10:11:40,281 FST | [IntegerType] returning '2' as \
column: VERSION2_2_<br/>10:11:40,281 FST | [StringType] returning '20001' as column: \
VALUE3_2_<br/>10:11:40,328 FIN | [SQL] <br/>    \
update<br/>        JBPM4_PROPERTY \
<br/>    set<br/>        \
VERSION_=?,<br/>        VALUE_=? \
<br/>    where<br/>        KEY_=? \
<br/>        and VERSION_=?<br/>10:11:40,328 FST | \
[IntegerType] binding '3' to parameter: 1<br/>10:11:40,328 FST | [StringType] binding \
'30001' to parameter: 2<br/>10:11:40,328 FST | [StringType] binding 'next.dbid' to \
parameter: 3<br/>10:11:40,328 FST | [IntegerType] binding '2' to parameter: \
4<br/>10:11:40,328 FIN | [HibernateSessionResource] ----- committing hibernate tx \
25831799 -------------------------------------------------------<br/>10:11:40,328 FIN \
| [DatabaseDbidGenerator] acquired new id block [20001-30000]<br/>10:11:40,359 FIN | \
[SQL] <br/>    select<br/>        \
lob_.DBID_,<br/>        lob_.DBVERSION_ as \
DBVERSION2_5_,<br/>        lob_.BLOB_VALUE_ as \
BLOB3_5_ <br/>    from<br/>        \
JBPM4_LOB lob_ <br/>    \
where<br/>        lob_.DBID_=?<br/>10:11:40,375 \
FST | [LongType] binding '20002' to parameter: 1<br/>10:11:41,640 FIN | [SQL] \
<br/>    insert <br/>    \
into<br/>        \
JBPM4_DEPLOYMENT<br/>        (NAME_, TIMESTAMP_, \
STATE_, DBID_) <br/>    \
values<br/>        (?, ?, ?, ?)<br/>10:11:41,640 \
FST | [TextType] binding null to parameter: 1<br/>10:11:41,640 FST | [LongType] \
binding '0' to parameter: 2<br/>10:11:41,640 FST | [StringType] binding 'active' to \
parameter: 3<br/>10:11:41,640 FST | [LongType] binding '20001' to parameter: \
4<br/>10:11:41,656 WRN | [JDBCExceptionReporter] SQL Error: 904, SQLState: \
42000<br/>10:11:41,656 SEV | [JDBCExceptionReporter] ORA-00904: \
效列名</p><p>10:11:41,656 WRN | [JDBCExceptionReporter] SQL Error: 904, SQLState: \
42000<br/>10:11:41,656 SEV | [JDBCExceptionReporter] ORA-00904: \
效列名</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a \
href="http://community.jboss.org/message/555099#555099">going to Community</a></p> \
<p style="margin: 0;">Start a new discussion in jBPM at <a \
href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic