Radiant uses Rails' database adapters with very little modification (I think there was a sqlite patch in there somewhere). Traditionally, Rails has not supported DB2 well. Anything you could contribute to improve the adapter would be appreciated in the Rails community at large, I imagine.

Sean

[EMAIL PROTECTED] wrote:

I would be interested in building a Radiant site with the IBM DB2 9.1 database as a back end. Such product is available in a free express edition, and provides native XML data storage, which would be very useful for our site, devoted to XBRL, a language derived from XML used for representing financial documents (http://xbrl.org).

I have installed the IBM_DB adapter version 0.4.6 and had it running. The adapter is still limited, since it does not support rename_column. I was able to create the radiant bootstrap database substituting the final DB schema for the sequence of migrations. I can create smippets and layouts, but cannot create pages. After posting the "create" command, I get an error message of the sort (translated from Italian):

Found unforeseen token ")" after "UPDATE pages SET (". Token may be: "<update_target_list>". SQLSTATE=42601
SQLCODE=-104'

Before wasting too much time, I would like to know if someone in the Radiant community has considered supporting DB2. In order to support it, what should be needed? Is a compliant ruby db adapter enough, or you have to tweak specific SQL statements somewhere in radiant code?

Thanks in advance

Luca


Luca Erzegovesi

University of Trento, Italy
[EMAIL PROTECTED]

------------------------------------------------------------------------

_______________________________________________
Radiant mailing list
Post:   [email protected]
Search: http://radiantcms.org/mailing-list/search/
Site:   http://lists.radiantcms.org/mailman/listinfo/radiant

_______________________________________________
Radiant mailing list
Post:   [email protected]
Search: http://radiantcms.org/mailing-list/search/
Site:   http://lists.radiantcms.org/mailman/listinfo/radiant

Reply via email to