how to update a record in msaccess data base using jdbc

[k kousalya]

hai all,
I am developing small application. My database is msaccess databse. I am using jdbc connection by creating DSN. In that application i could get the data from the data base. But I am unable to modify the data using UPDATE query.

My databse is (Contacts):

EmployeeNumber EmployeeName ProjectName Age
(int) (string) (string) (int)

my code is

   
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:access","", "");
Statement st = con.createStatement();
String sql = " UPDATE Contacts SET EmployeeName='" + empName
	  + "',ProjectName='" + projectName + "',Age="
	  +age + " WHERE EmployeeNumber=" + empNumber;
int result=st.executeUpdate(sql);
 

I am getting the following error


java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(Unknown Source)
at UpdatedServlet.doPost(UpdatedServlet.java:57)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)

Could you please anyone help me

Thanks in advance

[Deepak Bala]

Something is wrong with your update query ?

MS-Access error

[k kousalya]

Deepak Bala wrote:Something is wrong with your update query ?
thanks Deepak.
Now i came to know my mistake.
MS-Access error

[Bear Bibeault]

Please take the time to choose the correct forum for your posts. This forum is for questions on JSP.

For more information, please read this.

This post has been moved to a more appropriate forum.