设为首页收藏本站
开启辅助访问 切换到窄版
搜索
第一问答网»论坛 › 中问网 › 问答 › 用jdbc使用Druid连接池问题

用jdbc使用Druid连接池问题

[复制链接]
查看11 | 回复2 | 2021-1-27 05:27:04 | 显示全部楼层 |阅读模式
//1.导入jar包
//2.导入配置文件
//3.加载配置文件
Propertiespro=newProperties();
InputStreamresourceAsStream=DruidDemo.class.getClassLoader().getResourceAsStream("druid.properties");
pro.load(resourceAsStream);
//4.获取数据库连接池对象
DataSourceds=DruidDataSourceFactory.createDataSource(pro);
//5.获取连接对象
Connectionconnection=ds.getConnection();
System.out.println(connection);

这是我运行的代码，但是出现了以下问题，配置文件放在src下
jar包如下：mysql-connector-java-8.0.19.jar
druid-1.0.9.jar
时区问题已加上
这是我的druid.properties文件
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql:///first?serverTimezone=UTC
username=root
password=123
initialSize=5
maxActive=10
maxWait=3000

警告:Cannotresolvecom.mysq.jdbc.Connection.pingmethod.Willuse'SELECT1'instead.
java.lang.NullPointerException
atcom.alibaba.druid.pool.vendor.MySqlValidConnectionChecker.(MySqlValidConnectionChecker.java:48)
atcom.alibaba.druid.pool.DruidDataSource.initValidConnectionChecker(DruidDataSource.java:878)
atcom.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:594)
atcom.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:915)
atcom.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:911)
atcom.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:98)
atcn.itcast.datasoure.Druid.DruidDemo.main(DruidDemo.java:24)
4月26,202010:14:44上午com.alibaba.druid.pool.DruidDataSourceerror
严重:initdatasourceerror
java.sql.SQLException:validateConnectionfalse
atcom.alibaba.druid.pool.DruidAbstractDataSource.validateConnection(DruidAbstractDataSource.java:1216)
atcom.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1439)
atcom.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:618)
atcom.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:915)
atcom.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:911)
atcom.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:98)
atcn.itcast.datasoure.Druid.DruidDemo.main(DruidDemo.java:24)
4月26,202010:14:44上午com.alibaba.druid.pool.DruidDataSourceerror
严重:dataSourceiniterror
java.sql.SQLException:validateConnectionfalse
atcom.alibaba.druid.pool.DruidAbstractDataSource.validateConnection(DruidAbstractDataSource.java:1216)
atcom.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1439)
atcom.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:618)
atcom.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:915)
atcom.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:911)
atcom.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:98)
atcn.itcast.datasoure.Druid.DruidDemo.main(DruidDemo.java:24)
4月26,202010:14:44上午com.alibaba.druid.pool.DruidDataSourceinfo
信息:{dataSource-1}inited
Exceptioninthread"main"java.sql.SQLException:validateConnectionfalse
atcom.alibaba.druid.pool.DruidAbstractDataSource.validateConnection(DruidAbstractDataSource.java:1216)
atcom.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1439)
atcom.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:618)
atcom.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:915)
atcom.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:911)
atcom.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:98)
atcn.itcast.datasoure.Druid.DruidDemo.main(DruidDemo.java:24)

该怎么解决呢？
分 -->
回复

使用道具 举报

千问 | 2021-1-27 05:27:04 | 显示全部楼层
url=jdbc:mysql:///first?serverTimezone=UTC
这里写错误了没有服务器
回复

使用道具 举报

千问 | 2021-1-27 05:27:04 | 显示全部楼层
#1正解。
我是yml文件，所以是url:
url:jdbc:mysql://localhost:3306/testdb?serverTimezone=UTC
回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

千问

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
回复楼主 返回列表
热门排行