JDBC THIN gives Oracle invalid character error, though SQL works fine in TOAD

[sarah gri]

Hi,
When I submit this code in Tomcat, get invalid character error, but when print statement to log and execute it in TOAD no problem; record inserts fine.
Thanks in advance for any help
Code

  
    try {
      Statement stmt = conns.createStatement ();
      String insert = "insert into SEQREQ_AUDIT (SEQREQ_AUDIT_ID, LABHEAD, PROGRAMME, LABJOURNAL, ORGANISM, TISSUE,";
      insert=insert.concat("CELL_LINE, RDS1, RDS2, NTUSER, COUNTRY, DATE_CREATED, SSP, SEQ_SUBMISSION,FL_ID) ");
      insert=insert.concat(" values ('"+SEQREQ_AUDIT_ID+"','"+LABHEAD+"','"+PROGRAMME+"','"+LABJOURNAL+"',");
      insert=insert.concat("'"+ORGANISM+"','"+TISSUE+"','"+CELL_LINE+"','"+RDS1+"','"+RDS2+"','"+NTUSER+"',");
      insert=insert.concat("'"+COUNTRY+"',SYSDATE,'"+SSP+"','"+SEQ_SUBMISSION+"','"+FL_ID+"');");
      System.err.println("SQL insert: "+insert);
      stmt.executeUpdate(insert);
    }
    catch (SQLException e){
      e.getMessage();
      System.err.println("Error-Insert record:" +e + e.getMessage());
      message = ("ERROR - INSERT RECORD");
    }
[B]Logs[/B]
SQL insert: insert into SEQREQ_AUDIT (SEQREQ_AUDIT_ID, LABHEAD, PROGRAMME, LABJOURNAL, ORGANISM, TISSUE,CELL_LINE, RDS1, RDS2, NTUSER, COUNTRY, DATE_CREATED, SSP, SEQ_SUBMISSION,FL_ID)  values ('419','Wilel, Ralf','myprog','mynote','leishmania major','','','','','gsarah1','null',SYSDATE,'LAB23','1','');
Error-Insert record:java.sql.SQLException: ORA-00911: invalid character
ORA-00911: invalid character

[sarah gri]

OOps - solved it myself - sorry!
I had to remove the final semicolon from the statement...
Code
[CODE]
try {
Statement stmt = conns.createStatement ();
String insert = "insert into SEQREQ_AUDIT (SEQREQ_AUDIT_ID, LABHEAD, PROGRAMME, LABJOURNAL, ORGANISM, TISSUE,";
insert=insert.concat("CELL_LINE, RDS1, RDS2, NTUSER, COUNTRY, DATE_CREATED, SSP, SEQ_SUBMISSION,FL_ID) ");
insert=insert.concat(" values ('"+SEQREQ_AUDIT_ID+"','"+LABHEAD+"','"+PROGRAMME+"','"+LABJOURNAL+"',");
insert=insert.concat("'"+ORGANISM+"','"+TISSUE+"','"+CELL_LINE+"','"+RDS1+"','"+RDS2+"','"+NTUSER+"',");
insert=insert.concat("'"+COUNTRY+"',SYSDATE,'"+SSP+"','"+SEQ_SUBMISSION+"','"+FL_ID+"')>;< this one!!!");
System.err.println("SQL insert: "+insert);
stmt.executeUpdate(insert);
}
catch (SQLException e){
e.getMessage();
System.err.println("Error-Insert record:" +e + e.getMessage());
message = ("ERROR - INSERT RECORD");
}

[Mike Jeya]

I encountered the same problem..
I searched in so many forums..I couldnot find any soltion for this

I solved the problem thru JavaRanch..

Thank u guys and JAVA RANCH..