I've been playing about with the config files for
turbine and have managed to come up with one that
built newapp for interbase with no errors.
I'm attaching these the files I changed (in zip).
Basically,
I needed to change the schema..xml docs for newapp
(i.e.once newapp files have been built and before
running ant init..)
1. varchar size max = 250 not 255...
2. Remove references to autoincrement. Interbase
doesn't have the identity feature..You can generate
autoincrementing fields by doing the following:
CREATE GENERATOR EMPNO_GEN;
COMMIT;
SET TERM !! ;
CREATE TRIGGER CREATE_EMPNO FOR EMPLOYEES
BEFORE
INSERT POSITION 0 AS
BEGIN
NEW.EMPNO = GEN_ID(EMPNO_GEN, 1);
END
SET TERM ; !!
IMPORTANT Because each statement in a stored procedure
body must be terminated by a semicolon, you must
define a different symbol to terminate the CREATE
TRIGGER in isql. Use SET TERM before CREATE TRIGGER to
specify a terminator other than a semicolon. After
CREATE TRIGGER, include another SET TERM to change the
terminator back
All that is straight out of the IB language reference
guide...
Anyway...Obviously after running ant init you need to
then create generators and triggers for all the tables
generated by the build...
3. IB has the following as KEYWORDS:
SECOND, MINUTE, HOUR....
I changed them to SECONDS, MINUTES, HOURS...
Maybe somebody could explain how this particular
change could affect turbine and what can be done about
it...
Then I needed to change the .vm's for interbase,
specifically, table.vm and column.vm (see attached
files).It didn't like the comments just before
creating tables..and was a bit fussy about spaces
between field types and sizes...
I also modified db.props...
And lastly set manual.db.generation=true;
create an empty database yourself...and point to it in
the databaseURL....
Then running ant init (I'm just discovering ant..it's
amazing isn't it...)...should bring you nothing but
successfull ib sql statements...
I'm sure this method can be improved upon a lot...it's
a bit hack and slash...but it works...
Now I can get my hands dirty with this turbine
stuff...and check it out...
btw...I'm sending this from home...any replies should
go to [EMAIL PROTECTED]
Saimon...
____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
turbineIBConf.tar.gz
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
