From: <pra...@no...> - 2011-08-05 14:14:46
|
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 |