5 replies to this topic

[mith]

Hello !
Im trying to make an application that can cooperate with database i made and i get this problem which works in each my class but in one i get SQLException: [h=1]ORA 00917 Missing a comma[/h]
my statement:

static Statement stmt;
String insertString1 = "insert into SALARY values("+i+" , "+s1+" , "+s2+" , '"+s3+"' , "+s4+",)";
stmt.executeUpdate(insertString1);

where i,s1,s2,s4 are integer and s3 is varchar

can any1 tell me where the hell i have to put this comma??!?!?!

[WingedPanther]

You have an extra comma before the )

You should also probably specify the fields before your VALUES clause.

[mith]

with:

String insertString1 = "insert into WYNAGRODZENIE values("+i+" , "+s1+" , "+s2+" , '"+s3+"' , "+s4+")";

problem is the same...

[lethalwire]

Quote

String insertString1 = "insert into WYNAGRODZENIE values("+i+" , "+s1+" , "+s2+" , '"+s3+"' , "+s4+")";

^^^ That one looks a bit different from the rest.

[WingedPanther]

static Statement stmt; String insertString1 = "insert into SALARY (field1,field2,field3,field4) values("+i+" , "+s1+" , "+s2+" , '"+s3+"' , "+s4+")"; stmt.executeUpdate(insertString1);

Also, what is the value of i, s1, s2, s3, and s4? If there are single quotes in those, it'll scramble things up.

[mith]

for example
i = 1
s1 = 111
s2 = 1111
s3 = 2012/01/01
s4 = 123