<![CDATA[JavaRanch: Latest posts for the topic "how to update a record in msaccess data base using jdbc"]]> http://www.coderanch.com/forums/t/3/JDBC/update-record-msaccess-data-base JForum - http://www.jforum.net how to update a record in msaccess data base using jdbc 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

]]> http://www.coderanch.com/forums/posts/preList/451378/2009967 http://www.coderanch.com/forums/posts/preList/451378/2009967 how to update a record in msaccess data base using jdbc
MS-Access error]]> http://www.coderanch.com/forums/posts/preList/451378/2009981 http://www.coderanch.com/forums/posts/preList/451378/2009981 how to update a record in msaccess data base using jdbc
Deepak Bala wrote:Something is wrong with your update query ?
thanks Deepak.
Now i came to know my mistake.
MS-Access error
]]> http://www.coderanch.com/forums/posts/preList/451378/2009984 http://www.coderanch.com/forums/posts/preList/451378/2009984 how to update a record in msaccess data base using jdbc
For more information, please read this.

This post has been moved to a more appropriate forum.

]]> http://www.coderanch.com/forums/posts/preList/451378/2010292 http://www.coderanch.com/forums/posts/preList/451378/2010292