Previous SQL writing:
"SELECT * FROM " + table + " LIMIT "
Change to the current wording:
SELECT * FROM " + schema +"." + table + " LIMIT "
Add the schema when querying
Read More:
- DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=;;,?,?,?,?,?,?,?,?);END-OF-STATEMENT
- In the SQL query statement, add the column that does not exist in the table and set the fixed value of the column
- SQL state [null]; error code [0]; Error; nested exception is java.sql.SQLException: Error] with root
- How can Oracle query tables of other users without adding a table user name
- A case diagnosis and solution of DB2 error code 1639 and SQL state 08001 is described in detail
- Spring data JAP SQL error:17059 SQL State:99999
- SAP SQL error “SQL code: -10692“ occurred while accessing table “ZTXXXX“.
- Error code 1045, state 28000, Java sql.SQLException :Access denied for user ‘root’@’localhost’
- DB2 SQL error: sqlcode = – 803, sqlstate = 23505, sqlerrmc = 2 [solution]
- SQL query time group_ Was cut by group_ CONCAT()
- DB2 SQL ERROR: SQLCODE=-803, SQLSTATE=23505, SQL
- SQL Error: 1452, SQLState: 23000
- SQL Error: 17059, SQLState: 99999
- SQL Error (3621): String or binary data would be truncated The statement has been terminated. */
- DB2 SQL error: sqlcode = – 433, sqlstate = 22001 solved
- SQL error: 17006, sqlstate: 99999 invalid column name
- 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 Msg 18054, Level 16, State 1
- DB2 create table error – 104 42601 illegal symbol encountered in SQL statement