Sequence Mgr/Primary Key problem

[Ryan Joseph]

Hello,

I am trying to store a simple object that contains a primary key object.
My OJB install seems to work out fine as far as queries go, but storing
produces the following error:

[org.apache.ojb.broker.accesslayer.JdbcAccess] ERROR: SQLException
during the execution of materializeObject (for a
org.apache.ojb.broker.util.sequence.HighLowSequence): General error:
Table 'TulipQA.OJB_HL_SEQ' doesn't exist
General error: Table 'TulipQA.OJB_HL_SEQ' doesn't exist

My DB name is TulipQA. There is no table OJB_HL_SEQ in TulipQA, but
there is an ojb database that DOES contain this table.

Do I need to do some more setup to get the auto-increment for a PK
working?

Here is a my field descriptor:
 <field-descriptor id="1"
         name="id"
         column="pkTestCaseID"
         jdbc-type="INTEGER"
         primarykey="true"
         autoincrement="true"
      />

Here is the relevant excerpt from my class:
        private int id;
        private String testCaseName;
        private String  testCaseCode;
        
        public void setId(int new_id){
                id = new_id;
        }
        
        public int getId(){
                return id;
        }

If anyone can offer any help/assistance, that would be great. If I can
provide any additional information - let me know. Thanks

-Ryan

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>