wood burning stoves 2.0*
The moose likes JDBC and the fly likes problem in inserting data Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "problem in inserting data" Watch "problem in inserting data" New topic

problem in inserting data

rammie singh
Ranch Hand

Joined: Mar 26, 2009
Posts: 116
Hi every body

i am having problem in executing an insert query through JDBC

my table is

my code of execution is

my error while executing is

:<b> Error is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Paul Sturrock

Joined: Apr 14, 2004
Posts: 10336

You don't close your SQL statement's values clause. Your SQL shouyld be like:

what you've got is:

Also, its much better practice to use a PreparedStatement rather than a Statement. It will make your life easier in the long run.

JavaRanch FAQ HowToAskQuestionsOnJavaRanch
wood burning stoves
subject: problem in inserting data
Similar Threads
problem in accesing a db from a servlet
Getting error message - chapter 9 of ejb 3 in action using glassfish server 2.1
querry involving multiple tables.
Error with user defined object datatypes
nested ResultSets