Hi Ryan,
i am a newbie too, but as far as i know you need to create the table(its
mandatory for OJB). Have a look at repository_internal.xml. :)
p.s. : ojb_hl_seq table is to keep the sequence number.
hopes that help.
kit.
----- Original Message -----
From: "Ryan Joseph" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 3:13 PM
Subject: Sequence Mgr/Primary Key problem
> 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]>
>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
