[jboss-user] [Spring Integration] - Spring Integration with Jboss datasource not working

kumaran srinivasan [http://community.jboss.org/people/kumaran_is] created the discussion "Spring Integration with Jboss datasource not working" To view the discussion, visit: http://community.jboss.org/message/534727#534727 -------------------------------------------------------------- I have business layer with EJB3 as session facade layer, Spring beans , Hibernate as ORM tool  and MySQL database running on Jboss5. *When i configure datasource as DriverManagerDataSource(see below) ,it is working perfectly* <bean id="dataSource"  class="org.springframework.jdbc.datasource.DriverManagerDataSource" >         <property name="driverClassName">             <value>${jdbc_driverClassName}</value>         </property>         <property name="url">             <value>${jdbc_url}</value>         </property>         <property name="username">             <value>${jdbc_username}</value>         </property>         <property name="password">             <value>${jdbc_password}</value>         </property>     </bean> *But when i try to use  datasource from jboss using JNDI(see below) , its giving exception as mentioned below* <bean id="dataSource"         class="org.springframework.jndi.JndiObjectFactoryBean">         <property name="jndiTemplate" ref="jndiTemplate" />         <property name="jndiName" value="${jndi_freeads_ds}" />     </bean > *I have attached my spring config xml file.Please let me know how to resolve it.* *Exception:* (UserInfoBusinessServiceImpl.java:315)     - Inside  isAlreadyLoginExists() method... 22:24:53,060 INFO  [STDOUT] 29 Mar 2010 22:24:53,59 [http-127.0.0.1-8080-1] dao.UserInfoDAOImpl (UserInfoDAOImpl.java:130)     - findByLoginId  loginId is : kumaran.isk(a)yahoo.com (mailto:kumaran.isk@yahoo.com) 22:24:53,090 INFO  [STDOUT] Hibernate: select count(*) as col_0_0_ from freeads.user_info userinfo0_ where userinfo0_.LOGIN_ID=? 22:24:53,124 INFO  [STDOUT] 29 Mar 2010 22:24:53,123 [http-127.0.0.1-8080-1] dao.UserInfoDAOImpl (UserInfoDAOImpl.java:140)     - findByLoginId result is : false 22:24:53,129 INFO  [STDOUT] 29 Mar 2010 22:24:53,126 [http-127.0.0.1-8080-1] transaction.JDBCTransaction (JDBCTransaction.java:124)     - JDBC commit failed *java.sql.SQLException: You cannot commit during a managed transaction!*     at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:659)     at org.jboss.resource.adapter.jdbc.WrappedConnection.commit(WrappedConnection.java:486)     at org.hibernate.transaction.JDBCTransaction.commitAndResetAutoCommit(JDBCTransaction.java:139)     at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:115)     at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655)     at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)     at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)     at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321)     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116)     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)     at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)     at $Proxy326.findByLoginId(Unknown Source)     at com.bluec.freeads.businessservice.UserInfoBusinessServiceImpl.isAlreadyLoginExists(UserInfoBusinessServiceImpl.java:319)     at com.bluec.freeads.ejb.UserInfoSessionBean.isLoginAlreadyExists(UserInfoSessionBean.java:308)     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)     at java.lang.reflect.Method.invoke(Method.java:592)     at org.jboss.aop.joinpoint.MethodInvocation.invokeTarget(MethodInvocation.java:122)     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111)     at org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69)     at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73)     at org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59)     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)     at java.lang.reflect.Method.invoke(Method.java:592)     at org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174)     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)     at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72)     at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_1217755329.invoke(InvocationContextInterceptor_z_fillMethod_1217755329.java)     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)     at org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88)     at org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_1217755329.invoke(InvocationContextInterceptor_z_setup_1217755329.java)     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)     at org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62)     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)     at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56)     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)     at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)     at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)     at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68)     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)     at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)     at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:190)     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)     at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)     at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)     at org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:186)     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)     at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41)     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)     at org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67)     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)     at org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67)     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)     at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:421)     at org.jboss.ejb3.remoting.IsLocalInterceptor.invokeLocal(IsLocalInterceptor.java:85)     at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:72)     at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)     at org.jboss.aspects.remoting.PojiProxy.invoke(PojiProxy.java:62)     -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/534727#534727] Start a new discussion in Spring Integration at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]