Hi Mark,
I might have found something. Using latest 1.1 using MS SQL 2000.
The problem I receive is when retrieving a Interface object as you
will see below. The error is a SQL error:
[Macromedia][SQLServer JDBC Driver][SQLServer]Only text pointers are
allowed in work tables, never text, ntext, or image columns. The query
processor produced a query plan that required a text, ntext, or image
column in a work table.
Error on line 115 - com\sql\QueryExecution.cfc
The interfering columns are Description which is a text field and
Inactive Message which is also a text field. If I remove the many to
many relationship, it works. If I remove both text fields, it works.
All together, bombs out.
This is the transfer.XML Snippet
<object name="Interface" table="Interfaces"
decorator="SearchAdmin.controlpanel.model.search.Interface">
<id name="InterfaceID" type="UUID"
generate="true"/>
<property name="Name" type="string" />
<property name="Alias" type="string"
column="alias" />
<property name="isActive" type="boolean" />
<property name="FilterPacket" type="string"
nullable="true"/>
<property name="ModifyDate" type="date"
ignore-insert="true" />
<property name="Description" type="string"
nullable="true" />
<property name="InactiveMessage"
type="string" nullable="true" />
<property name="URL" type="string"/>
<!-- Collections -->
<manytomany name="Collections"
table="InterfaceCollections">
<link to="search.Interface"
column="InterfaceID"/>
<link to="search.Collection"
column="CollectionID"/>
<collection type="array"></collection>
</manytomany>
</object>
<!-- Collections -->
<object name="Collection" table="Collections"
decorator="SearchAdmin.controlpanel.model.search.Collection">
<id name="CollectionID" type="UUID"
generate="true"/>
<property name="Name" type="string" />
<property name="Description" type="string"
nullable="true" />
</object>
The SQL produced is the following:
SELECT NULL as CollectionID, Interfaces_1.URL,
Interfaces_1.InactiveMessage,
Interfaces_1.Description, Interfaces_1.ModifyDate,
Interfaces_1.FilterPacket,
Interfaces_1.isActive, Interfaces_1.alias, Interfaces_1.Name,
Interfaces_1.InterfaceID, NULL as transfer_parentKey,
1 as transfer_orderIndex,'search.Interface' as transfer_className,
'' as transfer_parentClassName,'' as transfer_parentParentClassName,''
as transfer_parentCompositeName,
'false' as transfer_isArray,'' as transfer_compositeName,
'false' as transfer_isProxied
FROM Interfaces Interfaces_1
WHERE Interfaces_1.InterfaceID = 'E22A0774-D1F2-0707-7BAD2C54D2D5029B'
AND Interfaces_1.InterfaceID IS NOT NULL
UNION ALL
SELECT Collections_2.CollectionID, NULL as URL, NULL as
InactiveMessage,
Collections_2.Description, NULL as ModifyDate, NULL as FilterPacket,
NULL as isActive, NULL as alias, Collections_2.Name, NULL as
InterfaceID,
CAST(Interfaces_1.InterfaceID as varchar(1000)) as transfer_parentKey,
2 as transfer_orderIndex,'search.Collection' as transfer_className,
'search.Interface' as transfer_parentClassName,'' as
transfer_parentParentClassName,
'' as transfer_parentCompositeName,'true' as
transfer_isArray,'Collections' as transfer_compositeName,
'false' as transfer_isProxied
FROM Interfaces Interfaces_1
left INNER JOIN InterfaceCollections InterfaceCollections_2 ON
Interfaces_1.InterfaceID = InterfaceCollections_2.InterfaceID
left INNER JOIN Collections Collections_2 ON
InterfaceCollections_2.CollectionID = Collections_2.CollectionID
WHERE Interfaces_1.InterfaceID = 'E22A0774-D1F2-0707-7BAD2C54D2D5029B'
AND
Collections_2.CollectionID IS NOT NULL ORDER BY transfer_orderIndex ASC
--~--~---------~--~----~------------~-------~--~----~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer
You received this message because you are subscribed to the Google Groups
"transfer-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/transfer-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
