Trouble with oracle sql in java [duplicate]

Question

Hi I am currently testing out a large PreparedStatement, but I seemed to be stuck in the rut. At the moment I have an error "Caused by: Error : 933, Position : 243"

Here is my code for reference:

//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, "[email protected]");
    pstmt.setString(8, msg.getSubject());
    pstmt.setString(9, "[email protected]");
    pstmt.setClob(10, clob);
    pstmt.setString(11, "Generic User123");
    pstmt.setDate(12,date);
    pstmt.setDate(13,date);
    pstmt.execute();

    System.out.println("Done");

show your full error

Scary Wombat
– Scary Wombat

2017-06-23 04:04:28 +00:00
Commented Jun 23, 2017 at 4:04 — Scary Wombat
– Scary Wombat, Commented Jun 23, 2017 at 4:04
maybe use executeUpdate

Scary Wombat
– Scary Wombat

2017-06-23 04:06:59 +00:00
Commented Jun 23, 2017 at 4:06 — Scary Wombat
– Scary Wombat, Commented Jun 23, 2017 at 4:06

Norbert · Accepted Answer · 2017-06-23 03:17:43Z

1

The ; should be removed:

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(?,?,?,?,?,?,?,?,?,?,?,?,?);";

should read:

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(?,?,?,?,?,?,?,?,?,?,?,?,?)";

For the rest: I can not count the characters as given from your error, so your error might or might not be solved by this....

answered Jun 23, 2017 at 3:17

Norbert

6,1043 gold badges19 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Scary Wombat Over a year ago

are you sure - see stackoverflow.com/questions/18941539/…

Norbert Over a year ago

Yes, look at the comments at the accepted answer there regarding the multiple statements and semi column

Scary Wombat Over a year ago

what multiple statements has this OP got? One single insert

Norbert Over a year ago

Still the ; works disruptive in this. That is not said that it is the error observed. So the user will have to test and see if it resolves (user seems to be offline).

Scary Wombat Over a year ago

see also stackoverflow.com/questions/10914269/… -- basically it would appear that your answer (at best) not useful or (at worst) is wrong

|

Collectives™ on Stack Overflow

Trouble with oracle sql in java [duplicate]

1 Answer 1

8 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Linked

Related