title: Spring: JDBC Template Invalid column type
body: <p>Using the following code to get the list of data from table but getting invalid column error.</p>
  
  <pre><code>String sql = "select * from employees  WHERE emp_status = :statusCode";
  Map parameters = new HashMap();
  parameters.put("statusCode", "Active");
  MapSqlParameterSource parametersSourceMap = new MapSqlParameterSource(parameters );
  
  List&lt;Employee&gt; employees rowSet = jdbcTemplate.queryForList(sql, parametersSourceMap);
  </code></pre>
  
  <p><strong>Exception</strong></p>
  
  <pre><code>Exception in thread "main" org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [select * from employees  WHERE emp_status = :statusCode SQL state [null]; error code [17004]; Invalid column type; nested exception is java.sql.SQLException: Invalid column type
          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)
          at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:812)
          at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:868)
          at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:876)
          at com.spring.EmployeeDAOImpl.addEmployee(EmployeeDAOImpl.java:46)
          at com.spring.MainApp.main(MainApp.java:33)
      Caused by: java.sql.SQLException: Invalid column type
  </code></pre>
  
  <p>Table have column as Varchar2</p>
  
  <p>Anyone have idea why we can't get data based on String column? </p>