sarah gri

Greenhorn
+ Follow
since Jan 17, 2003
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by 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");
}
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