OLÁ PESSOAL,
Estou tentando inserir um xml no banco de dados e está aparecendo esse erro:
Caused by: java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
Statement stm = conn.createStatement();
File arquivo = new File("c:\\temp2\\jobteste.xml");
FileInputStream fis = new FileInputStream(arquivo);
InputStream value = null;
value = (InputStream)fis;
stm.executeUpdate(SQL);*/
PreparedStatement ps = conn.prepareStatement("INSERT INTO INPE_XML VALUES values(?,?,?,?,?,?,?)");
ps.setInt(1, 2);
ps.setString(2, "JOB TESTE2");
ps.setString(3, " ");
ps.setString(4, "TRIGGER 2");
ps.setString(5, "GRUPO 2");
ps.setInt(6, 0);
ps.setBinaryStream(7, value);
ps.execute();
TABLE
ipjob_id number(10)
ipjob_ds varchar2(80)
ipjob_dt_processamento date
ipjob_ds_trigger varchar2(80)
ipjob_ds_grupo varchar2(80)
ipjob_st_job number(2)
ipjob_xml blob