tracker issue : CF-3698408

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

PostgreSQL: ormtypes "char" and "character" set incorrect length

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/NotABug

Reporter/Name(from Bugbase): Jonathan Clausen / Jonathan Clausen (Jonathan Clausen)

Created: 01/23/2014

Components: ORM Support

Versions: 10.0

Failure Type: Data Corruption

Found In Build/Fixed In Build: Final /

Priority/Frequency: Critical / All users will encounter

Locale/System: English / Mac 10 All

Vote Count: 0

Problem Description:When using the ormtype of "char" and "character" in a persistent property, all columns are set with a length of "1" with the "length" attribute of the property being ignored.  String lengths are set properly for the sqltype "character varying" (which is also the default)

Steps to Reproduce:
property name="zip" column="zip" ormtype="char" length=10;


property name="zip" column="zip" ormtype="character" length=10;

Actual Result:
column created/updated is "character 1"

Expected Result:
column created should be "character 10"

Any Workarounds:
Use "string" ormtype.

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

Watson Bug ID:	3698408

External Customer Info:
External Company:  
External Customer Name: JJClausen
External Customer Email:  
External Test Config: My Hardware and Environment details:


OSX v 10.9.1

Proc: 2.9 GHz Intel Core i7

Memory: 8GB 


9.2.4 on x86_64-apple-darwin-12.5.0

CF Server:

Server Details

Server Product	 ColdFusion

Version	 ColdFusion 10,287689

Edition	 Developer  

Operating System	 Mac OS X  

OS Version	 10.9.1  

Update Level	 /Applications/ColdFusion10/cfusion/lib/updates/chf10000013.jar  

Adobe Driver Version	 4.1 (Build 0001)  

JVM Details

Java Version	 1.7.0_45  

Java Vendor	 Oracle Corporation  

Java Vendor URL  

Java Home	 /Library/Java/JavaVirtualMachines/jdk1.7.0_45.jdk/Contents/Home/jre  

Java File Encoding	 UTF8  

Java Default Locale	 en_US  

File Separator	 /  

Path Separator	 :  

Line Separator	 Chr(10)  

User Name	 jonclausen  

User Home	 /Users/username  

User Dir	 /Applications/ColdFusion10/cfusion/bin  

Java VM Specification Version	 1.7  

Java VM Specification Vendor	 Oracle Corporation  

Java VM Specification Name	 Java Virtual Machine Specification  

Java VM Version	 24.45-b08  

Java VM Vendor	 Oracle Corporation  

Java VM Name	 Java HotSpot(TM) 64-Bit Server VM  

Java Specification Version	 1.7  

Java Specification Vendor	 Oracle Corporation  

Java Specification Name	 Java Platform API Specification  

Java Class Version	 51.0



Please use sqlType instead of ormType property name="zip" column="zip" sqltype="char" length=53;
Comment by Himavanth R.
13626 | May 09, 2014 03:19:40 AM GMT