Yesterday I just made Turbine 2.2b1 partially work with my Windows NT DB2
7.1FP6, after fixing files here and there, I'll provide details below.

It's partially working because the turbine security system has been working
so far, all the turbine-schema.xml related tables are working since I'm able
to add users, groups, roles, etc. display, link them, etc. but _not_ the
much simpler form "Insert Entry" :-| that is only form of newapp. I'll start
another message thread with that issue.

I found the same: generated SQL has syntax and semantic errors,
turbine-schema.xml table's primary and foreign keys have very long names for
DB2 (>18). 

I fixed the Velocity macros and after that I replaced the old ones, using
Winzip, from the decoupled Torque .jar file to be able to generate new DB2
SQL scripts in the future.

Here is the sample "newapp" DB2 DDL file after I hand fixed. It's the whole
"enchilada": includes turbine security tables and the Rdf tables from the
sample new app. 

Also you will find the fixed velocity macros in the attached .zip file. 

Disclaimer: I have recreated the tables several times, but only tested in my
workstation. I'm using 2.2b1, but I'm not sure about 2.1, you can try it,
regarding DB2 the velocity macros are the same, it seems that not many
people is using Turbine + DB2, others are using DB2400, there are some SQL
sintax differences after testing with that database target.

Rogelio

Attachment: schema.db2
Description: Binary data

Attachment: sql.zip
Description: Binary data

--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>

Reply via email to