Spatial Datatypes for reactor.data.mysql.objectDAO

[jclausen]

When Reactor encounters columns with spatial datatypes in MySQL 5, it throws the following error message:
"Unsupported (or incorrectly supported) database datatype"

in reactor.data.mysql.objectDAO

Problem:
This prevents reactor from accessing any table with columns which contains spatial information in WKB (well-known-binary) or dbms-native geometry formats.

Solution:
The following cfcase's should be added in reactor.data.mysql.objectDAO in the to allow for spatial datatypes:

Add to method getCfSqlType():

<!--- MySQL 5 Spatial datatypes --->
<cfcase value="geometry,point,linestring,polygon,multilinestring,multipoint,multipolygon,geometrycollection">
  <cfreturn "cf_sql_blob" />
</cfcase>

Add to method getCfDataType():

<!--- MySQL 5 Spatial Datatypes --->
<cfcase value="geometry,point,linestring,polygon,multilinestring,multipoint,multipolygon,geometrycollection">
  <cfreturn "binary" />
</cfcase>

Note: MySQL 4.1 also supports these datatypes, but these changes have not been tested with that version.