This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes EJB and other Java EE Technologies and the fly likes Throws exception in Spring 3.0 DataAccess with lookup jndi in J2SE app Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Throws exception in Spring 3.0 DataAccess with lookup jndi in J2SE app" Watch "Throws exception in Spring 3.0 DataAccess with lookup jndi in J2SE app" New topic
Author

Throws exception in Spring 3.0 DataAccess with lookup jndi in J2SE app

Jose Carlos Miranda
Greenhorn

Joined: Aug 19, 2011
Posts: 1
Hi everyone..
Can someone help me with the exception in Spring 3.0, I use jee:jndi-lookup with jboss 6 to return a javax.sql.DataSource follow the code



import org.springframework.jdbc.core.JdbcTemplate;


public abstract class CvmImplDao {



/**
*
*/
private JdbcTemplate jdbcTemplate;

/**
*
* @return
*/
public JdbcTemplate getJdbcTemplate() {
return jdbcTemplate;
}


/**
*
* @param jdbcTemplate
*/
public void setJdbcTemplate(final JdbcTemplate jdbcTemplate) {
this.jdbcTemplate = jdbcTemplate;
}


}



<jee:jndi-lookup id="dataSource" jndi-name="java:jdbc/MySqlDS" resource-ref="true" proxy-interface="javax.sql.DataSource" />



<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate" p:dataSource-ref="dataSource" />

mysql-ds.xml
<local-tx-datasource><jndi-name>jdbc/MySqlDS<jndi-name><use-java-context>false</use-java-context>.....


Exception

In this snippet of code throws a exception

// TODO Auto-generated method stub
super.getJdbcTemplate().batchUpdate(super.getSqlStatement(), new BatchPreparedStatementSetter() {…





org.springframework.aop.AopInvocationException: AOP configuration seems to be invalid: tried calling method [public abstract java.sql.Connection javax.sql.DataSource.getConnection() throws java.sql.SQLException] on target [Reference Class Name: javax.sql.DataSource
Address Type: ProxyData
AddressContents: ffffffac ffffffed 0 5 73 7d 0 0 0 1 0 14 6a 61 76 61 78 2e 73 71 6c 2e 44 61 74 61 53 6f 75 72 63 65 ...
Address Type: VMID
AddressContents: ffffffac ffffffed 0 5 73 72 0 13 6a 61 76 61 2e 72 6d 69 2e 73 65 72 76 65 72 2e 55 49 44 f 12 70 d ffffffbf ...
Type: JndiName
Content: jdbc/MySqlDS
]; nested exception is java.lang.IllegalArgumentException: object is not an instance of declaring class
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:196)
at $Proxy9.getConnection(Unknown Source)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:572)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:614)
at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:883)
at br.com.bvmf.icadx.persistencia.impl.comum.RepresentanteInventidorNResidenteDaoImpl.insertBatch(RepresentanteInventidorNResidenteDaoImpl.java:29)
at br.com.bvmf.icadx.negocio.impl.comum.RepresentanteInvestidorNResidenteImpl.processaArquivo(RepresentanteInvestidorNResidenteImpl.java:102)
at com.core.CriaProcessoCvm.submitJobs(CriaProcessoCvm.java:108)
at com.core.CriaProcessoCvm.main(CriaProcessoCvm.java:78)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:44)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:15)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:41)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:20)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:76)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:50)
at org.junit.runners.ParentRunner$3.run(ParentRunner.java:193)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:52)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:191)
at org.junit.runners.ParentRunner.access$000(ParentRunner.java:42)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:184)
at org.junit.runners.ParentRunner.run(ParentRunner.java:236)
at org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:49)
at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:467)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:683)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:390)
at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:197)
Caused by: java.lang.IllegalArgumentException: object is not an instance of declaring class
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:601)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
... 33 more
 
 
subject: Throws exception in Spring 3.0 DataAccess with lookup jndi in J2SE app
 
Similar Threads
javax.naming.Reference incompatible with javax.sql.DataSource
java.lang.Exception: Attempted to use a 5.0 DataSource outside of a 2.3 servlet
Incompatible resource adapter
ClassCast when launching - No exception when using LaunchClient
Problem in Jndi LooK up in Was6.1 for MySql Data Source