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

[daniel f. (JIRA) <no...@at...>]

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

daniel flesner commented on HHH-1806:
-------------------------------------

this also appears to be broken on mysql 5.0.22 and mysql-connector-java 3.1.13. the following select "select avg(score), std(score), min(score), max(score) from score_raw" throws the same exception. hibernate version 3.1.3.

> 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