mysql8.0的c3p0配置
时间: 2023-10-05 07:14:09 浏览: 41
mysql8.0的c3p0配置如下所示:
```xml
<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
<default-config>
<property name="driverClass">com.mysql.cj.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://localhost:3306/Web09?useSSL=false&serverTimezone=UTC</property>
<property name="user">root</property>
<property name="password">root</property>
<property name="initialPoolSize">5</property>
<property name="maxPoolSize">20</property>
</default-config>
<named-config name="itheima">
<property name="driverClass">com.mysql.cj.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://localhost:3306/web09?useSSL=false&serverTimezone=UTC</property>
<property name="user">root</property>
<property name="password">root</property>
</named-config>
</c3p0-config>
```
该配置文件中,`default-config`是默认配置,`named-config`是命名配置。默认配置中的`driverClass`指定了MySQL驱动程序的类名,`jdbcUrl`指定了连接的数据库URL,`user`和`password`分别指定了连接数据库的用户名和密码,`initialPoolSize`指定了连接池的初始连接数,`maxPoolSize`指定了连接池的最大连接数。命名配置中的配置与默认配置类似,可以根据需要自定义命名配置。<span class="em">1</span>
#### 引用[.reference_title]
- *1* [mysql 8.0 版本 c3p0-config.xml配置](https://blog.csdn.net/qq_41734885/article/details/80967976)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 100%"]
[ .reference_list ]