Pattern selector

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

  1. OraclePreparedStatementWrapper.executeQuery() has thrown a SQLSyntaxErrorException
    Oracle JDBC Driver
    33
    6
    6
  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-01745: Invalid host/bind variable name
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445)
10 frames hidden

Solution

Liam2 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. kunal mahalevia Google Groups1 week ago
    exception while executing query
    Show stack trace
  2. vvkv24via Google Groups1 week ago
  3. Seidzivia GitHub3 weeks ago
    ORA-00933: SQL command not properly ended
    Show stack trace
  4. yamelsenihvia GitHub1 month ago
    ORA-00911: invalid character ; State=22019; ErrorCode=911
    Show stack trace
  5. johno1985via GitHub2 months ago
    SQL Exception
    Show stack trace
  6. 52liangbovia GitHub2 months ago
    Error creating bean with name 'chkCodeService': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'kCardInfoService': Invocation of init method failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLSyntaxErrorException: ORA-00900: 无效 SQL 语句
    Show stack trace
  7. itliusirvia GitHub2 months ago
    ORA-00933: SQL 命令未正确结束 ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL 命令未正确结束
    Show stack trace