java.sql.SQLSyntaxErrorException: 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 'where (1 = 0)' at line 1 Query is: sql : 'select * from sqooptest order by emails where (1 = 0) ' at > org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:138) at > org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) at > org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:252)

sqoop-user | Amit Kumar | 1 year ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Re: Order by in query

    sqoop-user | 1 year ago | Amit Kumar
    java.sql.SQLSyntaxErrorException: 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 'where (1 = 0)' at line 1 Query is: sql : 'select * from sqooptest order by emails where (1 = 0) ' at > org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:138) at > org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) at > org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:252)
  2. 0

    Re: Order by in query

    sqoop-user | 1 year ago | Amit Kumar
    java.sql.SQLSyntaxErrorException: 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 'where (1 = 0)' at line 1 Query is: sql : 'select * from sqooptest order by emails where (1 = 0) ' at > org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:138) at > org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) at > org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:252)
  3. 0

    Re: Order by in query

    sqoop-user | 1 year ago | Amit Kumar
    java.sql.SQLSyntaxErrorException: 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 'where (1 = 0)' at line 1 Query is: sql : 'select * from sqooptest order by emails where (1 = 0) ' at > org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:138) at > org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) at > org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:252)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Re: Order by in query

    sqoop-user | 1 year ago | Amit Kumar
    java.sql.SQLSyntaxErrorException: 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 'where (1 = 0)' at line 1 Query is: sql : 'select * from sqooptest order by emails where (1 = 0) ' at > org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:138) at > org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) at > org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:252)

    Root Cause Analysis

    1. java.sql.SQLSyntaxErrorException

      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 'where (1 = 0)' at line 1 Query is: sql : 'select * from sqooptest order by emails where (1 = 0) ' at > org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:138) at > org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) at > org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:252)

      at org.mariadb.jdbc.MySQLStatement.execute()
    2. mariadb-java-client
      MySQLStatement.executeQuery
      1. org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:278)
      2. org.mariadb.jdbc.MySQLStatement.executeQuery(MySQLStatement.java:333)
      2 frames