[Hibernate-issues] [Hibernate-JIRA] Commented: (HB-465) Floats truncated with Oracle 9i

[<leg...@at...>]

The following comment has been added to this issue:

     Author: Jose Raya
    Created: Wed, 12 Nov 2003 12:07 PM
       Body:
I don't have a full log but I have a snip.
As you can see, the value for parameter 8 gets to the PreparedStatement but is truncated on saving.

DEBUG-12/11 17:42:34,304-SessionFactoryImpl-prepared statement get: update DescripcioAssignatura set assignaturaId=?, descripcioLlarga=?, descripcioCurta=?, curs=?, horesCalculades=?, departamentId=?, coordinadorDescripcio=?, factorHoresCredit=?, ensenyament=? where id=?
DEBUG-12/11 17:42:34,304-SessionFactoryImpl-preparing statement
DEBUG-12/11 17:42:34,314-EntityPersister-Dehydrating entity: es.castinfo.ub.domain.DescripcioAssignatura#DescripcioAssignatura-9
DEBUG-12/11 17:42:34,314-StringType-binding 'ASS-11' to parameter: 1
DEBUG-12/11 17:42:34,314-StringType-binding 'DescripcioAssignatura-9/descripcioLlarga' to parameter: 2
DEBUG-12/11 17:42:34,314-StringType-binding 'DescripcioAssignatura-9/descripcioCurta' to parameter: 3
DEBUG-12/11 17:42:34,314-StringType-binding 'C1' to parameter: 4
DEBUG-12/11 17:42:34,314-BooleanType-binding 'false' to parameter: 5
DEBUG-12/11 17:42:34,314-StringType-binding 'DEPT1' to parameter: 6
DEBUG-12/11 17:42:34,314-LongType-binding '1' to parameter: 7
DEBUG-12/11 17:42:34,324-FloatType-binding '0.5' to parameter: 8
DEBUG-12/11 17:42:34,324-StringType-binding 'ENS1' to parameter: 9
DEBUG-12/11 17:42:34,324-StringType-binding 'DescripcioAssignatura-9' to parameter: 10
DEBUG-12/11 17:42:34,324-BatcherImpl-Adding to batch
DEBUG-12/11 17:42:34,324-BatcherImpl-Executing batch size: 1
DEBUG-12/11 17:42:34,324-BatcherImpl-done closing: 0 open PreparedStatements, 0 open ResultSets

---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-465


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-465
    Summary: Floats truncated with Oracle 9i
       Type: Bug

     Status: Unassigned
   Priority: Major

    Project: Hibernate2
 Components: 
             core
   Versions:
             2.0.3

   Assignee: 
   Reporter: Jose Raya

    Created: Wed, 12 Nov 2003 12:05 PM
    Updated: Wed, 12 Nov 2003 12:05 PM
Environment: Oracle 9i (don't know exact version number) with Oracle9i dialect
Oracle thin driver
Oracle9iAS (9.0.3.0.0)
jdk 1.3.1_06 for Windows (2000)
Hibernate version 2.0.3, 27 August 2003 

Description:
As a post in your forum says:
"the float mapping using oracle 9i (9.2.0.1) does NOT work, while double works fine. whenever we store a float value, it is truncated to an integer value. changing the mapping and the bean to double works like expected. I use the right jdbc driver for our version, like provided by oracle and I use jdk 1.4.2."

See post at http://forum.hibernate.org/viewtopic.php?p=2177880#2177880



---------------------------------------------------------------------
JIRA INFORMATION:
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.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira