[jboss-user] [JNDI/Naming/Network] - Jboss JNDI / Remote access to datasource

[bluenote]

Hi everyone,

I'm accessing a datasource looked up through JNDI from a Java client using Ibatis framework from outside the container.

When performing queries I always end up getting this error:

  | java.lang.IllegalAccessException: Method=public abstract java.sql.Connection java.sql.Statement.getConnection() throws java.sql.SQLException does not return Serializable 
  | 
  | Stacktrace:
  | org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService.doStatementMethod(WrapperDataSourceService.java:411),
  | org.jboss.resource.adapter.jdbc.remote.WrapperDataSourceService.invoke(WrapperDataSourceService.java:223),
  | sun.reflect.GeneratedMethodAccessor106.invoke(Unknown Source),
  | sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25),
  | java.lang.reflect.Method.invoke(Method.java:585),
  | org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155),
  | org.jboss.mx.server.Invocation.dispatch(Invocation.java:94),
  | org.jboss.mx.server.Invocation.invoke(Invocation.java:86),
  | org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264),
  | org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659),
  | 

My Datasource:
	<?xml version="1.0" encoding="UTF-8"?>
  | 	<datasources>
  | 	  <local-tx-datasource>
  | 	        <jndi-name>jdbc/xxxxxDS</jndi-name>
  | 	        <connection-url>jdbc:oracle:thin:@xxxxxxxxx:1521:xxxxxxx</connection-url>
  | 			<use-java-context>false</use-java-context>
  | 	        <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
  | 	        <user-name>xxxxxxxx</user-name>
  | 	        <password>xxxxxx</password>
  | 	        <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
  | 	        <min-pool-size>5</min-pool-size>
  | 	        <max-pool-size>20</max-pool-size>
  | 	    </local-tx-datasource>
  | 	</datasources>
  | 

I'm using JBoss 4.0.4.GA. Any help is much appreciated!

Thanks in advance,

Michael

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

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