tracker issue : CF-3037766

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

Bug 75811:(Watson Migration Closure)I create a Table called adr_Firma within SQLServer 2008 with an Field called Ident which should contain an UUID like:

| View in Tracker

Status/Resolution/Reason: Closed/Won't Fix/

Reporter/Name(from Bugbase): Reinhard Jung / Reinhard Jung (Tigermutze)

Created: 03/06/2009

Components: ORM Support

Versions: 9.0

Failure Type: Unspecified

Found In Build/Fixed In Build: 9,0,0,216113 /

Priority/Frequency: Major / Unknown

Locale/System: English / Win All

Vote Count: 1

Problem:

I create a Table called adr_Firma within SQLServer 2008 with an Field called Ident which should contain an UUID like:
<cfproperty name="Ident" fieldtype="id" generator="uuid" />
But the result within the Table is:
"40285e811fdabaed011fdabee75e0003" instead of something like "DBDBEFE1-1F3C-7771-D98C53A64CCBB403".
So the Value of the Field is NOT of a Datatype ColdFusion-UUID?!

Did i missed something? I also found nothing in the ORM-Forum.
Method:

Application.cfc
<cfcomponent output="false">
  <cfset this.name        = "AddressNine" />
  <cfset this.ormenabled  = "true" />
  <cfset this.datasource  = "prj_AddressNine" />
  <cfset this.ormsettings = {Dialect='MicrosoftSQLServer'} />
</cfcomponent>


firma.cfc
<cfcomponent output="false" persistent="true" table="adr_Firma" dynamicInsert="true" dynamicUpdate="true">
  <cfproperty name="Ident" fieldtype="id" generator="uuid" />
  <cfproperty name="Name" column="Firmenname" />
  <cfproperty name="CreatedBy" />
  <cfproperty name="CreatedAt" />
  <cfproperty name="OwnedBy" />
  <cfproperty name="OwnedAt" />
  <cfproperty name="Zusatz" />
  <cfproperty name="GesForm" />
</cfcomponent>


<cfdump var="#createUUID()#" />
<!--- 
<cfset Firma = createObject('component','Firma') />
<cfset Firma.setName('WhatWomenWant') />
<cfset Firma.setZusatz('AG') />
<cfset EntitySave(Firma) />
 --->

<cfset Firma1 = EntityLoad('Firma','40285e811fdabaed011fdabee75e0003',true) />

<cfset Firma = EntityLoad('Firma') />

<cfdump var="#Firma1#" />
<cfdump var="#Firma#" />

Result:

There are no ErrorMessages.
But i'm shure that i could not check the Value as an ColdFusion UUID Datatype.

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

Watson Bug ID:	3037766

External Customer Info:
External Company:  
External Customer Name: Reinhard Jung
External Customer Email: 4DD96DF448671727992015A7
External Test Config: 03/06/2009

Attachments:

Comments:

[Rupesh 30 mar 09] : Hibernate generates uuid in a format different than CF. Does it matter which format the UUID is in as long as it is unique? Do we need a CF format UUID generator for hibernate? Bug History Timestamp|name|field|from value|to value| 6 Mar 2009 02:41:47 GMT | Reinhard Jung | Bug Submitted | | | 6 Mar 2009 02:41:47 GMT | System System | Class Type | | BUG | 6 Mar 2009 02:41:47 GMT | System System | Severity | | 2-Serious (Seriously impedes use of product) | 12 Mar 2009 07:19:08 GMT | Praveen Gupta | Priority | | A | 12 Mar 2009 07:19:08 GMT | Praveen Gupta | Queue Transfer | | pkiran | 12 Mar 2009 07:19:08 GMT | Praveen Gupta | Target Fix Milestone | | Beta 2 | 12 Mar 2009 07:19:08 GMT | Praveen Gupta | Target Fix Release | | ColdFusion 9.0 | 12 Mar 2009 21:17:01 GMT | Manju Kiran | Queue Transfer | pkiran | rkumar | 12 Mar 2009 21:17:01 GMT | Manju Kiran | Verified | No | Yes | 29 Mar 2009 22:15:11 GMT | Rupesh Kumar | Queue Transfer | rkumar | hkhandelwal | 2 Apr 2009 19:47:39 GMT | Hemant Khandelwal | Class Type | BUG | ENHANCEMENT | 2 Apr 2009 19:47:39 GMT | Hemant Khandelwal | Queue Transfer | hkhandelwal | Enhancements - Neo | 2 Apr 2009 19:47:39 GMT | Hemant Khandelwal | Target Fix Milestone | Beta 2 | Under Review | 19 Jul 2010 02:44:51 GMT | Jayesh Viradiya | Target Fix Release | ColdFusion 9.0 | ColdFusion 10.0 |
Comment by Kunal S.
23992 | November 10, 2011 04:29:28 PM GMT
This bug has been voted..
Vote by External U.
23993 | November 10, 2011 07:18:03 PM GMT