配置c3p0连接池时出现问题,
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="com.mysql.jdbc.Driver"></property> <property name="dataSourceName" value="jdbc:mysql://localhost:3306/spring1"></property> <property name="user" value="root"></property> <property name="password" value="dadan123"></property> </bean>
报错为org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
查找之后发现是因为一个属性值写错了。
改正方法,第二项数据库的位置,不是dataSourceName,而是jdbcUrl。