connection pool not working after application context refresh
<[email protected]> Fri, 5 Aug 2011 14:14:34 +0000
| Newsgroups | gmane.comp.java.springframework.devel |
|---|---|
| Message-ID | <BE56A5CD4DBF2F499364CEFB509D07A4A33507@008-AM1MPN1-041.mgdnok.nokia.com> |
Hi all,
I needed to call AbstractXmlApplicationContext.refresh() so that all the beans are reloaded. After I reloaded I am not able to use "DataSource" object. I tried with cp30. Thinking that it could be bug in cp30 itself I changed to dbcp. Both have same issue. I also upgraded my spring library to 3.0.5 and still the same issue. So this is very likely a bug in Spring or am I doing something wrong?
My bean definition:
<bean id="myDS" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${jdbc.driver}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.user}"/>
<property name="password" value="${jdbc.user.pwd}"/>
</bean>
Exception when I try to access database (only after I call context.refresh())
ERROR: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Data source is closed
STACK TRACE:
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is java.sql.SQLException: Data source is closed
at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:240)
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.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
Any help would be appreciated
Praveen
------------------------------------------------------------------------------
BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA
The must-attend event for mobile developers. Connect with experts.
Get tools for creating Super Apps. See the latest technologies.
Sessions, hands-on labs, demos & much more. Register early & save!
http://p.sf.net/sfu/rim-blackberry-1
_______________________________________________
Springframework-developer mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/springframework-developer