[jboss-user] [JCA/JBoss] - JBoss MS SQL Server DataSource Exception

danielkalcevich do-not-reply at jboss.com
Fri Nov 3 10:55:10 EST 2006


I have tried posting a question similar to this one in a different thread, but got no response, so I thought I would try explaining it a different way.  I am attempting to declare a DataSource in JBoss for MS SQL Server DB to the "/mdc" namespace in the JNDI.  I am receiving an exception (shown below) when I try to access that DataSource through an app deployed in the Tomcat Service (in JBoss).  

My question is what does this exception mean and what can I do to fix it?  For more context, my web app is running Spring with Ibatis 2.2.0.    Thanks.

Daniel

--------
Data Source:

<local-tx-datasource>
		<jndi-name>mdc</jndi-name>
		<connection-url>jdbc:inetdae7:server:1433?database=MDC</connection-url>
		<driver-class>com.inet.tds.TdsDriver</driver-class>
		<user-name>xxxx</user-name>
		xxx
		
			<type-mapping>MS SQLSERVER2000</type-mapping>
		
	</local-tx-datasource>

-----
JBoss Web Resource Ref:

<resource-ref>
    	<res-ref-name>mdc</res-ref-name>
		<res-type>javax.sql.DataSource</res-type>
        <jndi-name>java:/mdc</jndi-name>
    </resource-ref>

-----------
Exception:

Caused by: java.lang.IllegalAccessException: Method=public abstract java.sql.Connection java.sql.Statement.getConnection() throws java.sql.SQLException does not return Serializable
	at org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService.doStatementMethod(WrapperDataSourceService.java:411)
	at org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService.invoke(WrapperDataSourceService.java:223)
	at sun.reflect.GeneratedMethodAccessor127.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
	at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
	at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
	at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
	at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
	at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.java:819)
	at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:420)
	at sun.reflect.GeneratedMethodAccessor126.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:585)
	at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
	at sun.rmi.transport.Transport$1.run(Transport.java:153)
	at java.security.AccessController.doPrivileged(Native Method)
	at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
	at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
	at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
	at java.lang.Thread.run(Thread.java:595)
	at sun.rmi.transport.StreamRemoteCall.exceptionReceivedFromServer(StreamRemoteCall.java:247)
	at sun.rmi.transport.StreamRemoteCall.executeCall(StreamRemoteCall.java:223)
	at sun.rmi.server.UnicastRef.invoke(UnicastRef.java:126)
	at org.jboss.invocation.jrmp.server.JRMPInvoker_Stub.invoke(Unknown Source)
	at org.jboss.invocation.jrmp.interfaces.JRMPInvokerProxy.invoke(JRMPInvokerProxy.java:133)
	at org.jboss.invocation.InvokerInterceptor.invokeInvoker(InvokerInterceptor.java:365)
	at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:197)
	at org.jboss.proxy.ClientMethodInterceptor.invoke(ClientMethodInterceptor.java:74)
	at org.jboss.resource.adapter.jdbc.remote.StatementInterceptor.invoke(StatementInterceptor.java:58)
	at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
	... 119 more

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3983005#3983005

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3983005



More information about the jboss-user mailing list