Table of Contents Caused by: java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x98\x80\xE3\x80…’ for column ‘show_content’ at row 1 Error cause analysis solution 1. Check character set configuration 2. Modify table structure 3. Modify the connection character set 4. Convert character encoding in conclusion 1. Check character set configuration 2. Modify table structure 3. Insert data Caused by: […]
Tag: sqlexception
java.sql.SQLException: com.mysql.cj.jdbc.Driver
This article shares a problem encountered when Springboot integrated Elasticsearch. The project started normally, but an exception occurred when querying the database: java.sql.SQLException: com.mysql.cj.jdbc.Driver java.sql.SQLException: com.mysql.cj.jdbc.Driver at com.alibaba.druid.util.JdbcUtils.createDriver(JdbcUtils.java:625) ~[druid-1.1.21.jar:1.1.21] at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:897) [druid-1.1.21.jar:1.1.21] at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1376) [druid-1.1.21.jar:1.1.21] at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1372) [druid-1.1.21.jar:1.1.21] at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:109) [druid-1.1.21.jar:1.1.21] at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:158) [spring-jdbc-5.2.9.RELEASE.jar:5.2.9.RELEASE] at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:116) [spring-jdbc-5.2.9.RELEASE.jar:5.2.9.RELEASE] at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79) [spring-jdbc-5.2.9.RELEASE.jar:5.2.9.RELEASE] at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80) [mybatis-spring-2.0.7.jar:2.0.7] at org.mybatis.spring.transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67) […]
MariaDB+SpringBoot error Caused by: java.sql.SQLException: GSS-API authentication exception
Recently, when I was building a springboot + mybatis + mariadb project, I encountered a problem like the title. After searching around, I couldn’t find a suitable solution, so I recorded my solution, hoping to help the latecomers. Let’s talk about the conclusion first, just reinstall MariaDB! ! ! ! 1. Environment and configuration information […]
Install CDH and execute scm_prepare_database.sh to report an error, java.sql.SQLException: Access denied for user ‘scm’@’localhost’
1. Install CDH and report an error CDH is Cloudera Distribution for The abbreviation of Hadoop is a set of enterprise-oriented open source Hadoop ecosystem solutions provided by Cloudera. CDH integrates various Hadoop-related open source projects and tools, and provides functions for centralized management and operation of these components. Install CDH and execute scm_prepare_database.sh to […]
java.sql.SQLException: There is no DataSource named ‘null’
Error message After configuring dataSource, even if JobStoreTX has been specified in the configuration file, LocalDataSourceJobStore is actually used. 2023-07-10 11:15:51,636 WARN [main] org.quartz.impl.jdbcjobstore.JobStoreSupport: Database connection shutdown unsuccessful. java.sql.SQLException: There is no DataSource named ‘null’ at org.quartz.utils.DBConnectionManager.shutdown(DBConnectionManager.java:135) at org.quartz.impl.jdbcjobstore.JobStoreSupport.shutdown(JobStoreSupport.java:746) at org.quartz.core.QuartzScheduler.shutdown(QuartzScheduler.java:732) at org.quartz.impl.StdSchedulerFactory.shutdownFromInstantiateException(StdSchedulerFactory.java:1431) at org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1391) at org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1579) at org.springframework.scheduling.quartz.SchedulerFactoryBean.createScheduler(SchedulerFactoryBean.java:679) at org.springframework.scheduling.quartz.SchedulerFactoryBean.prepareScheduler(SchedulerFactoryBean.java:616) at org.springframework.scheduling.quartz.SchedulerFactoryBean.afterPropertiesSet(SchedulerFactoryBean.java:504) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863) […]
Solve java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES) error
In the mybatis used in the springboot project, the following error has been reported when testing userMapper java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129) ~[mysql-connector-j-8.0.31.jar:8.0.31] at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-j-8.0.31.jar:8.0.31] at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:828) ~[mysql-connector-j-8.0.31.jar:8.0.31] at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448) ~[mysql-connector-j-8.0.31.jar:8.0.31] at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241) ~[mysql-connector-j-8.0.31.jar:8.0.31] at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198) ~[mysql-connector-j-8.0.31.jar:8.0.31] at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-4.0.3.jar:na] at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364) ~[HikariCP-4.0.3.jar:na] at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[HikariCP-4.0.3.jar:na] at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476) […]
java.lang.RuntimeException: java.sql.SQLException: Cannot create com.iflytek.bms.domain.ChatObject:
Question Jdbc performs data query, and the console terminal reports an error java.lang.RuntimeException: java.sql.SQLException: Cannot create com.iflytek.bms.domain.ChatObject: com.iflytek.bms.domain.ChatObject Query: SELECT * FROM chatobject where myId = ? Parameters: [2 ] Detailed error author query statement @Override public List<ChatObject> selectChatObjectByMyId(Integer myId) {<!– –> String sql = “SELECT * FROM chatobject where myId = ?”; try {<!– […]
Error com.alibaba.druid.pool.DruidDataSource error serious: java.sql.SQLException: ${jdbc.driver}
E:\Java\jdk1.8.0_172\bin\java.exe “-javaagent:D:\IntelliJ IDEA 2022.3.3\lib\idea_rt.jar=53003:D:\ \IntelliJ IDEA 2022.3.3\bin” -Dfile.encoding=UTF-8 -classpath E:\Java\jdk1.8.0_172\jre\lib\charsets.jar;E:\Java\ \jdk1.8.0_172\jre\lib\deploy.jar;E:\Java\jdk1.8.0_172\jre\lib\ext\access-bridge-64.jar;E:\ \Java\jdk1.8.0_172\jre\lib\ext\cldrdata.jar;E:\Java\jdk1.8.0_172\jre\lib\ext\dnsns.jar;E :\Java\jdk1.8.0_172\jre\lib\ext\jaccess.jar;E:\Java\jdk1.8.0_172\jre\lib\ext\jfxrt.jar ;E:\Java\jdk1.8.0_172\jre\lib\ext\localedata.jar;E:\Java\jdk1.8.0_172\jre\lib\ext\\ ashorn .jar;E:\Java\jdk1.8.0_172\jre\lib\ext\sunec.jar;E:\Java\jdk1.8.0_172\jre\lib\ext\ \sunjce_provider.jar;E:\Java\jdk1.8.0_172\jre\lib\ext\sunmscapi.jar;E:\Java\jdk1.8.0_172\jre\lib\ ext\sunpkcs11.jar;E:\Java\jdk1.8.0_172\jre\lib\ext\zipfs.jar;E:\Java\jdk1.8.0_172\jre\lib \javaws.jar;E:\Java\jdk1.8.0_172\jre\lib\jce.jar;E:\Java\jdk1.8.0_172\jre\lib\jfr. jar;E:\Java\jdk1.8.0_172\jre\lib\jfxswt.jar;E:\Java\jdk1.8.0_172\jre\lib\jsse.jar;E: \Java\jdk1.8.0_172\jre\lib\management-agent.jar;E:\Java\jdk1.8.0_172\jre\lib\plugin.jar;E:\ Java\jdk1.8.0_172\jre\lib\resources.jar;E:\Java\jdk1.8.0_172\jre\lib\rt.jar;E:\aCode\idea Code\Spring_test\target\classes;D:\software\maven\apache-maven-3.9.2\mvn_resp\org\springframework\spring-context\4.2.4.RELEASE\ \spring-context-4.2.4.RELEASE.jar;D:\software\maven\apache-maven-3.9.2\mvn_resp\org\springframework\spring-aop\4.2.4. RELEASE\spring-aop-4.2.4.RELEASE.jar;D:\software\maven\apache-maven-3.9.2\mvn_resp\aopalliance\aopalliance\1.0\aopalliance-1.0. jar;D:\software\maven\apache-maven-3.9.2\mvn_resp\org\springframework\spring-beans\4.2.4.RELEASE\spring-beans-4.2.4. RELEASE.jar;D:\software\maven\apache-maven-3.9.2\mvn_resp\org\springframework\spring-core\4.2.4.RELEASE\spring-core-4.2. 4.RELEASE.jar;D:\software\maven\apache-maven-3.9.2\mvn_resp\commons-logging\commons-logging\1.2\commons-logging-1.2.jar;D :\software\maven\apache-maven-3.9.2\mvn_resp\org\springframework\spring-expression\4.2.4.RELEASE\spring-expression-4.2.4.RELEASE.jar ;D:\software\maven\apache-maven-3.9.2\mvn_resp\com\alibaba\druid\1.0.9\druid-1.0.9.jar;E:\Java \jdk1.8.0_172\lib\jconsole.jar;E:\Java\jdk1.8.0_172\lib\tools.jar;D:\software\maven\apache-maven-3.9 .2\mvn_resp\mysql\mysql-connector-java\5.1.41\mysql-connector-java-5.1.41.jar;D:\software\maven\apache-maven-3.9. 2\mvn_resp\org\mybatis\mybatis\3.2.8\mybatis-3.2.8.jar;D:\software\maven\apache-maven-3.9.2\mvn_resp\ org\mybatis\mybatis-spring\1.2.2\mybatis-spring-1.2.2.jar;D:\software\maven\apache-maven-3.9.2\mvn_resp\org\ \springframework\spring-jdbc\4.2.6.RELEASE\spring-jdbc-4.2.6.RELEASE.jar;D:\software\maven\apache-maven-3.9.2\mvn_resp\ org\springframework\spring-tx\4.2.6.RELEASE\spring-tx-4.2.6.RELEASE.jar;D:\software\maven\apache-maven-3.9.2\mvn_resp \javax\servlet\javax.servlet-api\3.1.0\javax.servlet-api-3.1.0.jar com.peng.test.ApplicationContext Jun 03, 2023 12:54:11 PM org.springframework.context.annotation.AnnotationConfigApplicationContext prepareRefresh Info: Refreshing org.springframework.context.annotation.AnnotationConfigApplicationContext@7daf6ecc: startup date [Sat Jun 03 12:54:11 CST […]
org.postgresql.util.PSQLException: Invalid targetServerType value: primary
Record the solution to this error: Specific error information: [ERROR com.zaxxer.hikari.pool.HikariPool:567]:HikariPool-1 – Exception during pool initialization. org.postgresql.util.PSQLException: Invalid targetServerType value: primary at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl( ConnectionFactoryImpl.java:157) at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49) at org.postgresql.jdbc.PgConnection.(PgConnection.java:195) at org.postgresql.Driver.makeConnection (Driver.java:454) at org.postgresql.Driver.connect(Driver.java:256) at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:117) at com.zaxxer.hikari.util. DriverDataSource.getConnection(DriverDataSource.java:123) at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:365) at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:194) at com .zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:460) at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:534) at com.zaxxer.hikari.pool.HikariPool. (HikariPool.java:115) at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) at com.zaxxer.hikari.HikariDataSource$$FastClassBySpringCGLIB$$eeb1ae86.invoke() at […]
javax.servlet.ServletException: java.sql.SQLException: The url cannot be null and java.sql.SQLException is wrong
Directory mistake: Reason: idea cannot read the db.properties file Solution: Error analysis: In-depth analysis: Error resolution recommendation: Running on the browser side should be a small javaweb exercise: jsp + javabean + servlet + database —- the registration function is realized, and the following error occurs: Error: HTTP Status 500 – Internal Server Error Type […]