java.sql.SQLException: [Microsoft][ODBC Excel Driver] Syntax error (missing operator) in query expression 'NAME_1.NO NO'.

Oracle Community | yuvraj_patil002 | 2 years 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

    ODI 12c - Error while loading data from Excel to DB

    Oracle Community | 2 years ago | yuvraj_patil002
    java.sql.SQLException: [Microsoft][ODBC Excel Driver] Syntax error (missing operator) in query expression 'NAME_1.NO NO'.
  2. 0

    java jdbc ms access "Syntax error in UPDATE statement"

    Stack Overflow | 4 years ago
    java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
  3. 0

    fetch first record form database in java?

    Stack Overflow | 3 years ago | Manoj Gupta
    java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Reading Visual Foxpro Data From Java using ODBC

    Stack Overflow | 4 years ago | user1912404
    java.sql.SQLException: [Microsoft][ODBC Visual FoxPro Driver]Not a table.
  6. 0

    what is the correct syntax to query database from ms access jdbcodbc in java

    Stack Overflow | 4 years ago | Wong Kc
    java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Undefined function txtIcNo.getText' in expression.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      [Microsoft][ODBC Excel Driver] Syntax error (missing operator) in query expression 'NAME_1.NO NO'.

      at sun.jdbc.odbc.JdbcOdbc.createSQLException()
    2. sun.jdbc.odbc
      JdbcOdbcStatement.executeQuery
      1. sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6964)
      2. sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7121)
      3. sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3117)
      4. sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:337)
      5. sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:252)
      5 frames
    3. oracle.odi.query
      JDBCTemplate.executeQuery
      1. oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:196)
      2. oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:204)
      2 frames
    4. oracle.odi.runtime
      Executor.handleDataMovementTask
      1. oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:100)
      2. oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:38)
      3. oracle.odi.runtime.agent.execution.Executor.handleDataMovementTask(Executor.java:309)
      3 frames