java.sql.SQLException: Connection handle is not currently as

[saleti]

Hi,

I am getting the following error when i access my application using Transaction using Spring Jdbc

org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: Connecti
on handle is not currently associated with a ManagedConnection
java.sql.SQLException: Connection handle is not currently associated with a ManagedConnection

We are trying to migrate an application from weblogic to jboss and it works fine on weblogic but getting the above error in jboss

My Spring applicationcontext-jdbc.xml entry












Please help
Thanks

[weston.price]

Your going to have to do alot better than what you posted.

First please read:

http://wiki.jboss.org/wiki/Wiki.jsp?page=JBossHelp

To learn how to post to the forums. At the very least, post your *-ds.xml file. As far as your Spring context file, that may have been helpful if it actually showed up in your post.

[saleti]

my applicationcontext-jdbc.xml entry is

 <bean id="transactionManager" class="org.springframework.transaction.jta.JtaTransactionManager"/>

 <bean id="roleDAO" class="com.xxx.xxxx.xxxxx">
 <property name="dataSource" ref="dataSource"/>
 <property name="transactionManager">
 <ref bean="transactionManager" />
 </property>
 </bean>

[saleti]

and my-ds.xml is

<datasources>
 <local-tx-datasource>
 <jndi-name>jdbc/myDS</jndi-name>
 <connection-url>jdbc:oracle:thin:@abcd:1565:abcd</connection-url>
 <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
 <user-name>user</user-name>
 <password>password</password>
 <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>

 </local-tx-datasource>
</datasources>