oracle No Dialect mapping for JDBC type-9错误

╰+攻爆jí腚メ 2023-06-19 11:10 1阅读 0赞

错误原因：使用的是Hibernate映射的数据库方言，数据库字段是NVARCHAR2()，NVARCHAR2()类型映射不到Java数据类型

Oracle10gDialect中没有注册NVARCHAR和NCLOB数据类型

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FtZWxpYV9fUQ_size_16_color_FFFFFF_t_70][]

一、重写方言类  ，重新定义Oracle字段与Java类型的映射

package com.modules.sys.utils;
    
    import java.sql.Types;
    
    import org.hibernate.dialect.Oracle10gDialect;
    import org.hibernate.type.StandardBasicTypes;
    
    public class MyOracleDialect extends Oracle10gDialect
    {
        public MyOracleDialect(){
            super();
            registerHibernateType(Types.CHAR, StandardBasicTypes.STRING.getName());
            registerHibernateType(Types.NVARCHAR, StandardBasicTypes.STRING.getName());
            registerHibernateType(Types.LONGNVARCHAR, StandardBasicTypes.STRING.getName());
            registerHibernateType(Types.DECIMAL, StandardBasicTypes.DOUBLE.getName());
            registerHibernateType(Types.NCLOB, StandardBasicTypes.STRING.getName());
        }
    }

二、修改Hibernate配置文件  dialect指向自定义的方言类

<bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean"> 
       <property name="dataSource" ref="dataSource"/>
       <property name="packagesToScan" value="com.greatmap"/>
       <property name="hibernateProperties">
          <props>
             <prop key="hibernate.dialect">com.modules.sys.utils.MyOracleDialect</prop>
             <prop key="hibernate.cache.region.factory_class">org.hibernate.cache.ehcache.EhCacheRegionFactory</prop>
             <prop key="net.sf.ehcache.configurationResourceName">${hibernate.ehcache.configFile}</prop>
             <prop key="hibernate.cache.use_second_level_cache">false</prop>
             <prop key="hibernate.cache.use_query_cache">false</prop>
             <prop key="hibernate.show_sql">${hibernate.show_sql}</prop>
             <prop key="hibernate.format_sql">${hibernate.format_sql}</prop>
             <prop key="hibernate.hbm2ddl.auto">${hibernate.hbm2ddl.auto}</prop>
          </props>
       </property>
    </bean>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FtZWxpYV9fUQ_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191206102826895.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0FtZWxpYV9fUQ==,size_16,color_FFFFFF,t_70