Type Exception Report
Message An exception occurred processing [/red.jsp] at line [40]
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
org.apache.jasper.JasperException: An exception occurred processing [/red.jsp] at line [40] 37: if (error != null) { 38: s = ""; 39: } else { 40: log.saveClick(company, keywords); 41: } 42: // response.sendRedirect(s); 43: %> Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:601) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:488) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:383) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:331) javax.servlet.http.HttpServlet.service(HttpServlet.java:583) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
Root Cause
javax.servlet.ServletException: 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 'NULL,'default','pumps coupled','SPX Fluid Power','http://www.catalogds.com/db/se' at line 1 org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:907) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:833) org.apache.jsp.red_jsp._jspService(red_jsp.java:225) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:583) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:465) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:383) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:331) javax.servlet.http.HttpServlet.service(HttpServlet.java:583) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
Root Cause
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 'NULL,'default','pumps coupled','SPX Fluid Power','http://www.catalogds.com/db/se' at line 1 sun.reflect.GeneratedConstructorAccessor20.newInstance(Unknown Source) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) java.lang.reflect.Constructor.newInstance(Constructor.java:408) com.mysql.jdbc.Util.handleNewInstance(Util.java:377) com.mysql.jdbc.Util.getInstance(Util.java:360) com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887) com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823) com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435) com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526) com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484) com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848) com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742) org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:290) org.apache.tomcat.dbcp.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:290) com.cds.DatabaseService.query(DatabaseService.java:144) com.cds.ThreeDMSLogEntry.saveClick(ThreeDMSLogEntry.java:170) org.apache.jsp.red_jsp._jspService(red_jsp.java:204) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:583) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:465) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:383) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:331) javax.servlet.http.HttpServlet.service(HttpServlet.java:583) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
Note The full stack trace of the root cause is available in the server logs.