[Hibernate-JIRA] Created: (HHH-2304) Wrong type detection for sql type char(x) columns

[Hibernate-JIRA] Created:...

Markus Heiden (JIRA)

Tuesday, 12 December 2006 Tue, 12 Dec '06

1:12 p.m.

Wrong type detection for sql type char(x) columns ------------------------------------------------- Key: HHH-2304 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304 Project: Hibernate3 Type: Bug Components: core Versions: 3.2.0.ga Environment: Hibernate 3.2.0, Oracle 9.2, Oracle JDBC driver 10.2 Reporter: Markus Heiden Attachments: hibernate.zip When executing a sql query which returns columns of sql type char(x), a java.lang.Character is returned. This leads to returning just the first character of the value. In my eyes a String should be returned when the char(x) type has a width > 1. I wasn't able to determine whether this is a jdbc driver issue or a hibernate issue. When using sql type char(x) for columns of entities no such problems occur. Test case is attached. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

Show replies by date

Jair Tinoco (JIRA)

Friday, 23 November Fri, 23 Nov

7:55 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2304) Wrong type detection for sql type char(x) columns

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304?page=c... ] Jair Tinoco commented on HHH-2304: ---------------------------------- This situation happens with MySQL Connector/J 5.0.4 and MySQL Server 5.0.45 Community

...

Wrong type detection for sql type char(x) columns ------------------------------------------------- Key: HHH-2304 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304 Project: Hibernate3 Issue Type: Bug Components: core Affects Versions: 3.2.0.ga Environment: Hibernate 3.2.0, Oracle 9.2, Oracle JDBC driver 10.2 Reporter: Markus Heiden Attachments: hibernate.zip When executing a sql query which returns columns of sql type char(x), a java.lang.Character is returned. This leads to returning just the first character of the value. In my eyes a String should be returned when the char(x) type has a width > 1. I wasn't able to determine whether this is a jdbc driver issue or a hibernate issue. When using sql type char(x) for columns of entities no such problems occur. Test case is attached.

-- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira

Krashan Brahmanjara (JIRA)

Monday, 3 March Mon, 3 Mar

6:48 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2304) Wrong type detection for sql type char(x) columns

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304?page=c... ] Krashan Brahmanjara commented on HHH-2304: ------------------------------------------ The problem sill exist in 3.2.6a with IBM informix jdbc driver. Somewhere in CustomLoader.getHibernateType( or factory.getDialect().getHibernateTypeName char(?) is mapped to Character for columnType==1. Another problem is CustomLoader.getHibernateType which incorrectly detect length of char fields my patch detect it better but it is not solution of bad mapping of Character type fields. public Type getHibernateType(int columnPos) throws SQLException { //char length or precision int precision = resultSetMetaData.getPrecision( columnPos ); + int length = precision; + if (columnType==1 && precision==0){ + length = resultSetMetaData.getColumnDisplaySize(columnPos); + } return TypeFactory.heuristicType( factory.getDialect().getHibernateTypeName( columnType, - precision, + length, precision, scale ) (...)

...

Wrong type detection for sql type char(x) columns ------------------------------------------------- Key: HHH-2304 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304 Project: Hibernate3 Issue Type: Bug Components: core Affects Versions: 3.2.0.ga Environment: Hibernate 3.2.0, Oracle 9.2, Oracle JDBC driver 10.2 Reporter: Markus Heiden Attachments: hibernate.zip When executing a sql query which returns columns of sql type char(x), a java.lang.Character is returned. This leads to returning just the first character of the value. In my eyes a String should be returned when the char(x) type has a width > 1. I wasn't able to determine whether this is a jdbc driver issue or a hibernate issue. When using sql type char(x) for columns of entities no such problems occur. Test case is attached.

Krashan Brahmanjara (JIRA)

7:40 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2304) Wrong type detection for sql type char(x) columns

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304?page=c... ] Krashan Brahmanjara commented on HHH-2304: ------------------------------------------ Patch for dialect/Dialect.java for correct mapping char to string registerHibernateType( Types.BIT, Hibernate.BOOLEAN.getName() ); - registerHibernateType( Types.CHAR, Hibernate.CHARACTER.getName() ); + registerHibernateType( Types.CHAR,1, Hibernate.CHARACTER.getName() ); + registerHibernateType( Types.CHAR,255, Hibernate.STRING.getName() ); registerHibernateType( Types.DATE, Hibernate.DATE.getName() ); registerHibernateType( Types.DOUBLE, Hibernate.DOUBLE.getName() ); With "length patch" from earlier comment it allow for correct mapping CHAR(?) column types with Informix drivers. When patch HHH-3147 will be added will be posiible to read namedQueries without column names

...

Wrong type detection for sql type char(x) columns ------------------------------------------------- Key: HHH-2304 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304 Project: Hibernate3 Issue Type: Bug Components: core Affects Versions: 3.2.0.ga Environment: Hibernate 3.2.0, Oracle 9.2, Oracle JDBC driver 10.2 Reporter: Markus Heiden Attachments: hibernate.zip When executing a sql query which returns columns of sql type char(x), a java.lang.Character is returned. This leads to returning just the first character of the value. In my eyes a String should be returned when the char(x) type has a width > 1. I wasn't able to determine whether this is a jdbc driver issue or a hibernate issue. When using sql type char(x) for columns of entities no such problems occur. Test case is attached.

Stephen Friedrich (JIRA)

Thursday, 26 February Thu, 26 Feb

5:18 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2304) Wrong type detection for sql type char(x) columns

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304?page=c... ] Stephen Friedrich commented on HHH-2304: ---------------------------------------- Happens in Oracle, DB2, SQLServer (and probably other/all) dialects, too.

...

Wrong type detection for sql type char(x) columns ------------------------------------------------- Key: HHH-2304 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.2.0.ga Environment: Hibernate 3.2.0, Oracle 9.2, Oracle JDBC driver 10.2 Reporter: Markus Heiden Attachments: hibernate.zip When executing a sql query which returns columns of sql type char(x), a java.lang.Character is returned. This leads to returning just the first character of the value. In my eyes a String should be returned when the char(x) type has a width > 1. I wasn't able to determine whether this is a jdbc driver issue or a hibernate issue. When using sql type char(x) for columns of entities no such problems occur. Test case is attached.

Bart Vanhaute (JIRA)

Thursday, 12 March Thu, 12 Mar

7:26 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2304) Wrong type detection for sql type char(x) columns

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304?page=c... ] Bart Vanhaute commented on HHH-2304: ------------------------------------ (Using mysql 5.0) when the data in the column is the empty string, I get: java.lang.StringIndexOutOfBoundsException: String index out of range: 0 at java.lang.String.charAt(String.java:558) at org.hibernate.type.CharacterType.get(CharacterType.java:29) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:163) at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:189) at org.hibernate.loader.custom.CustomLoader$ScalarResultColumnProcessor.extract(CustomLoader.java:474) at org.hibernate.loader.custom.CustomLoader$ResultRowProcessor.buildResultRow(CustomLoader.java:420) at org.hibernate.loader.custom.CustomLoader.getResultColumnOrRow(CustomLoader.java:317) at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:614) at org.hibernate.loader.Loader.doQuery(Loader.java:709) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:244) at org.hibernate.loader.Loader.doList(Loader.java:2228) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2112) at org.hibernate.loader.Loader.list(Loader.java:2107) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:289) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1695) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:142) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:152) at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:66) I have found the following workaround for native queries: instead of select val from table do select cast(val as char) from table

...

Wrong type detection for sql type char(x) columns ------------------------------------------------- Key: HHH-2304 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.2.0.ga Environment: Hibernate 3.2.0, Oracle 9.2, Oracle JDBC driver 10.2 Reporter: Markus Heiden Attachments: hibernate.zip When executing a sql query which returns columns of sql type char(x), a java.lang.Character is returned. This leads to returning just the first character of the value. In my eyes a String should be returned when the char(x) type has a width > 1. I wasn't able to determine whether this is a jdbc driver issue or a hibernate issue. When using sql type char(x) for columns of entities no such problems occur. Test case is attached.

Julien Kronegg (JIRA)

Friday, 13 March Fri, 13 Mar

9:27 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2304) Wrong type detection for sql type char(x) columns

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304?page=c... ] Julien Kronegg commented on HHH-2304: ------------------------------------- Hibernate version: 3.3.1.GA Database: DB2 DSN08015 JDBC driver version : IBM DB2 JDBC Universal Driver Architecture 2.3.63 Hibernate Dialect: DB2390Dialect I'm having a table with CHAR(8) which is mapped into a java.lang.Character when doing a native query : List<Object> x = entityManager.createNativeQuery("select charEightColumn from myTable").getResultList(); Thus, the column value is truncated to 1 character. I expected to have a type mapping to java.lang.String (or at least a char[], but not truncated string on a Character). I applied Krashan Brahmanjara's patch for org.hibernate.dialect.Dialect (but I did not modify the CustomLoader as proposed above) : registerHibernateType( Types.BIT, Hibernate.BOOLEAN.getName() ); - registerHibernateType( Types.CHAR, Hibernate.CHARACTER.getName() ); + registerHibernateType( Types.CHAR,1, Hibernate.CHARACTER.getName() ); + registerHibernateType( Types.CHAR,255, Hibernate.STRING.getName() ); registerHibernateType( Types.DATE, Hibernate.DATE.getName() ); registerHibernateType( Types.DOUBLE, Hibernate.DOUBLE.getName() ) The CHAR(8) column is now mapped correctly. One strange thing is that this issue is very old and nobody seems to care about. Is it really an Hibernate issue, or is it something else (e.g. bad usage) ?

...

Wrong type detection for sql type char(x) columns ------------------------------------------------- Key: HHH-2304 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.2.0.ga Environment: Hibernate 3.2.0, Oracle 9.2, Oracle JDBC driver 10.2 Reporter: Markus Heiden Attachments: hibernate.zip When executing a sql query which returns columns of sql type char(x), a java.lang.Character is returned. This leads to returning just the first character of the value. In my eyes a String should be returned when the char(x) type has a width > 1. I wasn't able to determine whether this is a jdbc driver issue or a hibernate issue. When using sql type char(x) for columns of entities no such problems occur. Test case is attached.

Julien Kronegg (JIRA)

9:36 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2304) Wrong type detection for sql type char(x) columns

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304?page=c... ] Julien Kronegg commented on HHH-2304: ------------------------------------- See also http://forums.hibernate.org/viewtopic.php?t=960949&start=0&postda...

...

Wrong type detection for sql type char(x) columns ------------------------------------------------- Key: HHH-2304 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.2.0.ga Environment: Hibernate 3.2.0, Oracle 9.2, Oracle JDBC driver 10.2 Reporter: Markus Heiden Attachments: hibernate.zip When executing a sql query which returns columns of sql type char(x), a java.lang.Character is returned. This leads to returning just the first character of the value. In my eyes a String should be returned when the char(x) type has a width > 1. I wasn't able to determine whether this is a jdbc driver issue or a hibernate issue. When using sql type char(x) for columns of entities no such problems occur. Test case is attached.

Julien Kronegg (JIRA)

Friday, 7 August Fri, 7 Aug

8:24 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2304) Wrong type detection for sql type char(x) columns

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304?page=c... ] Julien Kronegg commented on HHH-2304: ------------------------------------- A cleaner workaround is to define a new Dialect: public class DialectHhh2304 extends DB2390Dialect { public DialectHhh2304() { super(); // workaround for http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304 registerHibernateType( Types.CHAR,1, Hibernate.CHARACTER.getName() ); registerHibernateType( Types.CHAR,255, Hibernate.STRING.getName() ); } } Then to use instead of the original dialect (e.g. in the persistence.xml file). I think defining a new dialect is safer than using "char(xxx as char)" (I did not test it BTW).

...

Wrong type detection for sql type char(x) columns ------------------------------------------------- Key: HHH-2304 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.2.0.ga Environment: Hibernate 3.2.0, Oracle 9.2, Oracle JDBC driver 10.2 Reporter: Markus Heiden Attachments: hibernate.zip When executing a sql query which returns columns of sql type char(x), a java.lang.Character is returned. This leads to returning just the first character of the value. In my eyes a String should be returned when the char(x) type has a width > 1. I wasn't able to determine whether this is a jdbc driver issue or a hibernate issue. When using sql type char(x) for columns of entities no such problems occur. Test case is attached.

Krashan Brahmanjara (JIRA)

Thursday, 4 March Thu, 4 Mar

9:16 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2304) Wrong type detection for sql type char(x) columns

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304?page=c... ] Krashan Brahmanjara commented on HHH-2304: ------------------------------------------ Hi It still doesn't work correctly (without patch) on jboss-5.1.0.GA with Hibernate 3.3.1.GA. Native queries on temporary tables called from manager.createNativeQuery returns single Character instead String

...

Wrong type detection for sql type char(x) columns ------------------------------------------------- Key: HHH-2304 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.2.0.ga Environment: Hibernate 3.2.0, Oracle 9.2, Oracle JDBC driver 10.2 Reporter: Markus Heiden Attachments: hibernate.zip When executing a sql query which returns columns of sql type char(x), a java.lang.Character is returned. This leads to returning just the first character of the value. In my eyes a String should be returned when the char(x) type has a width > 1. I wasn't able to determine whether this is a jdbc driver issue or a hibernate issue. When using sql type char(x) for columns of entities no such problems occur. Test case is attached.

Ufuk Cemen (JIRA)

Tuesday, 17 August Tue, 17 Aug

3:28 p.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2304) Wrong type detection for sql type char(x) columns

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304?page=c... ] Ufuk Cemen commented on HHH-2304: --------------------------------- Tried Bart Vanhaute's work around : "I have found the following workaround for native queries: instead of select val from table do select cast(val as char) from table" it didn't work but : " select cast(val as varchar) from table " works fine , because the issue already hibernate assumes the value is a char not a string.

...

Wrong type detection for sql type char(x) columns ------------------------------------------------- Key: HHH-2304 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.2.0.ga Environment: Hibernate 3.2.0, Oracle 9.2, Oracle JDBC driver 10.2 Reporter: Markus Heiden Attachments: hibernate.zip When executing a sql query which returns columns of sql type char(x), a java.lang.Character is returned. This leads to returning just the first character of the value. In my eyes a String should be returned when the char(x) type has a width > 1. I wasn't able to determine whether this is a jdbc driver issue or a hibernate issue. When using sql type char(x) for columns of entities no such problems occur. Test case is attached.

Strong Liu (JIRA)

Thursday, 13 October Thu, 13 Oct

5:08 a.m.

New subject: [Hibernate-JIRA] Commented: (HHH-2304) Wrong type detection for sql type char(x) columns

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304?page=c... ] Strong Liu commented on HHH-2304: --------------------------------- https://issues.jboss.org/browse/JBPAPP-7291

...

Wrong type detection for sql type char(x) columns ------------------------------------------------- Key: HHH-2304 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.2.0.ga Environment: Hibernate 3.2.0, Oracle 9.2, Oracle JDBC driver 10.2 Reporter: Markus Heiden Attachments: hibernate.zip When executing a sql query which returns columns of sql type char(x), a java.lang.Character is returned. This leads to returning just the first character of the value. In my eyes a String should be returned when the char(x) type has a width > 1. I wasn't able to determine whether this is a jdbc driver issue or a hibernate issue. When using sql type char(x) for columns of entities no such problems occur. Test case is attached.

-- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

Strong Liu (JIRA)

5:08 a.m.

New subject: [Hibernate-JIRA] Assigned: (HHH-2304) Wrong type detection for sql type char(x) columns

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304?page=c... ] Strong Liu reassigned HHH-2304: ------------------------------- Assignee: Strong Liu

...

Wrong type detection for sql type char(x) columns ------------------------------------------------- Key: HHH-2304 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.2.0.ga Environment: Hibernate 3.2.0, Oracle 9.2, Oracle JDBC driver 10.2 Reporter: Markus Heiden Assignee: Strong Liu Attachments: hibernate.zip When executing a sql query which returns columns of sql type char(x), a java.lang.Character is returned. This leads to returning just the first character of the value. In my eyes a String should be returned when the char(x) type has a width > 1. I wasn't able to determine whether this is a jdbc driver issue or a hibernate issue. When using sql type char(x) for columns of entities no such problems occur. Test case is attached.

-- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

Strong Liu (JIRA)

8:30 a.m.

New subject: [Hibernate-JIRA] Resolved: (HHH-2304) Wrong type detection for sql type char(x) columns

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304?page=c... ] Strong Liu resolved HHH-2304. ----------------------------- Resolution: Fixed Fix Version/s: 4.0.0.next 3.6.8

...

Wrong type detection for sql type char(x) columns ------------------------------------------------- Key: HHH-2304 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-2304 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.2.0.ga Environment: Hibernate 3.2.0, Oracle 9.2, Oracle JDBC driver 10.2 Reporter: Markus Heiden Assignee: Strong Liu Fix For: 3.6.8, 4.0.0.next Attachments: hibernate.zip When executing a sql query which returns columns of sql type char(x), a java.lang.Character is returned. This leads to returning just the first character of the value. In my eyes a String should be returned when the char(x) type has a width > 1. I wasn't able to determine whether this is a jdbc driver issue or a hibernate issue. When using sql type char(x) for columns of entities no such problems occur. Test case is attached.

-- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

4775

days inactive

6541

days old

hibernate-issues@lists.jboss.org

Manage subscription

13 comments

8 participants

tags (0)

participants (8)

Bart Vanhaute (JIRA)
Jair Tinoco (JIRA)
Julien Kronegg (JIRA)
Krashan Brahmanjara (JIRA)
Markus Heiden (JIRA)
Stephen Friedrich (JIRA)
Strong Liu (JIRA)
Ufuk Cemen (JIRA)

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

[Hibernate-JIRA] Created: (HHH-2304) Wrong type detection for sql type char(x) columns