Error in configuration/accessing JBoss datasource jdbc not bound

[corrado martini]

Hello , I'm trying to use JBOSS for my Java struts application. But this error makes me mad!!
The connection with Db2 database is ok when using Tomcat 7.0.11 installed on my PC , but in my company I have to use JBOSS so I've istalled JBOSS rel 5.1.0

First the datasource is this: db2-ds.xml:

<datasources>
    <local-tx-datasource>
        <jndi-name>jdbc/myapplication</jndi-name>
		<use-java-context>true</use-java-context>
        <user-name>USER</user-name>
        <password>PWD</password>
        <prepared-statement-cache-size>0</prepared-statement-cache-size>
        <share-prepared-statements>false</share-prepared-statements>
        <set-tx-query-timeout>false</set-tx-query-timeout>
        <driver-class>com.ibm.db2.jcc.DB2Driver</driver-class>
        <connection-url>jdbc:<url & port ></connection-url>
	</local-tx-datasource>
</datasources>

Second file web.xml contains:

....
   <resource-ref>       
        <res-ref-name>jdbc/myapplication</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>Container</res-auth>
        <res-sharing-scope>Shareable</res-sharing-scope>
    </resource-ref>

Third file jboss-web.xml:

<jboss-web>
  <context-root>/bicomp</context-root>
  <resource-ref>
    <res-ref-name>jdbc/bicomp</res-ref-name>
    <!-- matches web.xml -->
    <jndi-name>jdbc/bicomp</jndi-name>
    <!-- matches oracle-ds.xml -->
    <res-type>javax.sql.DataSource</res-type>
  </resource-ref>
</jboss-web>

Fourth, java code in servlet action:

 connectionFactory = new ConnectionFactory();
 javax.naming.Context ctx = new javax.naming.InitialContext();
 Context envContext=(Context)ctx.lookup("java:comp/env");
 javax.sql.DataSource ds = (javax.sql.DataSource)envContext.lookup("jdbc/myapplication");    
 Connection conn = ds.getConnection();

Fifth server.log:

2011-12-13 16:17:30,200 INFO  [org.jboss.profileservice.management.upload.remoting.DeployHandler] (WorkerThread#0[127.0.0.1:1381]) Failed to complete command: [start] for deployment: names=[myapplication.war], copyContent=true
java.lang.NullPointerException
	at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:775)
	at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:702)
	at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117)
	at org.jboss.profileservice.management.upload.remoting.AbstractDeployHandler.start(AbstractDeployHandler.java:263)
	at org.jboss.profileservice.management.upload.remoting.AbstractDeployHandler.invoke(AbstractDeployHandler.java:177)
	at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:891)
	at org.jboss.remoting.transport.socket.ServerThread.completeInvocation(ServerThread.java:744)
	at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:697)
	at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:524)
	at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:232)
2011-12-13 16:17:31,294 WARN  [org.jboss.managed.plugins.factory.AbstractManagedObjectPopulator] (WorkerThread#0[127.0.0.1:1385]) Cannot create String name from non-Simple property: ManagedProperty{JNDIName,JNDIName,metaType=SimpleMetaType:java.lang.String}, value=null
2011-12-13 16:17:31,310 WARN  [org.jboss.managed.plugins.factory.AbstractManagedObjectPopulator] (WorkerThread#0[127.0.0.1:1385]) Cannot create String name from non-Simple property: ManagedProperty{JNDIName,JNDIName,metaType=SimpleMetaType:java.lang.String}, value=null
2011-12-13 16:17:34,872 INFO  [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (HDScanner) deploy, ctxPath=/myapplication
2011-12-13 16:19:34,960 INFO  [STDOUT] (http-127.0.0.1-8080-1) 119385 [http-127.0.0.1-8080-1] INFO com.myapp.struts.LoginAction  - Nella loginAction!!!!
2011-12-13 16:19:34,960 INFO  [STDOUT] (http-127.0.0.1-8080-1) 119385 [http-127.0.0.1-8080-1] INFO com.myapp.struts.LoginAction  - Dopo new oggetto connection factory !!
2011-12-13 16:19:34,960 INFO  [STDOUT] (http-127.0.0.1-8080-1) 119385 [http-127.0.0.1-8080-1] INFO com.myapp.struts.LoginAction  - settato envContext
2011-12-13 16:19:34,960 INFO  [STDOUT] (http-127.0.0.1-8080-1) 119385 [http-127.0.0.1-8080-1] WARN org.apache.struts.util.PropertyMessageResources  -   Resource org/apache/struts/action/ActionResources_it_IT.properties Not Found.
2011-12-13 16:19:34,991 INFO  [STDOUT] (http-127.0.0.1-8080-1) 119416 [http-127.0.0.1-8080-1] WARN org.apache.struts.util.PropertyMessageResources  -   Resource org/apache/struts/action/ActionResources_it.properties Not Found.
2011-12-13 16:19:34,991 INFO  [STDOUT] (http-127.0.0.1-8080-1) 119416 [http-127.0.0.1-8080-1] WARN org.apache.struts.action.RequestProcessor  - Unhandled Exception thrown: class javax.naming.NamingException
2011-12-13 16:19:34,991 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/myapplication].[action]] (http-127.0.0.1-8080-1) Servlet.service() for servlet action threw exception
javax.naming.NameNotFoundException: jdbc not bound
	at org.jnp.server.NamingServer.getBinding(NamingServer.java:771)
	at org.jnp.server.NamingServer.getBinding(NamingServer.java:779)
	at org.jnp.server.NamingServer.getObject(NamingServer.java:785)
	at org.jnp.server.NamingServer.lookup(NamingServer.java:396)
	at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:726)
	at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:686)
	at javax.naming.InitialContext.lookup(InitialContext.java:392)
	at org.jnp.interfaces.NamingContext.resolveLink(NamingContext.java:1346)
	at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:817)
	at org.jnp.interfaces.NamingContext.lookup(NamingContext.java:686)
	at com.myapp.struts.LoginAction.execute(LoginAction.java:97)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:228)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
	at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
	at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:619)[color=#444444] [/color][size=12] [/size] :banghead:  :banghead:  :banghead: 

Any advice is very appreciated, thanks in advance

[Joydeep Ghatak]

Hi Martini,

Please double check the -ds.xml file.
You can refer the following link,

http://www.coderanch.com/t/549915/JBoss/JBoss-Oracle-Configuration-new-DataSource

Thanks,
Joydeep

[corrado martini]

Sorry the file jboss-web.xml is

   1. <jboss-web>  
   2.   <context-root>/myapplication</context-root>  
   3.   <resource-ref>  
   4.     <res-ref-name>jdbc/myapplication</res-ref-name>  
   5.     <!-- matches web.xml -->  
   6.     <jndi-name>jdbc/myapplication</jndi-name>  
   7.     <!-- matches oracle-ds.xml -->  
   8.     <res-type>javax.sql.DataSource</res-type>  
   9.   </resource-ref>  
  10. </jboss-web>  

Now the error is javax.servlet.ServletException: java.lang.ClassCastException: org.jboss.resource.adapter.jdbc.WrapperDataSource cannot be cast to javax.sql.DataSource

I've just find in this link:
comunity Jboss

I've done all things indicated: the driver's file ( .jar and .zip) are placed in correct directory: C:\Programmi\JBOSS\jboss-5.1.0.GA\server\default\lib

In file server log I see those lines:

[org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (main) Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=jdbc/myapplication' to JNDI name 'java:jdbc/myapplication'
2011-12-14 11:58:13,762 INFO  [org.jboss.resource.connectionmanager.ConnectionFactoryBindingService] (main) Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS'

 INFO  [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy, ctxPath=/
2011-12-14 11:58:19,605 INFO  [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy, ctxPath=/myapplication
2011-12-14 11:58:20,090 INFO  [org.jboss.web.tomcat.service.deployers.TomcatDeployment] (main) deploy, ctxPath=/jmx-console

But a run-tine, when java servlet try to access datasource I have same error:

javax.servlet.ServletException: java.lang.ClassCastException: org.jboss.resource.adapter.jdbc.WrapperDataSource cannot be cast to javax.sql.DataSource

[Jaikiran Pai]

Do you have any jar file(s) containing javax.sql.* classes in your application? If yes, remove such jars from the application packaging.

[corrado martini]

Ok I have an example, project named "prova" developed with Tomcat Application server with Db2 libraries placed under WEB-INF\lib . And this is OK: look at this screen shot:

[Jaikiran Pai]

You'll have to remove that jar from the application being deployed. You can still have it in your compile time classpath but just not in the deployed application packaging.

[corrado martini]

Well , I have on this link , previous image is not clear, sorry

the situationscreen shot Tomcat & Jboss configuration in Netbeans IDE

In JBoss application. I have removed Db2 jar file from WEB-INF/lib and put in Jboss lib directory C:\Programmi\JBOSS\jboss-5.1.0.GA\server\default\lib

[corrado martini]

This is correct link link

[corrado martini]

I solve the problem. Your suggestion /advice was right I have to remove db2 driver's jar included in the application
I firstly remove these jar files using Netbeans IDE interface ( I have Netbeans 7.0 version), but even if I removed these file is included in .war file that I deployed.

Finally I realize the mistake opening my application war , using winrar, I erased the db2 drivers files and the connection with db2 database is OK
I beg your pardon for the delay of my reply but in these days I was off to work for personal problem, so have a good 2012 and thanks a lot.

[Jaikiran Pai]

Glad to know you got it working