[jboss-user] [Datasource Configuration] - Deploying datasource via -ds.xml files in JBoss AS 7.1.1.Final

Srinivas Reddy Bijjam [https://community.jboss.org/people/srinivas.bijjam] created the discussion "Deploying datasource via -ds.xml files in JBoss AS 7.1.1.Final" To view the discussion, visit: https://community.jboss.org/message/762017#762017 -------------------------------------------------------------- Dear All *  I am getting the following error while looking up the datasource that was bounded by ds.xml file but it is working fine with the datasource that is defined in standalonefull.xml* *+22:53:08,531 ERROR [stderr] (http--127.0.0.1-8080-4) java.lang.ClassCastException: javax.naming.Reference cannot be cast to javax.sql.DataSource+* +22:53:08,531 ERROR [stderr] (http--127.0.0.1-8080-4)      at xxx.utils.DataSourceHelper.getDataSource(DataSourceHelper.java:31)+ +22:53:08,531 ERROR [stderr] (http--127.0.0.1-8080-4)      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)+ +22:53:08,531 ERROR [stderr] (http--127.0.0.1-8080-4)      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)+ +22:53:08,531 ERROR [stderr] (http--127.0.0.1-8080-4)      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)+ +22:53:08,531 ERROR [stderr] (http--127.0.0.1-8080-4)      at java.lang.reflect.Method.invoke(Method.java:597)+ +22:53:08,531 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.as.ee.component.ManagedReferenceMethodInterceptorFactory$ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptorFactory.java:72)+ +22:53:08,546 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)+ +22:53:08,546 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)+ +22:53:08,546 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:36)+ +22:53:08,546 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)+ +22:53:08,546 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.as.jpa.interceptor.SBInvocationInterceptor.processInvocation(SBInvocationInterceptor.java:47)+ +22:53:08,546 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)+ +22:53:08,546 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.as.ejb3.tx.EjbBMTInterceptor.handleInvocation(EjbBMTInterceptor.java:105)+ +22:53:08,546 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.as.ejb3.tx.BMTInterceptor.processInvocation(BMTInterceptor.java:56)+ +22:53:08,546 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)+ +22:53:08,546 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)+ +22:53:08,562 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)+ +22:53:08,562 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)+ +22:53:08,562 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)+ +22:53:08,562 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)+ +22:53:08,562 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.as.ejb3.component.pool.PooledInstanceInterceptor.processInvocation(PooledInstanceInterceptor.java:51)+ +22:53:08,562 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)+ +22:53:08,562 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.as.ejb3.remote.EJBRemoteTransactionPropagatingInterceptor.processInvocation(EJBRemoteTransactionPropagatingInterceptor.java:80)+ +22:53:08,562 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)+ +22:53:08,562 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)+ +22:53:08,562 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)+ +22:53:08,578 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)+ +22:53:08,578 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)+ +22:53:08,578 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.as.ejb3.component.interceptors.EjbExceptionTransformingInterceptorFactories$1.processInvocation(EjbExceptionTransformingInterceptorFactories.java:65)+ +22:53:08,578 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)+ +22:53:08,578 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)+ +22:53:08,578 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)+ +22:53:08,578 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:32)+ +22:53:08,578 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)+ +22:53:08,578 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)+ +22:53:08,578 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)+ +22:53:08,593 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)+ +22:53:08,593 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165)+ +22:53:08,593 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.as.ejb3.remote.LocalEjbReceiver.processInvocation(LocalEjbReceiver.java:179)+ +22:53:08,593 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:179)+ +22:53:08,593 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.ejb.client.TransactionInterceptor.handleInvocation(TransactionInterceptor.java:43)+ +22:53:08,593 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:181)+ +22:53:08,593 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.ejb.client.ReceiverInterceptor.handleInvocation(ReceiverInterceptor.java:128)+ +22:53:08,593 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.ejb.client.EJBClientInvocationContext.sendRequest(EJBClientInvocationContext.java:181)+ +22:53:08,593 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.ejb.client.EJBInvocationHandler.doInvoke(EJBInvocationHandler.java:136)+ +22:53:08,609 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.ejb.client.EJBInvocationHandler.doInvoke(EJBInvocationHandler.java:121)+ +22:53:08,609 ERROR [stderr] (http--127.0.0.1-8080-4)      at org.jboss.ejb.client.EJBInvocationHandler.invoke(EJBInvocationHandler.java:104)+ *java code to look up is* | |   | | Context ctx = new InitialContext(); | | |   | | return (javax.sql.DataSource) ctx.lookup("java:/"+dsName); | *mydatasource-ds.xml* <?xml version="1.0" encoding="UTF-8"?><datasources> <xa-datasource enabled="true" jndi-name="java:/mydatasource" pool-name="mydatasource" use-java-context="true"> <xa-datasource-property name="URL">jdbc:oracle:thin:@localhost:1521:orcl</xa-datasource-property> <driver>ojdbc6</driver> <xa-pool> <min-pool-size>1</min-pool-size> <max-pool-size>20</max-pool-size> <prefill>true</prefill> <is-same-rm-override>false</is-same-rm-override> <no-tx-separate-pools>true</no-tx-separate-pools> </xa-pool> <security> <user-name>xxx</user-name> <password>xxx</password> </security> <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class> </xa-datasource> </datasources> *standalonefull.xml content is*             <datasources>                 <xa-datasource jndi-name="java:/xxx-oraclePool" pool-name="xxx-oraclePool" enabled="true" use-java-context="true">                     <xa-datasource-property name="URL">                         jdbc:oracle:thin:@localhost:1521:orcl                     </xa-datasource-property>                     <driver>ojdbc6</driver>                     <xa-pool>                         <min-pool-size>1</min-pool-size>                         <max-pool-size>20</max-pool-size>                         <prefill>true</prefill>                         <is-same-rm-override>false</is-same-rm-override>                         <no-tx-separate-pools>true</no-tx-separate-pools>                     </xa-pool>                     <security>                         <user-name>xxx</user-name>                         <password>xxx</password>                     </security>                 </xa-datasource>                 <drivers>                     <driver name="ojdbc6" module="com.oracle.ojdbc6">                         <driver-class>oracle.jdbc.OracleDriver</driver-class>                         <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>                     </driver>                 </drivers>             </datasources> *module.xml is* <?xml version="1.0" encoding="UTF-8"?> <module xmlns="urn:jboss:module:1.0" name="com.oracle.ojdbc6">   <resources>     <resource-root path="ojdbc6.jar"/>   </resources>   <dependencies>     <module name="javax.api"/>     <module name="javax.transaction.api"/> </dependencies> </module> What is the reason it is throwing error for ds.xml but working fine for standalone-full.xml? -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/762017#762017] Start a new discussion in Datasource Configuration at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&...]