mysql8.0 maven c3p0驱动找不到

最新推荐文章于 2024-07-08 11:16:43 发布

望まない

最新推荐文章于 2024-07-08 11:16:43 发布

阅读量347

点赞数 1

文章标签： mysql

本文链接：https://blog.csdn.net/weixin_54026671/article/details/117549768

版权

好久没用c3p0，就是获取连接就等好一会，然后就报错没驱动。估计是配置文件的问题，折腾了好久，最后发现不用配置文件写就可以了。

记得url要设置为不带&amp转义的！！！

package LaboratoryManagementSystem.utils;

import com.mchange.v2.c3p0.ComboPooledDataSource;

import java.beans.PropertyVetoException;
import java.sql.Connection;
import java.sql.SQLException;

public class text {
    public static void main(String[] args) throws PropertyVetoException, SQLException {
        ComboPooledDataSource dataSource = new ComboPooledDataSource();
        dataSource.setDriverClass("com.mysql.cj.jdbc.Driver");
        dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/LaboratoryManagementSystem?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false");
        dataSource.setUser("root");
        dataSource.setPassword("123456");

        dataSource.setInitialPoolSize(5);
        dataSource.setMinPoolSize(10);
        dataSource.setMaxPoolSize(50);
        dataSource.setMaxStatements(30);
        dataSource.setMaxStatementsPerConnection(20);


        Connection connection = dataSource.getConnection();

        System.out.println(connection);

    }
}

maven的配置：

    <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>mchange-commons-java</artifactId>
      <version>0.2.20</version>
    </dependency>

    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.11</version>
    </dependency>

    <dependency>
      <groupId>com.mchange</groupId>
      <artifactId>c3p0</artifactId>
      <version>0.9.5.5</version>
    </dependency>