Hello,
I want to populate my table's ID with a sequence. I have made a table and sequence in Oracle
my table is as follow;
and the sequence;
Now my model looks like;
<model xmlns="http://ns.adobe.com/Fiber/1.0">
<annotation name="DMS">
<item name="datasource">java:/comp/env/jdbc/oracle</item>
<item name="hibernate.dialect">org.hibernate.dialect.Oracle10gDialect</item>
</annotation>
<entity name="Seqtest" persistent="true">
<annotation name="ServerProperties" ServerType="LCDS"/>
<annotation name="DMS" Table="N2B_DEV.SEQTEST"/>
<annotation name="VisualModeler" width="115" height="62" x="307" y="121"/>
<id name="myid" type="long" generated="true">
<annotation name="DMS" ColumnName="ID" strategy="SEQUENCE" generator="SEQTEST_SEQ"/>
</id>
<property name="name" type="string" length="10">
<annotation name="DMS" ColumnName="NAME"/>
</property>
</entity>
</model>
But when I try to deploy it I get the following error:
Any ideas on what am I doing wrong?
All help is appriciated