//1.匯入jar包
//2.匯入組態檔
//3.加載組態檔
Properties pro = new Properties();
InputStream resourceAsStream = DruidDemo.class.getClassLoader().getResourceAsStream("druid.properties");
pro.load(resourceAsStream);
//4.獲取資料庫連接池物件
DataSource ds = DruidDataSourceFactory.createDataSource(pro);
//5.獲取連接物件
Connection connection = 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
警告: Cannot resolve com.mysq.jdbc.Connection.ping method. Will use 'SELECT 1' instead.
java.lang.NullPointerException
at com.alibaba.druid.pool.vendor.MySqlValidConnectionChecker.<init>(MySqlValidConnectionChecker.java:48)
at com.alibaba.druid.pool.DruidDataSource.initValidConnectionChecker(DruidDataSource.java:878)
at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:594)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:915)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:911)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:98)
at cn.itcast.datasoure.Druid.DruidDemo.main(DruidDemo.java:24)
4月 26, 2020 10:14:44 上午 com.alibaba.druid.pool.DruidDataSource error
嚴重: init datasource error
java.sql.SQLException: validateConnection false
at com.alibaba.druid.pool.DruidAbstractDataSource.validateConnection(DruidAbstractDataSource.java:1216)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1439)
at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:618)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:915)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:911)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:98)
at cn.itcast.datasoure.Druid.DruidDemo.main(DruidDemo.java:24)
4月 26, 2020 10:14:44 上午 com.alibaba.druid.pool.DruidDataSource error
嚴重: dataSource init error
java.sql.SQLException: validateConnection false
at com.alibaba.druid.pool.DruidAbstractDataSource.validateConnection(DruidAbstractDataSource.java:1216)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1439)
at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:618)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:915)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:911)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:98)
at cn.itcast.datasoure.Druid.DruidDemo.main(DruidDemo.java:24)
4月 26, 2020 10:14:44 上午 com.alibaba.druid.pool.DruidDataSource info
資訊: {dataSource-1} inited
Exception in thread "main" java.sql.SQLException: validateConnection false
at com.alibaba.druid.pool.DruidAbstractDataSource.validateConnection(DruidAbstractDataSource.java:1216)
at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1439)
at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:618)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:915)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:911)
at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:98)
at cn.itcast.datasoure.Druid.DruidDemo.main(DruidDemo.java:24)
該怎么解決呢？
uj5u.com熱心網友回復：
url=jdbc:mysql:///first?serverTimezone=UTC這里寫錯誤了 沒有服務器
uj5u.com熱心網友回復：
#1正解。我是yml檔案，所以是url:
url: jdbc:mysql://localhost:3306/testdb?serverTimezone=UTC
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/83557.html
標籤：Java EE
上一篇：這個是什么原因，電腦8G記憶體