PreparedStatement.executeQuery() has thrown a MySQLSyntaxErrorException

We found this prefix in 266 webpages.
MapChildren (78)Typical messages (167)TraceDetailed Map
  1. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
    1.   at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
    2.   at sun.reflect.NativeConstructorAccessorImpl.newInstance()
    3.   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance()
    4.   at java.lang.reflect.Constructor.newInstance()
    5.   at com.mysql.jdbc.Util.handleNewInstance()
    6.   at com.mysql.jdbc.Util.getInstance()
    7.   at com.mysql.jdbc.SQLError.createSQLException()
    8.   at com.mysql.jdbc.MysqlIO.checkErrorPacket()
    9.   at com.mysql.jdbc.MysqlIO.checkErrorPacket()
    10.   at com.mysql.jdbc.MysqlIO.sendCommand()
    11.   at com.mysql.jdbc.MysqlIO.sqlQueryDirect()
    12.   at com.mysql.jdbc.ConnectionImpl.execSQL()
    13.   at com.mysql.jdbc.PreparedStatement.executeInternal()
    14.   at com.mysql.jdbc.PreparedStatement.executeQuery()
  1. MySQLSyntaxErrorException

    ResultSetReturnImpl.extract()
    Crashes:32
    Projects:0
    Web Pages:32
    Error Reports:0
    First:10 months ago
    Last:7 months ago
    preview
  2. MySQLSyntaxErrorException

    DelegatingPreparedStatement.executeQuery()
    Crashes:26
    Projects:0
    Web Pages:22
    Error Reports:0
    First:10 months ago
    Last:7 months ago
    preview
  3. MySQLSyntaxErrorException

    DelegatingPreparedStatement.executeQuery()
    Crashes:24
    Projects:0
    Web Pages:24
    Error Reports:0
    First:10 months ago
    Last:7 months ago
    preview
  4. MySQLSyntaxErrorException

    NewProxyPreparedStatement.executeQuery()
    Crashes:24
    Projects:0
    Web Pages:23
    Error Reports:0
    First:10 months ago
    Last:7 months ago
    preview
  5. MySQLSyntaxErrorException

    Loader.doQueryAndInitializeNonLazyCollections()
    Crashes:22
    Projects:0
    Web Pages:19
    Error Reports:0
    First:10 months ago
    Last:7 months ago
    preview
  6. MySQLSyntaxErrorException

    DelegatingPreparedStatement.executeQuery()
    Crashes:18
    Projects:0
    Web Pages:15
    Error Reports:0
    First:10 months ago
    Last:7 months ago
    preview
  7. MySQLSyntaxErrorException

    JdbcTemplate.execute()
    Crashes:16
    Projects:0
    Web Pages:10
    Error Reports:0
    First:10 months ago
    Last:7 months ago
    preview
  8. throws execption while start the process

    First:2 years ago
    Last:2 years ago
    Author:Swapnil Ugare
  9. MySQLSyntaxErrorException

    HikariProxyPreparedStatement.executeQuery()
    Crashes:9
    Projects:0
    Web Pages:9
    Error Reports:0
    First:10 months ago
    Last:7 months ago
    preview
  10. Fallback to recreating the table exceptions when deploying Audience Targeting

    First:2 years ago
    Last:2 years ago
    Author:Koor Gai
  11. MySQLSyntaxErrorException

    PreparedStatementHandle.executeQuery()
    Crashes:8
    Projects:0
    Web Pages:7
    Error Reports:0
    First:10 months ago
    Last:7 months ago
    preview
  12. MySQLSyntaxErrorException

    PreparedStatementWrapper40.executeQuery()
    Crashes:7
    Projects:0
    Web Pages:6
    Error Reports:0
    First:10 months ago
    Last:7 months ago
    preview
  13. MySQLSyntaxErrorException

    WrappedPreparedStatement.executeQuery()
    Crashes:6
    Projects:0
    Web Pages:6
    Error Reports:0
    First:10 months ago
    Last:7 months ago
    preview
  14. MySQLSyntaxErrorException

    CorePreparedStatement.executeQuery()
    Crashes:6
    Projects:0
    Web Pages:6
    Error Reports:0
    First:10 months ago
    Last:7 months ago
    preview
  15. MySQLSyntaxErrorException

    DatabaseAccessor.basicExecuteCall()
    Crashes:5
    Projects:0
    Web Pages:4
    Error Reports:0
    First:10 months ago
    Last:7 months ago
    preview
  16. SQLRuntimeException

    JdbcConnection.queryDb()
    Crashes:5
    Projects:0
    Web Pages:5
    Error Reports:0
    First:10 months ago
    Last:7 months ago
    preview
  17. MySQLSyntaxErrorException

    Method.invoke()
    Crashes:5
    Projects:0
    Web Pages:5
    Error Reports:0
    First:10 months ago
    Last:7 months ago
    preview
  18. SQLGrammarException

    Loader.doQueryAndInitializeNonLazyCollections()
    Crashes:4
    Projects:0
    Web Pages:2
    Error Reports:0
    First:4 months ago
    Last:4 months ago
    preview
  19. Sqoop - Import max value query fails if used order by and limit 1

    First:2 years ago
    Last:2 years ago
    Author:Deep
  20. MySQLSyntaxErrorException

    DelegatingPreparedStatement.executeQuery()
    Crashes:3
    Projects:0
    Web Pages:3
    Error Reports:0
    First:10 months ago
    Last:7 months ago
    preview
  21. MySQLSyntaxErrorException

    JRJdbcQueryExecuter.createDatasource()
    Crashes:3
    Projects:0
    Web Pages:3
    Error Reports:0
    First:4 months ago
    Last:4 months ago
    preview
  22. MySQLSyntaxErrorException

    DelegatingPreparedStatement.executeQuery()
    Crashes:3
    Projects:0
    Web Pages:2
    Error Reports:0
    First:10 months ago
    Last:7 months ago
    preview
  23. GitHub iconWSO2 IOT 3.1.0 RC3: Missing Table Error - MYSQL

    First:1 year ago
    Last:4 months ago
    Author:Tofdu31
  24. Content Targeting upgrade does not wait for release table

    First:2 years ago
    Last:2 years ago
    Author:Anthony Chu
  25. GitHub iconSQL exception & stacktrace

    First:5 years ago
    Last:3 years ago
    Author:mibby
  26. wso2 IS Table 'wso2.sp_app' doesn't exist

    First:3 years ago
    Last:3 years ago
    Author:Vasco
  27. SchedulerException

    Thread.run()
    Crashes:2
    Projects:0
    Web Pages:2
    Error Reports:0
    First:4 months ago
    Last:4 months ago
    preview
  28. Issue with custom query using jdbc source connector

    First:1 year ago
    Last:1 year ago
    Author:Pavan Gavvala
  29. Missing table 'sensitiveFields'

    First:3 years ago
    Last:2 years ago
    Author:Chris Gianelloni
    Site:Cask Community Issue Tracker
    http://issues.cask.co/browse/COOPR-707
  30. GitHub iconchar not found at launch

    First:9 months ago
    Last:7 months ago
    Author:Reeeeeemi
  31. MySQLSyntaxErrorException

    DataFrameReader.jdbc()
    Crashes:2
    Projects:0
    Web Pages:2
    Error Reports:0
    First:8 months ago
    Last:7 months ago
    preview
  32. Custom Container Filter Error in Vaadin

    First:2 years ago
    Last:2 years ago
    Author:Logic
  33. MySQLSyntaxErrorException

    Method.invoke()
    Crashes:2
    Projects:0
    Web Pages:2
    Error Reports:0
    First:10 months ago
    Last:7 months ago
    preview
  34. WSO2 sh wso2server.sh -Dmigrate -Dcomponent=identity is not running the migration scripts

    First:7 months ago
    Last:7 months ago
    Author:Jocket
  35. MySQLSyntaxErrorException

    Thread.run()
    Crashes:2
    Projects:0
    Web Pages:2
    Error Reports:0
    First:3 weeks ago
    Last:3 weeks ago
    preview
  36. Mysql source does not work if there is a semi-colon in the end of the SQL import or Count query

    First:3 years ago
    Last:2 years ago
    Author:Sreevatsan Raman
    Site:Cask Community Issue Tracker
    http://issues.cask.co/browse/CDAP-4143
  37. jpql with WHERE statement = SQL sintax error

    First:4 years ago
    Last:3 years ago
    Author:xXxJAVAxXx
  38. SpringBoot - Flyway - JPA integration -- Error creating bean with name 'flywayInitializer' - Unknown table 'events' in information_schema

    First:9 months ago
    Last:9 months ago
    Author:Ankur Singhal
  39. Servlet Error - Checking Multiple Variables

    First:1 year ago
    Last:1 year ago
    Author:Taymeer
  40. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column in field list 'customer0_.user_name'

    First:1 year ago
    Last:1 year ago
    Author:Adithya
  41. Error while setting up mysql database for wso2 bps server

    First:1 year ago
    Last:1 year ago
    Author:Lipsa Pradhan
  42. What's wrong with creating sequence id hibernate generator?

    First:6 years ago
    Last:3 years ago
    Author:ema
  43. GitHub iconGitHub comment 725#283304539

    First:1 year ago
    Last:1 year ago
    Author:Maxetto
  44. GitHub icon扩容时提示table不存在,但运行schema时是存在

    First:1 year ago
    Last:1 year ago
    Author:AaronSheng
  45. MySql Error in Java program

    First:2 years ago
    Last:2 years ago
  46. GitHub iconGitHub comment 21#383512967

    First:7 months ago
    Last:7 months ago
    Author:vallurivinod
  47. GitHub iconError om MySQL connect

    First:5 years ago
    Last:3 years ago
    Author:Goul-pav
  48. GitHub iconConstant Load error After updating above 3.5

    First:6 years ago
    Last:3 years ago
    Author:ScottSpittle
  49. JavaFX GUI / MySQL retrieving records from a customers table

    First:2 years ago
    Last:2 years ago
    Author:goblin
  50. GitHub iconregisterstudents: Unknown column 'courseId'

    First:5 years ago
    Last:3 years ago
    Author:league
MessageNumber of crashes
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'prefix' in 'field list'24
could not extract ResultSet22
could not execute query10
org.hibernate.exception.SQLGrammarException: could not extract ResultSet10
could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet9
Unable to start embedded container; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'org.mifosplatform.infrastructure.core.boot.WebXmlConfiguration': Injection of autowired dependencies failed; nes6
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 14
com.liferay.portal.kernel.dao.orm.ORMException: org.hibernate.exception.SQLGrammarException: could not execute query4
FUNCTION publishing.COUNT does not exist. Check the 'Function Name Parsing and Resolution' section in the Reference Manual3
You have an error in your SQL syntax near 'ON (b.reporter = prof.userid OR b.assigned_to = prof.userid) WHERE b.product_id ' at line 13
  1. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
    1.   at sun.reflect.NativeConstructorAccessorImpl.newInstance0()
    2.   at sun.reflect.NativeConstructorAccessorImpl.newInstance()
    3.   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance()
    4.   at java.lang.reflect.Constructor.newInstance()
    5.   at com.mysql.jdbc.Util.handleNewInstance()
    6.   at com.mysql.jdbc.Util.getInstance()
    7.   at com.mysql.jdbc.SQLError.createSQLException()
    8.   at com.mysql.jdbc.MysqlIO.checkErrorPacket()
    9.   at com.mysql.jdbc.MysqlIO.checkErrorPacket()
    10.   at com.mysql.jdbc.MysqlIO.sendCommand()
    11.   at com.mysql.jdbc.MysqlIO.sqlQueryDirect()
    12.   at com.mysql.jdbc.ConnectionImpl.execSQL()
    13.   at com.mysql.jdbc.PreparedStatement.executeInternal()
    14.   at com.mysql.jdbc.PreparedStatement.executeQuery()