Hi All,

I'm trying to use SQLObject on an legacy database and I have 2 questions:

1)The primary keys are BIGINT, not INT; I haven't tried it yet but is this going to cause me problems? 

2) The foreign keys end in '_FK' rather than the 'ID' that the documentation says is required. (The doc in question is at http://www.sqlobject.org/SQLObject.html#sqlobject-requirements). For example the tables might look like this:

CREATE TABLE Person (
    id BIGINT PRIMARY KEY,
    FirstName VARCHAR(100) NULL,
    LastName VARCHAR(100) NULL
)

CREATE TABLE Role (
id BIGINT PRIMARY KEY,
Role VARCHAR(100) NULL,
PersonID_FK BIGINT NULL
)

Is there any way to specify the name of the foreign key? I keep thinking there should be something like this:
person = ForeignKey('Person', key = "PersonID_FK")

Also, when using SQLObject to generate tables, is there anyway to force it to use BIGINT instead of INT as the primary key type?

Thanks


Brian Schlining
Software Engineer
http://www.mbari.org