java - java中oracle sql的问题

Question

这个问题已经有答案了:

Converting from String to Clob using setString() not working (3 个回答)

已关闭 6 年前。

嗨，我目前正在测试一个大型的PreparedStatement，但我似乎陷入了困境。目前我有一个错误“引起:错误:933，位置:243”

这是我的引用代码:

//Create a query string
    String sqlQuery=null;
    sqlQuery="insert into tbl_email_template(template_code,template_file_name,template_file,status,"
            + "system,type,email_from,email_subject,email_reply_to,email_content,uploaded_by,"
            + "dcreate,dmodify) values(?,?,?,?,?,?,?,?,?,?,?,?,?);";

    System.out.println(sqlQuery);
    System.out.println("Total:"+rsmd.getColumnCount());
    Clob clob = con.createClob();

    File file = new File("template.msg");
    MapiMessage msg = MapiMessage.fromFile(file.toString());
    FileInputStream fis = new FileInputStream(file);

    clob.setString(1, msg.getBody());

    Date date = new Date(1,2,3);

    PreparedStatement pstmt = con.prepareStatement(sqlQuery);
    pstmt.setString(1, "haha");
    pstmt.setString(2, file.getName());
    pstmt.setBlob(3, fis,file.length());
    pstmt.setString(4, "A");
    pstmt.setString(5, "MRS");
    pstmt.setString(6, "BK");
    pstmt.setString(7, "haha@hoho.hk");
    pstmt.setString(8, msg.getSubject());
    pstmt.setString(9, "harhar@hehe.hk");
    pstmt.setClob(10, clob);
    pstmt.setString(11, "Generic User123");
    pstmt.setDate(12,date);
    pstmt.setDate(13,date);
    pstmt.execute();

    System.out.println("Done");

Answer 1

;应删除:

sqlQuery="insert into tbl_email_template(template_code,template_file_name,template_file,status,"
        + "system,type,email_from,email_subject,email_reply_to,email_content,uploaded_by,"
        + "dcreate,dmodify) values(?,?,?,?,?,?,?,?,?,?,?,?,?);";

应阅读:

sqlQuery="insert into tbl_email_template(template_code,template_file_name,template_file,status,"
        + "system,type,email_from,email_subject,email_reply_to,email_content,uploaded_by,"
        + "dcreate,dmodify) values(?,?,?,?,?,?,?,?,?,?,?,?,?)";

对于其余的:我无法计算您的错误中给出的字符，因此您的错误可能会或可能不会由此解决......