ava.sql.SQLException: Syntax error or access violation message from server: "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 'Dialing''' at line 1"

Coderanch | preethi Ayyappan | 8 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    taking a particular data from a number of lines

    Coderanch | 8 years ago | preethi Ayyappan
    ava.sql.SQLException: Syntax error or access violation message from server: "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 'Dialing''' at line 1"

    Root Cause Analysis

    1. ava.sql.SQLException

      Syntax error or access violation message from server: "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 'Dialing''' at line 1"

      at com.mysql.jdbc.MysqlIO.checkErrorPacket()
    2. MySQL jdbc
      Statement.executeUpdate
      1. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2001)
      2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1168)
      3. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1279)
      4. com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1225)
      5. com.mysql.jdbc.Connection.execSQL(Connection.java:2278)
      6. com.mysql.jdbc.Connection.execSQL(Connection.java:2225)
      7. com.mysql.jdbc.Statement.executeUpdate(Statement.java:1259)
      8. com.mysql.jdbc.Statement.executeUpdate(Statement.java:1205)
      8 frames
    3. com.example.servlets
      Call2.doGet
      1. com.example.servlets.Call2.doGet(Call2.java:239)
      1 frame
    4. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
      2 frames
    5. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
      5. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      6. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
      7. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
      8. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174)
      8 frames
    6. Grizzly HTTP
      LeaderFollowerWorkerThread.runIt
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874)
      2. org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
      3. org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
      4. org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
      4 frames
    7. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689)
      1 frame
    8. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame