Pattern selector

Most relevant patterns first. Most helpful ones displayed. Click here to show all.

  1. CorePreparedStatement.executeQuery() has thrown a SQLSyntaxErrorException
    XAPool
    0
    0
    0
  2. Incorrect Syntax in SQL statement
    Oracle JDBC Driver
    124
    53
    22

Your stack trace compared to the selected pattern

Jump to solutionsExpand frames
java.sql.SQLSyntaxErrorException: ORA-00904: "REFERENCESTOREFRESH": invalid identifier
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
24 frames hidden

Solution

Liam3 months ago

Verify the application program has the correct syntax in the database execute statement. Obtain the scheme of the database table or view you are to access, including each column definition in the table. Verify database execute statement has the correct syntax .

For examples:

Exception message: ORA-00942: table or view does not exist

Access the database, and check the table or view does exist. If not exist, create the table or view in database.

Exception message: ORA-00904: "ACTION": invalid identifier

Check if the identifier "ACTION" exist in database, for example the column "ACTION" must be in the database table.

External results for this pattern (10)

  1. johno1985via GitHub3 weeks ago
    SQL Exception
    Show stack trace
  2. 6f91dfff-a3ab-4c10-bbf9-f7881a06ef97via Oracle Community3 weeks ago
    ORA-00942: table or view does not exist
    Show stack trace
  3. kunal mahalevia Google Groups1 month ago
    exception while executing query
    Show stack trace
  4. vvkv24via Google Groups1 month ago
  5. Seidzivia GitHub1 month ago
    ORA-00933: SQL command not properly ended
    Show stack trace
  6. yamelsenihvia GitHub2 months ago
    ORA-00911: invalid character ; State=22019; ErrorCode=911
    Show stack trace
  7. johno1985via GitHub2 months ago
    SQL Exception
    Show stack trace