Hi, > stmt1.executeUpdate("insert into LOCATIONS"+ "values(1,'Cha Cha Cha
Shouldn't there be a space between LOCATIONS and values? HTH Regards, Serge Fonville On Thu, Dec 3, 2009 at 11:09 PM, devgan <ganeshbab...@gmail.com> wrote: > I am getting this error and i am not able to fix it. > Syntax error: Encountered "1" at line 1, column 29. > > This is my code > > createString = "create table LOCATION" + > "(LOCATION_ID INTEGER NOT NULL, " + > "LOCATION varchar(32)," + > "primary key(LOCATION_ID))"; > > // cause of error > stmt1.executeUpdate("insert into LOCATIONS"+ "values(1,'Cha Cha Cha > bar')"); > > -- > You received this message because you are subscribed to the Google > Groups "Java EE (J2EE) Programming with Passion!" group. > To post to this group, send email to > java-ee-j2ee-programming-with-passion@googlegroups.com > To unsubscribe from this group, send email to > java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com > For more options, visit this group at > http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en -- http://www.sergefonville.nl Convince Google!! They need to support Adsense over SSL https://www.google.com/adsense/support/bin/answer.py?hl=en&answer=10528 http://www.google.com/support/forum/p/AdSense/thread?tid=1884bc9310d9f923&hl=en -- You received this message because you are subscribed to the Google Groups "Java EE (J2EE) Programming with Passion!" group. To post to this group, send email to java-ee-j2ee-programming-with-passion@googlegroups.com To unsubscribe from this group, send email to java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en