<!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>