nshimiye (1) [Avatar] Offline
#1
I'm tying to use ORA_ROWSCN in Oracle database 10g to implement Optimistic concurent.

I get this error :

ERROR org.hibernate.util.JDBCExceptionReporter - ORA-00904: "NAU3_"."ORA_ROWSCN" : identificateur non valide


My .hbm
<id name="seqCaln" type="long">
<column name="SEQ_CALN" precision="10" scale="0" />
<generator class="sequence">
<param name="sequence">toto</param>
</generator>
</id>

<version column="ORA_ROWSCN" name="versionOra" generated="always" insert="false" unsaved-value="negative" />

<property name="ddCaln" type="java.sql.Timestamp">
<column name="DD_CALN" length="7" not-null="true" />
</property>

public class GlcCaln implements java.io.Serializable {

private static final long serialVersionUID = 1L;

private long seqCaln;
private long versionOra;
...