I've updated my patch to the torque config files on
http://sites.netscape.net/ekkerbj and also started a small HOW-TO for Sybase
ASE integration. Below is a summary:
*) Updated some sql generation templates to use ; instead of GO to execute
the sql since it is run from within the Ant SQL directive.
*) Updated some data types to map to Sybase types. For the turbine schema
to work I had to map TIMESTAMP to DATETIME since our code in turbine updates
this field and Sybase TIMESTAMP fields are auto-updated when something is
done to the record.
*) Added the insertion of the USER_ID in the turbine-security.sql
Previously we were adding the turbine user to the TURBINE_USER table via an
insert statement which assumes that the database specific auto increment
features ( not IdBroker ) were used when generating the turbine schema. I
just hard coded the USER_ID to 0 for this special user. Currently I don't
know of a better way around this. Maybe some magic in Control.vm to
determine if IdBroker is being used and issue the appropriate sql insert?
Comments?
Anyway, here is my start to the Sybase HOW-TO. There is a text file of this
at the above site also:
--- CUT ---
TDK Sybase ASE How-To
---------------------
This text is a description of integration of Sybase ASE as the target
database in a TDK generated application.
1) Generate your application with the TDK as normal
2) Edit the project properties as instructed by the TDK.
3) Before you run 'build-project.sh init' you will need to create the
database. Automatic database creation for Sybase does not currently
work, so the database must be created first.
4) Run 'build-project.sh init' to generate and initialize the project.
Notes:
*) The .sql files that the TDK build process generates files with the
sql command terminated by a ; for use in the sql directive provided by
the Ant build system. These scripts will not work properly if run by
hand via the 'isql' command.
*) The .sql files to create the tables, do not correctly remove any
constraints on the tables currently and may fail. Drop the tables by
hand, then re-run 'build-project.sh insert-sql' to re-create and
populate the tables.
--- CUT ---
-----------------------------------------------------------------------
This message has been scanned for viruses with Trend Micro's Interscan VirusWall.
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
