title: MyBatis - jdbcTypeForNull Oracle
body: <p>I am using MyBatis with an Oracle 11g R2 database. I am using MyBatis 3.3 with ojdbc6 12.1.0.2. My issue is whenever I tried to insert an object that is null I get the following.</p>
  
  <blockquote>
    <p>org.springframework.jdbc.UncategorizedSQLException: Error setting null
    for parameter #8 with JdbcType OTHER . Try setting a different
    JdbcType for this parameter or a different jdbcTypeForNull
    configuration property. Cause: java.sql.SQLException: Invalid column
    type: 1111</p>
  </blockquote>
  
  <p>My understanding is in the latest version of JDBC null is mapped to JdbcType.OTHERS which no all drivers handle, apparently Oracle is one of them.</p>
  
  <p>I tried the following in my MyBatis configuration, but still no luck.</p>
  
  <pre><code>    @Bean
      public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws Exception {
          final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
          sessionFactory.setDataSource(dataSource);
          sessionFactory.setTypeAliasesPackage("org.ohtech.innovationexchange.core.domain");
          sessionFactory.setTransactionFactory(springManagedTransactionFactory());
          sessionFactory.setConfigurationProperties(getProperties());
          return sessionFactory.getObject();
      }
  
      @Bean(name = "transactionManager")
      public DataSourceTransactionManager dataSourceTransactionManager() throws PropertyVetoException{
          return new DataSourceTransactionManager(dataSource());
      }
  
      @Bean
      public SpringManagedTransactionFactory springManagedTransactionFactory() {
          return new SpringManagedTransactionFactory();
      }
  
      private Properties getProperties() {
          final Properties myBatisProperties = new Properties();
          myBatisProperties.put("jdbcTypeForNull", "NULL");
          return myBatisProperties;
      }
  </code></pre>
  
  <p>I can make it work by doing the following in my mapper files but it seems really repetitive and ugly. Not sure why MyBatis is not using my properties I am passing the SqlSessionFactory bean.</p>