[hibernate-issues] [Hibernate-JIRA] Created: (HHH-6553) validate issue - char converted to varchar2(255) in Oracle
Geoff Powdrell (JIRA)
noreply at atlassian.com
Sun Aug 7 18:04:03 EDT 2011
validate issue - char converted to varchar2(255) in Oracle
----------------------------------------------------------
Key: HHH-6553
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-6553
Project: Hibernate Core
Issue Type: Bug
Affects Versions: 3.5.4
Environment: Oracle 10g, Spring 3.0.2, Hibernate 3.5.4
Reporter: Geoff Powdrell
Deployment in Tomcat I get this issue with one of my persistent object, deployment issue 'Wrong column type FGTADM.CABIN_CLASSES for column class_code. Found: char, expected: varchar2(255 char).
I think the issue is with the Oracle dialect and how it converts a java String type to varchar2(255); regardless of what is on set on the @Column annotation; in particular the columnDefinition='char' setting is ignored.
Currently the class that errors on deployment is annotated like this:
public class CabinClass extends FareGateObject {
@Id
@Column(name = "class_code", length=1, columnDefinition = "char")
private String classCode;
The Oracle cabin_class table is structured like this:
COLUMN_NAME TYPE_NAME COLUMN_SIZE
CLASS_CODE CHAR 1
CLASS_NAME VARCHAR2 15
DESCRIPTION VARCHAR2 200
Any help appreciated. Do I need to upgrade hibernate? Is the @Column annotation definition correct?
regards
geoffpowdrell
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the hibernate-issues
mailing list