In my OJB (using PersistenceBroker ) application auto-increment is not working.
I am using MySQL in which I have also used the auto-increment constraint for the
Primarykey ( bigint(20) )
For my database definition i have used the "SequenceManagerNativeImpl"
<sequence-manager
className="org.apache.ojb.broker.util.sequence.SequenceManagerNativeImpl">
<attribute attribute-name="autoNaming" attribute-value="true"/>
</sequence-manager>
also in the mapping file i have
<class-descriptor class="com.haystack.emailmarketingchoice.member.MemberVO"
table="tblMember">
<field-descriptor id="1" name="memberId" column="member_id" jdbc-type="BIGINT"
primarykey="true" autoincrement="true" access="readonly" />
------------
------------
</class-descriptor>
i have also tried without the --> access="readonly"
but it generates a new 20 digit "auto-increment" number only for the first insert,
for the subsequent inserts it generates the same number and a Duplicate Entry error
arises.
I have also tried the following sequence managers
SequenceManagerMySQLImpl
SequenceManagerSeqHiLoImpl
with and without these attributes
<attribute attribute-name="grabSize" attribute-value="5" />
<attribute attribute-name="globalSequenceId" attribute-value="true"/>
<attribute attribute-name="globalSequenceStart" attribute-value="10000"/>
But ALL Failed.
Have any one of you tried this. Please let me know.
Thanks in advance for your interest in my problem.
Regards,
Arjun.
