用eclipse写web项目时,用C3P0连接navigate里面的数据怎么都连接不上,各位大神帮帮忙😭
你没有给出报错信息 注意jar:官网下载cp30依赖包与数据库驱动(注意版本小心冲突)注意部署:把jar放入lib文件夹add biud 注意配置文件:编写配置文件可参考:(https://blog.csdn.net/qq_37717494/article/details/104564414)
望采纳,谢谢
<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
<!-- This is default config! -->
<default-config>
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://localhost:3306/contacts?characterEncoding=utf8</property>
<property name="user">root</property>
<property name="password">123456</property>
<property name="acquireIncrement">5</property>
<property name="initialPoolSize">10</property>
<property name="minPoolSize">5</property>
<property name="maxPoolSize">20</property>
<property name="maxStatements">0</property>
<property name="maxStatementsPerConnection">5</property>
</default-config>
<!-- This is my config for mysql-->
<named-config name="mysql">
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://localhost:3306/test</property>
<property name="user">root</property>
<property name="password">123456</property>
<property name="initialPoolSize">10</property>
<property name="maxIdleTime">30</property>
<property name="maxPoolSize">100</property>
<property name="minPoolSize">10</property>
<property name="maxStatements">200</property>
</named-config>
</c3p0-config>
把eclipse报错消息发一下
对照配置文件看看,utf-8 什么有没有写。
数据库信息,C3P0配置,报错信息都贴一下,不然神仙也不知道怎么做
已解决