I am using DataSourceTransactionManager since we have one datasource and JNDI lookup is used for datasource.
Everything worked fine with Tomcat on local but once we deployed it on websphere it failed with loading testing incase of mulitple connections.
I get following exceptions-
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Connection is closed.
I have very little knowledge in Spring Transact on Management I want to know if is was right to use DataSourceTransactionManager
with JNDI lookup.
Or there is something else.
If you are deploying on an App Server, you typically want to use their JTA Transaction Manager. You can do that in Spring with <tx:jta-transaction-manager/>. Spring will automatically detect which app server you are in and use its JTA TransactionManager.