This depends on which db you're using. I believe there is an oracle, sap
db, and mysql implementation of SequenceManager that don't require the ojb
internal tables.
travis
----- Original Message -----
From: "Cheong Wai Kit" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 12:20 AM
Subject: Re: Sequence Mgr/Primary Key problem
> 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]>
>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
