Thanks. It worked. Regards,
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 11 June 2003 21:39 To: OJB Users List Subject: Re: Accomodating the VERSION column during ojb upgrade Most DBMS allow to add columns without changing existing data. I think it will be the safest way to upgrade. Paul Worrall wrote: > Help much appreciated, > > I am upgrading from 0.9.5 to 1.0 rc3 and I am told in the release > notes > > to: > > - Intern table OJB_HL_SEQ (used by SequenceManagerHighLowImpl) > > has changed! Now need an additional column 'VERSION' of type INTEGER > > When updating from earlier version drop/reinstall table with > additional field > > Can I just alter the existing table to add the column VERSION? > > If I drop it is there a script a run to rebuild it? > > Will it affect the integrity of my existing data tables? > > TIA. > > > > Kind regards, > > > Paul Worrall > Architect | Director > > Apcentric Limited > > The Soft Science of J2EE Deployment > > > m: +44 (0) 77 1133 0213 > w: www.apcentric.com <http://www.apcentric.com/> > > Any opinions expressed in the email are those of the individual and > not > necessarily of the company. This email and any files transmitted with > it are confidential and solely for the use of the intended recipient. > It may contain material protected by attorney-client privilege. If you > are not the intended recipient or person responsible for delivering to > the intended recipient, be advised that you have received this email in > error and that any use is strictly prohibited. If you have received > this email in error please notify the IT manager. > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
