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;
![table.JPG table.JPG](/t5/image/serverpage/image-id/944iD660F21FD8D0A7E5/image-size/large?v=v2&px=999)
and the sequence;
![sequence.JPG sequence.JPG](/t5/image/serverpage/image-id/945i27CD7AA83C58CDD8/image-size/large?v=v2&px=999)
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:
![error.JPG error.JPG](/t5/image/serverpage/image-id/946i8C88566EC2F2A250/image-size/large?v=v2&px=999)
Any ideas on what am I doing wrong?
All help is appriciated