Hi,
I'm trying to install Spectra 1.5.3 on a clean system (windows 2003
server).
I want to use Oracle (9.2.0.5.0) instead of the provided access
databases, and am trying to port the blank databases (allaire.zip) as
described in the Spectra 1.5.3. releasenotes.
I'm using the Oracle Migration Workbench to create the Oracle model,
however I'm running into several errors :
failed to map table :
cfapplicationdb.cfapplicationdb.rs_lastcommit;oracle.mtg.migration.Migra
tionSQLException: Failed to map table column:origin_qid:Failed to map
table column:origin_qid
The table rs_lastcommit contains the datatype 'Binary' which the Oracle
Migration Tool does not seem to recognize (When checking the Data Type
Mappings there's no entry for 'Binary', only 'LongBinary').
I've tried changing the access type to 'Long Binary' in the xml file,
which get translated to BLOB in Oracle, but then I get other errors
(ORA-02262: ORA-932 occurs while type-checking column default value
expression). Changing the BLOB to LONG RAW does not help, as you can
only have 1 LONG RAW type column per table (and cfaapplicationdb
contains 2 binary columns)
Anybody have any idea what I can try next, or have experience with
running Spectra on Oracle ?
Thanx in advance,
Esther
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:17:5683
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/17
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:17
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.17
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
