Status/Resolution/Reason: Closed/Fixed/Fixed
Reporter/Name(from Bugbase): Anthony Morse / Anthony Morse ()
Created: 01/14/2018
Components: Database, Query-of-Query(IMQ)
Versions: 2016
Failure Type: Non Functioning
Found In Build/Fixed In Build: 2016.0.05.303689 / 308513
Priority/Frequency: Normal / All users will encounter
Locale/System: / Win 2012 Server x64
Vote Count: 1
The following code works in versions prior to 2016 and returns the error "Unsupported SQL type java.sql.Types.SQLXML" in the 2016 version.
Example sql server table
{code:java}
create table testTable
(
xml_data_field xml
)
{code}
{code:java}
<cfquery name="testQuery">
select xml_data_field from testTable
</cfquery>
<cfquery name="testQueryQuery" dbtype="query">
select xml_data_field from testQuery
</cfquery>
{code}Attachments:
Comments: