Error reporting for startup project:
error querying database Cause: java. sql. Sqlsyntaxerrorexception: expression #2 of select list is no…
solution:
Enter MySQL with CMD root account
execute commands in MySQL
SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));
Or use other connection tools to connect (root permission is required);
Read More:
- [Solved] mybatis Error querying database. Cause: java.sql.SQLException: The server time zone value
- Error querying database.Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource.
- [Solved] JAVA Operate Database Error: You have an error in your SQL syntax; Dao layer SQL statement error
- [Solved] Error updating database. Cause: java.sql.SQLException: Incorrect integer value: ‘**‘ for column
- [Solved] Scala error: type mismatch; found : java.util.List[?0] required: java.util.List[B]
- [Solved] Error updating database. Cause: java.sql.SQLException: Unknown initial character set index ‘255‘ re
- [Solved] IDEA jdbc Connect Database Error: java.sql.SQLException: Undefined Error
- [Solved] ssm Error: Error querying database. Cause: org.apache.ibatis.executor.ExecutorException: Executor was closed
- [Solved] Failed to instantiate java.util.List using constructor NO_CONSTRUCTOR with arguments
- [Solved] Mybatis insert Error: Cause: java.sql.SQLException: SQL String cannot be empty
- [Solved] Spring jdbctemplate Error: ‘Java. SQL. Driver’ for property ‘driver’: no
- [Solved] Java.lang.ClassCastException: [Ljava.lang.Long; cannot be cast to java.util.List
- [Solved] java.sql.SQLException: Unsupported character encoding ‘utf-8
- [Solved] stream Convert list to map Error: java.lang.IllegalStateException: Duplicate key
- [Solved] java.sql.SQLException: Unknown system variable cache query size
- JAVA Error: Error attempting to get column ‘XXX’ from result set. Cause java.sql.
- ERROR 1046 (3D000): No database selected [How to Solve]
- [How to Solve Error]java.util.Date cannot be cast to java.sql.Date
- JAVA 8: How to Convert List to Map
- Java database Druid error: com.alibaba.druid.pool.DruidDataSource error