9:40 a.m.
Incorrect type of SQLServer column for Java 'float' field
---------------------------------------------------------
Key: HHH-3055
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3055
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.1
Environment: Hibernate Annotations 3.3.0.GA
Hibernate EntityManager 3.3.1.GA
Hibernate 3.2.1
Microsoft SQL Server, version: 9.00.3042
Microsoft SQL Server 2005 JDBC Driver, version: 1.1.1501.101
Reporter: Guillaume Grussenmeyer
When mapping a Java field of type 'float' to a SQLServer table, the corresponding
database column is created with type 'float', which is not correct as SQL Server
floats are double precision, while Java floats are simple precision.
The corresponding column should be created with type "real".
--
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
9:44 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3055) Incorrect type of SQLServer column for Java 'float' field
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3055?page=c...
]
Guillaume Grussenmeyer commented on HHH-3055:
---------------------------------------------
It seems to me that there is something wrong with org.hibernate.type.FloatType: its
'sqlType' method returns 'Types.FLOAT', while it uses 'setFloat'
to set the value in the PreparedStatement.
Dixit PreparedStatement.setFloat javadoc: "The driver converts this to an SQL REAL
value when it sends it to the database.".
Why isn't FloatType returning Types.REAL as 'sqlType()' ?
Incorrect type of SQLServer column for Java 'float' field
---------------------------------------------------------
Key: HHH-3055
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3055
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.1
Environment: Hibernate Annotations 3.3.0.GA
Hibernate EntityManager 3.3.1.GA
Hibernate 3.2.1
Microsoft SQL Server, version: 9.00.3042
Microsoft SQL Server 2005 JDBC Driver, version: 1.1.1501.101
Reporter: Guillaume Grussenmeyer
When mapping a Java field of type 'float' to a SQLServer table, the corresponding
database column is created with type 'float', which is not correct as SQL Server
floats are double precision, while Java floats are simple precision.
The corresponding column should be created with type "real".
--
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
10 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3055) Incorrect type of SQLServer column for Java 'float' field
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3055?page=c...
]
Guillaume Grussenmeyer commented on HHH-3055:
---------------------------------------------
Moreover, the Sun JDBC documentation
(http://java.sun.com/javase/6/docs/technotes/guides/jdbc/getstart/mapping....) states
that "The recommended Java mapping for the FLOAT type is as a Java double" and
"The recommended Java mapping for the REAL type is as a Java float.".
Incorrect type of SQLServer column for Java 'float' field
---------------------------------------------------------
Key: HHH-3055
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3055
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.1
Environment: Hibernate Annotations 3.3.0.GA
Hibernate EntityManager 3.3.1.GA
Hibernate 3.2.1
Microsoft SQL Server, version: 9.00.3042
Microsoft SQL Server 2005 JDBC Driver, version: 1.1.1501.101
Reporter: Guillaume Grussenmeyer
When mapping a Java field of type 'float' to a SQLServer table, the corresponding
database column is created with type 'float', which is not correct as SQL Server
floats are double precision, while Java floats are simple precision.
The corresponding column should be created with type "real".
--
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
10:02 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3055) Incorrect type of SQLServer column for Java 'float' field
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3055?page=c...
]
Guillaume Grussenmeyer commented on HHH-3055:
---------------------------------------------
This problem can easily be worked around by letting a customer dialect registering
"real" as column type for Types.FLOAT.
However, this registration breaks the fact that SQL FLOAT are double precision ones.
Incorrect type of SQLServer column for Java 'float' field
---------------------------------------------------------
Key: HHH-3055
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3055
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.1
Environment: Hibernate Annotations 3.3.0.GA
Hibernate EntityManager 3.3.1.GA
Hibernate 3.2.1
Microsoft SQL Server, version: 9.00.3042
Microsoft SQL Server 2005 JDBC Driver, version: 1.1.1501.101
Reporter: Guillaume Grussenmeyer
When mapping a Java field of type 'float' to a SQLServer table, the corresponding
database column is created with type 'float', which is not correct as SQL Server
floats are double precision, while Java floats are simple precision.
The corresponding column should be created with type "real".
--
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
10:06 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3055) Incorrect type of SQLServer column for Java 'float' field
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3055?page=c...
]
Guillaume Grussenmeyer commented on HHH-3055:
---------------------------------------------
"customer" shall read "custom" (gasp, I can't edit my own
comments)
Incorrect type of SQLServer column for Java 'float' field
---------------------------------------------------------
Key: HHH-3055
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3055
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.1
Environment: Hibernate Annotations 3.3.0.GA
Hibernate EntityManager 3.3.1.GA
Hibernate 3.2.1
Microsoft SQL Server, version: 9.00.3042
Microsoft SQL Server 2005 JDBC Driver, version: 1.1.1501.101
Reporter: Guillaume Grussenmeyer
When mapping a Java field of type 'float' to a SQLServer table, the corresponding
database column is created with type 'float', which is not correct as SQL Server
floats are double precision, while Java floats are simple precision.
The corresponding column should be created with type "real".
--
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
11:13 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3055) Incorrect type of SQLServer column for Java 'float' field
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3055?page=c...
]
Anthony Ogier commented on HHH-3055:
------------------------------------
Actually it doesn't seem to be enough ... finally I did like you, creating my own
dialect, extending org.hibernate.dialect.SQLServerDialect and including that code into the
constructor :
registerColumnType( Types.FLOAT, "real" );
But then, every Entity using java Float fields must map to a "real" type field
in the database. Moreover, if the database contains "float" fields, then one
must add a mapping to another java type ...
I'm not sure it's the good solution to handle SQL Server "real" type
into hibernate...
Incorrect type of SQLServer column for Java 'float' field
---------------------------------------------------------
Key: HHH-3055
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3055
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.1
Environment: Hibernate Annotations 3.3.0.GA
Hibernate EntityManager 3.3.1.GA
Hibernate 3.2.1
Microsoft SQL Server, version: 9.00.3042
Microsoft SQL Server 2005 JDBC Driver, version: 1.1.1501.101
Reporter: Guillaume Grussenmeyer
When mapping a Java field of type 'float' to a SQLServer table, the corresponding
database column is created with type 'float', which is not correct as SQL Server
floats are double precision, while Java floats are simple precision.
The corresponding column should be created with type "real".
--
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
12:43 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3055) Incorrect type of SQLServer column for Java 'float' field
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3055?page=c...
]
Guillaume Grussenmeyer commented on HHH-3055:
---------------------------------------------
Hi Anthony,
concerning the fact that "every Entity using java Float fields must map to a
"real" type field in the database", that's precisely what we're
trying to achieve: not doing so will led to precision loss during database data reading
(trying to stuff a double-precision data (db level) into a single-precision one (java
level)).
If your database contains "float" fields, they should be mapped as
"double" in Java. In that case, Hibernate will use JDBC DOUBLE type (as per
org.hibernate.type.DoubleType), so there is no need to add another mapping.
Another solution is not to use any float Java fields and use doubles instead.
Incorrect type of SQLServer column for Java 'float' field
---------------------------------------------------------
Key: HHH-3055
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3055
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.1
Environment: Hibernate Annotations 3.3.0.GA
Hibernate EntityManager 3.3.1.GA
Hibernate 3.2.1
Microsoft SQL Server, version: 9.00.3042
Microsoft SQL Server 2005 JDBC Driver, version: 1.1.1501.101
Reporter: Guillaume Grussenmeyer
When mapping a Java field of type 'float' to a SQLServer table, the corresponding
database column is created with type 'float', which is not correct as SQL Server
floats are double precision, while Java floats are simple precision.
The corresponding column should be created with type "real".
--
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
4:50 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-3055) Incorrect type of SQLServer column for Java 'float' field
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-3055?page=c...
]
Guillaume Grussenmeyer commented on HHH-3055:
---------------------------------------------
In order not to have Hibernate schema validation telling you your DB schema is invalid
because "double" Java fields are mapped to "float" columns, one must
also add the following registration in her custom dialect:
registerColumnTyp( Types.DOUBLE, "float" );
Else, Hibernate will complain that the double Java field is mapped to a "float"
column while it should be mapped to a "double precision" one (although the
column was created by Hibernate itself...).
Incorrect type of SQLServer column for Java 'float' field
---------------------------------------------------------
Key: HHH-3055
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-3055
Project: Hibernate3
Issue Type: Bug
Components: core
Affects Versions: 3.2.1
Environment: Hibernate Annotations 3.3.0.GA
Hibernate EntityManager 3.3.1.GA
Hibernate 3.2.1
Microsoft SQL Server, version: 9.00.3042
Microsoft SQL Server 2005 JDBC Driver, version: 1.1.1501.101
Reporter: Guillaume Grussenmeyer
When mapping a Java field of type 'float' to a SQLServer table, the corresponding
database column is created with type 'float', which is not correct as SQL Server
floats are double precision, while Java floats are simple precision.
The corresponding column should be created with type "real".
--
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
6013
days inactive
6149
days old
hibernate-issues@lists.jboss.org
7 comments
2 participants
participants (2)
-
Anthony Ogier (JIRA) -
Guillaume Grussenmeyer (JIRA)