Hi Rayn,
----- Original Message -----
From: "Ryan Joseph" <[EMAIL PROTECTED]>
To: "OJB Users List" <[EMAIL PROTECTED]>
Sent: Monday, November 18, 2002 9:17 PM
Subject: Re: Sequence Mgr/Primary Key problem
> I am using mysql.
>
> Does OJB require the tables defined in "repository_internal.xml" to be
> present in every database instance and not just in the ojb database
> instance?
The internal tables only required in the ojb database instance. But
the repository including repository_internal.xml should be the default
repository. This means the repository set in OJB.properties
(repositoryFile=....).
regards,
Armin
>Is there a script to automate this tedious task?
>
> Thanks
>
>
>
> On Mon, 2002-11-18 at 08:16, 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.
> >
> > 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]>
>
>
> --
> 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]>
