Dave, Thanks for the help. It's taken me up until now to realise that there are alternatives to the hi/low sequence manager. I'm using the OJB PB too but I hadn't spotted the nextVal sequence manager and hadn't realised what 'platform' parameter really related to in repository.xml (both down to my not reading the documentation properly). > Yes, but > > a) We only use the persistanceBroker layer in OJB ie not ODMG. > > b) We use generators for our primary keys > > Therefore we don't need any of the tables in ojbcore-schema.sql > > We adjusted a copy of ojbcore-schema.sql so it will work with > firebird. > It is attached. Yes the problem with max index key segments > is a problem > (note we use Unicode_fss as our database character set which > means index > fields have to be even shorter). > > I don't think it will cause a problem with the sequence manager > providing you keep your table and column names short enough to fit in > the OJB_HL_SEQ table. > > Regards > > Dave > -- > David Warnock, Sundayta Ltd. http://www.sundayta.com > iDocSys for Document Management. VisibleResults for Fundraising. > Development and Hosting of Web Applications and Sites. > >
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
