java.sql.SQLException: 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 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622) at com.mysql.jdbc.Connection.execSQL(Connection.java:2376) at com.mysql.jdbc.Connection.execSQL(Connection.java:2297) at java.sql.SQLException: You have an error in your SQL syntax at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1957) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1880) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1741) at com.appnetix.app.util.QueryUtil.update(QueryUtil.java:607) at com.appnetix.app.components.zipcodemgr.manager.dao.AssignZipCodeDAO.updateFranchiseeZipCodes(AssignZipCodeDAO.java:154) at java.sql.SQLException: You have an error in your SQL syntax xecute(AssignZipManipulatorAction.java:62) at java.sql.SQLException: You have an error in your SQL java.sql.SQLException: You have an error in your SQL syntax org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) .java:510) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) java.sql.SQLException: You have an error in your SQL syntax at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) java.sql.SQLException: You have an error in your SQL syntax at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) java.sql.SQLException: You have an error in your SQL syntax at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at java.sql.SQLException: You have an error in your SQL syntax org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:306) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:745) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:675) at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:868) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)
Reason Of Exception :
This kind of exception occurs when you are writing an sql query but due to some reason or lack of knowledge writes the wrong syntax.
Solution Of Exception :
The solution for this kind of exception is to check the sql syntax you are writing. You can refer the sql manual for correcting the syntax.
