I can't help you with the torque issues.
After that I tried using using the ojbcore-schema.sql to insert the default required tables into the firebird database skipping the test torque stuff. However, I got an error when doing that: "GDS Exception. unsuccessful metadata update key size too big for index RDB$PRIMARY5". After a good deal of searching it seems that the primary key should not be greater that 256 bytes in Firebird and less than 200 if the PK is a composite. I changed the OJB_HL_SEQ TABLENAME column size to 128 (with FIELDNAME column with size 70) and finally creating the table worked. However, I don't know whether this is going to mess up OJB's sequence manager. Did you have any trouble with this?
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.
-----------------------------------------------------------------------------
-- OJB_HL_SEQ
-----------------------------------------------------------------------------
CREATE TABLE OJB_HL_SEQ
(
TABLENAME VARCHAR (31) character set ASCII not null,
FIELDNAME VARCHAR (31) character set ASCII not null,
MAX_KEY integer,
GRAB_SIZE integer,
PRIMARY KEY(TABLENAME,FIELDNAME)
);
-----------------------------------------------------------------------------
-- OJB_LOCKENTRY
-----------------------------------------------------------------------------
CREATE TABLE OJB_LOCKENTRY
(
OID_ VARCHAR (164) character set ASCII not null,
TX_ID VARCHAR (34) character set ASCII not null,
TIMESTAMP_ timestamp,
ISOLATIONLEVEL integer,
LOCKTYPE integer,
PRIMARY KEY(OID_,TX_ID)
);
-----------------------------------------------------------------------------
-- OJB_NRM
-----------------------------------------------------------------------------
CREATE TABLE OJB_NRM
(
NAME VARCHAR (250) character set ASCII not null,
OID_ VARCHAR(1000),
PRIMARY KEY(NAME)
);
-----------------------------------------------------------------------------
-- OJB_DLIST
-----------------------------------------------------------------------------
CREATE TABLE OJB_DLIST
(
ID integer not null,
SIZE_ integer,
PRIMARY KEY(ID)
);
-----------------------------------------------------------------------------
-- OJB_DLIST_ENTRIES
-----------------------------------------------------------------------------
CREATE TABLE OJB_DLIST_ENTRIES
(
ID integer not null,
DLIST_ID integer,
POSITION_ integer,
OID_ VARCHAR(1000),
PRIMARY KEY(ID)
);
-----------------------------------------------------------------------------
-- OJB_DSET
-----------------------------------------------------------------------------
CREATE TABLE OJB_DSET
(
ID integer not null,
SIZE_ integer,
PRIMARY KEY(ID)
);
-----------------------------------------------------------------------------
-- OJB_DSET_ENTRIES
-----------------------------------------------------------------------------
CREATE TABLE OJB_DSET_ENTRIES
(
ID integer not null,
DLIST_ID integer,
POSITION_ integer,
OID_ VARCHAR(1000),
PRIMARY KEY(ID)
);
-----------------------------------------------------------------------------
-- OJB_DMAP
-----------------------------------------------------------------------------
CREATE TABLE OJB_DMAP
(
ID integer not null,
SIZE_ integer,
PRIMARY KEY(ID)
);
-----------------------------------------------------------------------------
-- OJB_DMAP_ENTRIES
-----------------------------------------------------------------------------
CREATE TABLE OJB_DMAP_ENTRIES
(
ID integer not null,
DMAP_ID integer,
KEY_OID VARCHAR(1000),
VALUE_OID VARCHAR(1000),
PRIMARY KEY(ID)
);
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
