On Mon, Nov 18, 2002 at 09:16:25AM -0700, Travis Reeder wrote:
> 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.
Right, we use PB API only and an Oracle-Sequencemanager and have no
OJB-specific tables at all.
Jens
>
>
> ----- 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]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
