connection-init-sqls: set names utf8mb4; 2020-09-17 18:20:17.402 ERROR 18684 --- [ main] c.alibaba.druid.filter.stat.StatFilter : merge sql error, dbType null, druid-1.1.23, sql : set names utf8mb4 com.alibaba.druid.sql.parser.ParserExce...
config.setJdbcUrl(getUrl()); config.setUsername(getUser()); config.setPassword(getPassword()); config.setMaximumPoolSize(getMaxPoolSize()); config.setConnectionInitSql("SET NAMES utf8mb4"); // Followings are recommendation from HikariCP https://github.com/brettwooldridge/HikariCP#initialization...
dbcpDs.setConnectionInitSqls(Arrays.asList("set names utf8mb4")); } else { dbcpDs.addConnectionProperty("characterEncoding", encoding); 代码示例来源:origin: com.alibaba.otter/node.etl if (StringUtils.equalsIgnoreCase(encoding, "utf8mb4")) { dbcpDs.addConnectionProperty("characterEncoding", "...
setConnectionInitSqls(Arrays.asList("set names utf8mb4;")); dataSource.init(); dbCreated.put(key, true); log.info(dataSource.getUrl() + "数据源创建成功!dataSource_created"); dataMap.put(key, dataSource); transaction.setStatus(Transaction.SUCCESS); } } catch (Exception e)...
username:testpassword:test1234driver-class-name:com.mysql.jdbc.Drivertest-while-idle:truevalidation-query:SELECT 1connection-init-sqls:-set sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';-set names utf8mb4;...
("jdbc:mysql://localhost:3306/yourdatabase"); dataSource.setUsername("root"); dataSource.setPassword("yourpassword"); // 设置连接初始化SQL语句 String[] initSqls = {"SET NAMES utf8mb4", "SET time_zone = '+08:00'"}; dataSource.setConnectionInitSqls(initSqls); return dataSource; ...