In tables with spatial columns (i.e. - point,
polygon,geometrycollection,etc.) , Reactor is throwing :
Unsupported (or incorrectly supported) database datatype:
I browsed through reactor.data.mysql.objectDAO,
reactor.data.postgres.objectDAO, reactor.data.oracle.objectDAO and
didn't find any spatial datatypes in the getCfDataType() or
getCfSQLType() methods.
For <cfqueryparam> purposes "cf_sql_blob" maintains the integrity
of the geometry values in my tests, so for the time being, I modified
my own reactor.data.[dbtype].objectDAO files to return that cfSQL
type for geometry values. Beyond doing that, are there any
methods available to bypass the objectDAO or the usage of
<cfqueryparam> on unknown datatypes?
I can submit proposed modifications for those datatypes to the
objectDAO methods on the Trac site if anyone thinks it would be
helpful to have these datatypes available in Reactor.
Thanks,
Jon
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
