tracker issue : CF-3518916

select a category, or use search below
(searches all categories and all time range)

Trying to inserting Null in primitive boolean type throws error for SQLServer

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): / ext-user (Himavanth Rachamsetty)

Created: 03/13/2013

Components: ORM Support

Versions: 11.0

Failure Type: Non Functioning

Found In Build/Fixed In Build: CF 11 Alpha / CF11 update 1

Priority/Frequency: Major / Some users will encounter

Locale/System: English / Mac 10 All,Win XP All

Vote Count: 5

Listed in the version Issues Fixed doc
Trying to inserting Null in primitive boolean type throws the following error for SQLServer.

[Macromedia][SQLServer JDBC Driver]The specified SQL type is not supported by this driver.

One possible workaround is to set default to false but that might not be acceptable in all cases.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3518916

External Customer Info:
External Company:  
External Customer Name:  
External Customer Email:



Workaround:- If using cfc for type mapping, use ormtype="numeric_boolean" If using hbmxml, use type="numeric_boolean"
Comment by Himavanth R.
16026 | January 15, 2014 04:55:28 AM GMT
This is a bug in the version of Hibernate used by CF11. We have been waiting for word on an update before we upgrade as the workaround is fairly cumbersome for us. Do you have any intention of updating Hibernate in CF11?
Vote by External U.
16030 | July 18, 2014 08:55:10 AM GMT
Thanks for NeverFix, Adobe.
Vote by External U.
16031 | July 18, 2014 02:36:54 PM GMT
Major problem, please fix.
Vote by External U.
16032 | August 07, 2014 10:53:11 AM GMT
This is a bug with the JDBC driver not accepting setNull method on Types.Boolean. Logged a case with DataDirect .
Comment by Himavanth R.
16027 | August 18, 2014 02:59:27 AM GMT
This is marked as "Fixed" but has no "Fixed in Build." Will installing one of the ColdFusion 11 updates fix it?
Comment by External U.
16028 | December 03, 2014 12:03:03 PM GMT
This was fixed in CF11 Update 1
Comment by Himavanth R.
16029 | December 04, 2014 12:59:56 AM GMT
Migrate from CF7 to CF11 and same problem here.
16033 | October 13, 2017 06:57:55 PM GMT