ResourcePool не удалось получить ресурс из своей первичной фабрики или источника
я пытаюсь подключиться к базе данных в Java, используя jdbcTemplate и яЯ получаю ошибку ниже. Я давно гуглил и все найденные мной решения нене решить мою проблему. Я пробовал несколько разных БД (как SQLServer, так и MySQL), но ни одна не работала.
SEVERE: Servlet.service() for servlet [Faces Servlet] in context with path [/promotion-handler-admin] threw exception [Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!] with root cause
com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:202)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:371)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:335)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:105)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:622)
...
Это мой файл свойств:
app.driverClassName=net.sourceforge.jtds.jdbc.Driver
app.url=jdbc:sqlserver://myUrl:port;databaseName=my_database
app.username=myUsername
app.password=myPassword
WebApp / WEB-INF / ApplicationContext-database.xml:
Класс DAO:
@Repository
public class CampaignDAO {
private JdbcTemplate jdbcTemplate;
@Resource(name = "dataSource")
public void setDataSource(DataSource dataSource) {
this.jdbcTemplate = new JdbcTemplate(dataSource);
}
public List getCampaignList() {
Long start = System.currentTimeMillis();
List queryList;
try {
queryList = jdbcTemplate.query("SELECT * FROM campaign", new RowMapper() {
public Campaign mapRow(ResultSet rs, int line) throws SQLException {
Campaign campaign = new Campaign();
campaign.setId(rs.getLong("id"));
campaign.setExtraInfo(rs.getString("extra_info"));
campaign.setBeginTime(rs.getDate("begin_time"));
campaign.setEndTime(rs.getDate("end_time"));
return campaign;
}
});
} finally {
...
}
return queryList;
}