I made the following change to ObjectDao.cfc to get up and running
with CF Reactor on this particular MySQL4 database:
I added the problem datatypes to the numeric case in this function
(line 238 in the current ObjectDao.cfc in the /reactor/data/mysql4
folder:
i.e., i appended "bigint unsigned,smallint unsigned,mediumint
unsigned" to the relevant case:
<cffunction name="getCfDataType" access="private" hint="I translate
the MSSQL data type names into ColdFusion data type names"
output="false" returntype="string">
<cfargument name="typeName" hint="I am the type name to
translate"
required="yes" type="string" />
<cfswitch expression="#arguments.typeName#">
<cfcase value="bit,bool,boolean">
<cfreturn "boolean" />
</cfcase>
<cfcase
value="tinyint,smallint,mediumint,int,integer,bigint,float,double,double
percision,decimal,dec,year,bigint unsigned,smallint unsigned,mediumint
unsigned">
<cfreturn "numeric" />
</cfcase>
<cfcase value="date,datetime,timestamp">
<cfreturn "date" />
</cfcase>
<cfcase value="time,enum,set">
<cfreturn "string" />
</cfcase>
<cfcase
value="char,varchar,tinytext,text,mediumtext,longtext">
<cfreturn "string" />
</cfcase>
<cfcase
value="binary,varbinary,tinyblob,blob,mediumblob,longblob">
<cfreturn "binary" />
</cfcase>
</cfswitch>
<cfthrow message="Unsupported (or incorrectly supported)
database
datatype: #arguments.typeName#." />
</cffunction>
That worked in terms of being able to get up and running with querying
data using reactor. I only
started working with this last night and do not know if that change
will work in terms of
table relations/everything else.
On 4/6/06, Sean Corfield <[EMAIL PROTECTED]> wrote:
> On 4/6/06, Daryl <[EMAIL PROTECTED]> wrote:
> > Any info on this error? thanks
> > Unsupported (or incorrectly supported) database datatype: bigint unsigned.
>
> It's exactly what it says: the MySQL 4.x code in Reactor does not
> support that column type. I wrote the original 4.x code and it worked
> with the tables I tested but I didn't do exhaustive testing. Others
> have submitted patches to fix bugs such as this. Perhaps you could
> help the project by figuring out what needs to change in
> mysql4/ObjectDao.cfc to address this and send it to Doug?
> --
> Sean A Corfield -- http://corfield.org/
> Got frameworks?
>
> "If you're not annoying somebody, you're not really alive."
> -- Margaret Atwood
>
>
>
> -- Reactor for ColdFusion Mailing List -- [email protected]
> -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
>
>
>
-- Reactor for ColdFusion Mailing List -- [email protected]
-- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
