DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC= yxuat. CUST_BLK_REL, DRIVER=4.25.13
Reason: When using MyBATIS, the remote database was connected, and the login user did not specify which schemas to use, that is, the user name was not specified. This led to the fact that Mybaits could not find the schemas we wanted, so it reported an error.
Solution 1: When you write SQL statements, you simply add schemas before the table names in the SQL
For example: SELECT * from cmis_uat1.cust_blk_rel
Solution 2: Add schemas when configuring datasource.
For example: spring: a datasource: url: JDBC: db2:// 10.10.0.36:50000/HNCKC: currentSchema = CMIS_UAT1; username: yxuat password: xfjr2016
Read More:
- DB2 SQL error: sqlcode = – 803, sqlstate = 23505, sqlerrmc = 2 [solution]
- DB2 SQL error: SQLCODE: -433, SQLSTATE: 22001, SQLERRMC
- DB2 SQL Error: SQLCODE=-104, SQLSTATE=42601, SQLERRMC=;;,?,?,?,?,?,?,?,?);END-OF-STATEMENT
- Solve a bug harvest of DB2 (sqlcode = – 805, sqlstate = 51002, error message = DB2 SQL error: sqlcode = – 805, sqlstate = 5100
- DB2 SQL ERROR: SQLCODE=-803, SQLSTATE=23505, SQL
- DB2 SQL error: sqlcode = – 433, sqlstate = 22001 solved
- DB2 SQL Error: SQLCODE=-206, SQLSTATE=42703
- DB2, create stored procedure error, sqlcode = – 104, sqlstate = 42601, PSM_ semicolon
- SQLCODE=-551, SQLSTATE=42501 error resolution
- A series of errors encountered in connecting to the database using Oracle SQL developer
- java.lang.ClassNotFoundException : com.mysql.jdbc . driver project cannot connect to database, exception, lack of MySQL driver
- SQL Error: 0, SQLState: 08S01 & Communications link failure
- DB2 encountered the problem of sqlcode = 911 lock table when updating record update
- 2059 error in connecting to database by Navicat premium
- Mybatis database error java.sql.SQLException : Error setting driver on UnpooledDataSource. Caus
- SQL Error: 1452, SQLState: 23000
- Pikachu vulnerability is installed in the shooting range, and an error is reported when connecting to the MySQL database
- How to Fix SQL Error: 1054, SQLState: 42S22 Unknown column ‘markcardex0_.art_service_time’ in ‘field list’
- [Solved] org.mongodb.driver.cluster – Exception in monitor thread while connecting to server node1:27017
- mysql workbench Error Code: 1046. No database selected Select the default DB to be used