2 Replies Latest reply on Jan 25, 2005 10:24 AM by Arnold Fung

    Hypersonic auto-increment non-linearl JBoss 3.2.4

    Arnold Fung Newbie

      Hello all,

      I am using the auto-increment feature to assign Integer primary key for my CMP entity bean.

      It is all well except the pk isn't incrementing non-linearly (e.g. possible sequence 0, 17, 50, 80, ....). There are no concurrent insert.

      My question is whether the sequence should be linear (i.e. 0, 1, 2, 3, ...)

      Here is my jbosscmp-jdbc.xml

      <enterprise-beans>
       <entity>
       <ejb-name>Task</ejb-name>
       <pk-constraint>false</pk-constraint>
       <table-name>TaskTbl</table-name>
       <cmp-field>
       <field-name>taskPK</field-name>
       <column-name>TASK_PK</column-name>
       <auto-increment/>
       </cmp-field>
       ....
       <entity-command name="hsqldb-fetch-key" />
       </entity>
      


      standardjbosscmp-jdbc.xml is UNMODIFIED.

      Thanks.
      Arnold