I encountered such a mistake today
Util. SQL Error JDBCExceptionReporter 77) : 156. SQLState: S1000
(util. JDBCExceptionReporter 78) near the keyword ‘plan for grammar mistakes.
.
Caused by: java.sql.sqlexception: syntax error near keyword ‘plan’.
…….
The web search explanation is caused by some values that have the same name as the key field in SQL2005.
Solution: Just change the plan name to something else, such as EMPPLAN
Read More:
- How to Fix SQL Error: 1054, SQLState: 42S22 Unknown column ‘markcardex0_.art_service_time’ in ‘field list’
- SQL Error: 0, SQLState: 08S01 & Communications link failure
- DB2 SQL ERROR: SQLCODE=-803, SQLSTATE=23505, SQL
- SQL Error: 904, SQLState: 42000
- Solve a bug harvest of DB2 (sqlcode = – 805, sqlstate = 51002, error message = DB2 SQL error: sqlcode = – 805, sqlstate = 5100
- SQL Error: 17059, SQLState: 99999
- SQL Error: 1452, SQLState: 23000
- DB2 SQL error: SQLCODE: -433, SQLSTATE: 22001, SQLERRMC
- SQL error: 17006, sqlstate: 99999 invalid column name
- DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=;;,?,?,?,?,?,?,?,?);END-OF-STATEMENT
- DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703
- A series of errors encountered in connecting to the database using Oracle SQL developer
- DB2 SQL error: sqlcode = – 433, sqlstate = 22001 solved
- DB2 SQL error: sqlcode = – 803, sqlstate = 23505, sqlerrmc = 2 [solution]
- DB2 create table error – 104 42601 illegal symbol encountered in SQL statement
- Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax； check the
- How to Fix error performing isolated work; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarE
- Error when connecting to database: DB2 SQL error: sqlcode = – 204, sqlstate = 42704, sqlerrmc= YXUAT.CUST_ BLK_ REL, DRIVER=4.25.13
- ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS sqlState
- Log error SQL Error: 1062, SQLState: 23000