The server selected protocol version TLS10 is not accepted by client preferences [TLS12]
报错信息： Caused by: org.springframework.jdbc.CannotGe… 继续阅读 The server selected protocol version TLS10 is not accepted by client preferences [TLS12]
jdbc标签存档订阅
com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between “Chinese_PRC_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation.
加一个collate Chinese_PRC_CI_AS SELECT so.name table_… 继续阅读 com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between “Chinese_PRC_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation.
Cause: com.microsoft.sqlserver.jdbc.SQLServerException: ‘sysdate’ is not a recognized built-in function name. ; uncategorized SQLException; SQL state [S0010]; error code [195]; ‘sysdate’ is not a recognized built-in function name.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: ‘sysdate’ is not a recognized built-in function name.
sysdate 改成getdate
- 发表于：
-
作者：
stnds
- 分类： SRE, 未分类
- 标签： https, jdbc, sqlserver
- 发表评论: Cause: com.microsoft.sqlserver.jdbc.SQLServerException: ‘sysdate’ is not a recognized built-in function name. ; uncategorized SQLException; SQL state [S0010]; error code [195]; ‘sysdate’ is not a recognized built-in function name.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: ‘sysdate’ is not a recognized built-in function name.
springboot quartz sqlserver 异常 Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR
修改jdbc url： #quartz用到了游标，而sqlserver默认不打开游标 #jdbc.u… 继续阅读 springboot quartz sqlserver 异常 Line 1: FOR UPDATE clause allowed only for DECLARE CURSOR
SpringBoot使用SQL Server
pom: <!– SQL server –> <dependency> … 继续阅读 SpringBoot使用SQL Server
- 发表于：
-
作者：
- 分类： SRE
- 标签： jdbc, sqlserver
- 发表评论: SpringBoot使用SQL Server
spiderflow增加MySQL数据源
DriverClassName com.mysql.jdbc.Driver 数据库连接 jdbc:m… 继续阅读 spiderflow增加MySQL数据源
使用docker-compose启动sonarqube代码静态质量检测工具
version: "3.7" networks: sonarqubenet: e… 继续阅读 使用docker-compose启动sonarqube代码静态质量检测工具
- 发表于：
-
作者：
sjx
- 分类： SRE
- 标签： Docker, docker-compose, jdbc, PostgreSQL, sonarqube
- 发表评论: 使用docker-compose启动sonarqube代码静态质量检测工具
nacos使用mysql数据源
spring.datasource.platform=mysql db.num=1 db.url.0… 继续阅读 nacos使用mysql数据源
- 发表于：
-
作者：
javaer, javaer
- 分类： SRE
- 标签： http, java, jdbc, MySQL, nacos, naocs, spring
- 发表评论: nacos使用mysql数据源
1-03-18 22:11:44.294 WARN com.zaxxer.hikari.pool.PoolBase [15g035lzzs80e] – HikariPool-1 – Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@36c4c9bb (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.
1-03-18 22:11:44.294 WARN com.zaxxer.hikari.pool.P… 继续阅读 1-03-18 22:11:44.294 WARN com.zaxxer.hikari.pool.PoolBase [15g035lzzs80e] – HikariPool-1 – Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@36c4c9bb (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.
- 发表于：
-
作者：
- 分类： SRE
- 标签： bash, hikari, https, java, jdbc, MySQL
- 发表评论: 1-03-18 22:11:44.294 WARN com.zaxxer.hikari.pool.PoolBase [15g035lzzs80e] – HikariPool-1 – Failed to validate connection com.mysql.cj.jdbc.ConnectionImpl@36c4c9bb (No operations allowed after connection closed.). Possibly consider using a shorter maxLifetime value.
JDBC实现流式查询
使用JDBC的 PreparedStatement/Statement 的 setFetchSize… 继续阅读 JDBC实现流式查询
- 发表于：
-
作者：
yew
- 分类： SRE
- 标签： java, jdbc, springboot, sql
- 发表评论: JDBC实现流式查询
Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
- 发表于：
-
作者：
- 分类： SRE
- 标签： jdbc, MySQL
- 发表评论: Establishing SSL connection without server’s identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn’t set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to ‘false’. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Loading class `com.mysql.jdbc.Driver’. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver’. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
Loading class `com.mysql.jdbc.Driver’. This is dep… 继续阅读 Loading class `com.mysql.jdbc.Driver’. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver’. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
- 发表于：
-
作者：
- 分类： SRE
- 标签： https, java, jdbc, MySQL, post, s3, springboot
- 发表评论: Loading class `com.mysql.jdbc.Driver’. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver’. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
SpringBoot读取配置文件参数
application-dev.yml 配置 datasource: primary: jdbc-u… 继续阅读 SpringBoot读取配置文件参数
- 发表于：
-
作者：
- 分类： SRE
- 标签： java, jdbc, MySQL, spring, springboot
- 发表评论: SpringBoot读取配置文件参数
SpringBoot 配置文件区分环境
application.yml # 端口 server: port: 8080 spring: ap… 继续阅读 SpringBoot 配置文件区分环境
- 发表于：
-
作者：
- 分类： SRE
- 标签： jdbc, MySQL, springboot, yaml
- 发表评论: SpringBoot 配置文件区分环境
JAVA的Asia/Shanghai和GMT+8 相差一个小时问题
Asia/Shanghai的夏令时导致，在jdbc中指定serverTimezone=GMT%2B8… 继续阅读 JAVA的Asia/Shanghai和GMT+8 相差一个小时问题
- 发表于：
-
作者：
tomcat
- 分类： SRE
- 标签： java, jdbc
- 发表评论: JAVA的Asia/Shanghai和GMT+8 相差一个小时问题
Loading class `com.mysql.jdbc.Driver’. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver’. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
Sonarqube环境搭建
1、安装JDK copy jdk-7u51-linux-x64.rpm到/usr/java rpm… 继续阅读 Sonarqube环境搭建
