[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-1806) No Dialect mapping for JDBC type: 3

[Steve Ebersole (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-1806?page=comments#action_24025 ] 

Steve Ebersole commented on HHH-1806:
-------------------------------------

to me it seems to make more sense to:
1) register the hibernate type mapping at the Dialect-level.  For all/most databases, DECIMAL should also map to Hibernate'd BigDecimalType
2) register the datatype at the Oracle9Dialect-level, since this is true of all Oracle setups.  Apparently the distinction is that the Oracle drivers just never report DECIMAL types?

> No Dialect mapping for JDBC type: 3
> -----------------------------------
>
>          Key: HHH-1806
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-1806
>      Project: Hibernate3
>         Type: Bug

>   Components: core
>     Versions: 3.1.2, 3.1.3
>  Environment: Oracle JDBC driver with the Hibernate DataDirectOracle9Dialect.
>     Reporter: amit bhayani

>
>
> Hibernate throws "No Dialect mapping for JDBC type: 3" when using Oracle JDBC driver with the Hibernate DataDirectOracle9Dialect.
> DataDirect Connect for JDBC Oracle driver returns the JDBC type DECIMAL for some result set columns however there was no mapping set up in the DataDirectOracle9Dialect for the DECIMAL JDBC type.
> The work arround for issue is to  add the following constructor to DataDirectOracle9Dialect
> public DataDirectOracle9Dialect() {
> super();
> registerColumnType( Types.DECIMAL, "number($p,$s)" );
> registerHibernateType(Types.DECIMAL, "big_decimal");
> }
> Can Hibernate Team add this constructor or something similar to the DataDirectOracle9Dialect?
> Version Info
> Hibernate: 3.1.3
> DataDirect
> Connect for JDBC
> Oracle driver: 3.5.40
> Forum reference http://forum.hibernate.org/viewtopic.php?t=959583&highlight=dialect+mapping+jdbc+type+3

-- 
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
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira