spring jdbctemplate what Type for Raw Invalid column Type

Viewed 1323

Java - Spring JDBC - oracle

my table looks like

id, RAW(16)
name, varchar(50)

@Autowired

    private JdbcTemplate jdbcTemplate;

String queryStr = "insert into myt (id, name) values(:id, :name)";

MapSqlParameterSource param = new MapSqlParameterSource();
param.addValue("id", UUID.randomUUID(), Types.Binary);
param.addValue("name", "my name", Types.VARCHAR);

jdbcTemplate.update(queryStr, param);

I am getting error java.sql.SQLException Invalid column Type

1 Answers
Related