JBoss 4.2.0 and Oracle 10g Configuration Issue with new DataSource

[Joydeep Ghatak]

I have a EAR file which runs fine on IBM websphere (6.0 and 6.1), now I want to run it on Jboss 4.2.0.As this is a dynamic website I need to make an oracle
connection and where the datasource name is different from DefaultDS. I am not using EJB's.
I have configured JBoss inside Eclipse 3.7 (Indigo) and going to do any modification on the code etc through eclipse-JBoss combination only.

What I have done so far in this approach,(in other approach as per http://community.jboss.org/wiki/ConfigJBossMQDB, I was getting some other Exception)

1. Created the oracle-ds.xml with DB and application specific parameters.
2. Deployed the oracle-ds.xml in C:\jboss-4.2.0.GA\server\default\deploy directory
3. Kept the hsqldb-ds.xml as it is, in the same location (As it comes default)
4. Provided the ojdbc14.jar in C:\jboss-4.2.0.GA\server\default\lib

Output ::
==========
1. JBoss starts successfully, showing it is able to detect the new application specific JNDI name (MY_ds)

 
..................
..................
10:19:55,064 INFO  [StdSchedulerFactory] Quartz scheduler version: 1.5.2
10:19:55,064 INFO  [QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.
10:19:56,861 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 
'java:DefaultDS'
10:19:57,298 INFO  [A] Bound to JNDI name: queue/A
10:19:57,298 INFO  [B] Bound to JNDI name: queue/B
10:19:57,298 INFO  [C] Bound to JNDI name: queue/C
10:19:57,298 INFO  [D] Bound to JNDI name: queue/D
10:19:57,298 INFO  [ex] Bound to JNDI name: queue/ex
10:19:57,329 INFO  [testTopic] Bound to JNDI name: topic/testTopic
..................
..................
10:19:58,923 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 
'java:JmsXA'
10:19:59,017 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=MY_ds' to JNDI name 'java:MY_ds'
10:20:01,142 INFO  [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
10:20:01,579 INFO  [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8080
10:20:01,626 INFO  [AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009
10:20:01,626 INFO  [Server] JBoss (MX MicroKernel) [4.2.0.GA (build: SVNTag=JBoss_4_2_0_GA date=200705111440)] Started in 36s:234ms
.................
.................

2. But When I have deployed my application .EAR file, I am receiving the following exception(s),

2.1

.................
.................
10:21:28,673 INFO  [EARDeployer] Init J2EE application: file:/C:/jboss-4.2.0.GA/server/default/deploy/MYUsersUI.ear
10:21:40,766 INFO  [TomcatDeployer] deploy, ctxPath=/MYUsersUI, warUrl=.../tmp/deploy/tmp6753183972854520762MYUsersUI.ear-contents/MYUIWeb-exp.war/
10:21:40,766 WARN  [ServiceController] Problem starting service jboss.web.deployment:war=MYUIWeb.war,id=-771197716
org.jboss.deployment.DeploymentException: Error during deploy; - nested throwable: (javax.naming.NamingException: resource-ref: jdbc/MY_ds has no valid JNDI 

binding. Check the jboss-web/resource-ref.)
	at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:384)
	at org.jboss.web.WebModule.startModule(WebModule.java:83)
	at org.jboss.web.WebModule.startService(WebModule.java:61)
................
.................

2.2

.................
.................
10:21:40,766 ERROR [MainDeployer] Could not start deployment: 

file:/C:/jboss-4.2.0.GA/server/default/tmp/deploy/tmp6753183972854520762MYUI.ear-contents/MYUIWeb.war
org.jboss.deployment.DeploymentException: Error during deploy; - nested throwable: (javax.naming.NamingException: resource-ref: jdbc/MY_ds has no valid JNDI 

binding. Check the jboss-web/resource-ref.)
	at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:384)
	at org.jboss.web.WebModule.startModule(WebModule.java:83)
	at org.jboss.web.WebModule.startService(WebModule.java:61)

2.3

.................
.................
	at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:274)
	at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:225)
Caused by: javax.naming.NamingException: resource-ref: jdbc/MY_ds has no valid JNDI binding. Check the jboss-web/resource-ref.
	at org.jboss.web.AbstractWebDeployer.linkResourceRefs(AbstractWebDeployer.java:623)
	at org.jboss.web.AbstractWebDeployer.parseWebAppDescriptors(AbstractWebDeployer.java:512)

Info ::
====
1. oracle-ds.xml

<datasources>
  <local-tx-datasource>
    <jndi-name>MY_ds</jndi-name>
    <connection-url>jdbc:oracle:thin:@<server_name>:<port>:<DBName></connection-url>
   <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
    <user-name>User</user-name>
    <password>pass</password>
  <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
      <metadata>
         <type-mapping>Oracle9i</type-mapping>
      </metadata>
  </local-tx-datasource>

</datasources>

I am able to connect to this database with the above user_name and password using TOAD
2.
web.xml of the application is as follows,

.................
.................
	<resource-ref id="ResourceRef_1188765432">
		<res-ref-name>jdbc/MY_ds</res-ref-name>
		<res-type>javax.sql.DataSource</res-type>
		<res-auth>Application</res-auth>
		<res-sharing-scope>Shareable</res-sharing-scope>
	</resource-ref>

Do I have to modify some other .xml file(s) as well ?

[Peter Johnson]

You also need a jboss-web.xml file. This post might help you put it all together:
http://community.jboss.org/message/251298#251298

[Joydeep Ghatak]

Thanks Peter.

Well by default I do not have jboss-web.xml file in my project.
So do I have to create a new jboss-web.xml and put it in <project_home>/src/web/WEB-INF directory ? or in some other location ?

Do I have to provide the same file anywhere in Jboss server ?

Thanks in advance !!!

Thanks,
Joydeep

[Joydeep Ghatak]

Thanks a lot Peter,

I have create a new jboss-web.xml and put it in <project_home>/src/web/WEB-INF directory and its working !!! :-)
But in the log I have seen some exceptions as follows,

11:24:02,130 INFO  [WebappClassLoader] validateJarFile(C:\jboss-4.2.0.GA\server\default\.\tmp\deploy\tmp7126769961600028240MYUI.ear-contents\MYUIWeb-exp.war\WEB-INF\lib\j2ee.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
11:24:02,271 ERROR [STDERR] log4j:ERROR A "org.jboss.logging.appender.FileAppender" object is not assignable to a "org.apache.log4j.Appender" variable.
11:24:02,271 ERROR [STDERR] log4j:ERROR The class "org.apache.log4j.Appender" was loaded by 
11:24:02,271 ERROR [STDERR] log4j:ERROR [WebappClassLoader
  delegate: false
  repositories:
    /WEB-INF/classes/
----------> Parent Classloader:
java.net.FactoryURLClassLoader@b5b80
] whereas object of type 
11:24:02,271 ERROR [STDERR] log4j:ERROR "org.jboss.logging.appender.FileAppender" was loaded by [org.jboss.system.server.NoAnnotationURLClassLoader@1754ad2].
11:24:02,271 ERROR [STDERR] log4j:ERROR Could not instantiate appender named "FILE".

Thanks,
Joydeep

[Peter Johnson]

These errors suggest that you have the log4j or commons-logging JAR file in your WAR, remove them.

[Joydeep Ghatak]

Thanks a lot Peter.

Sorry for the delay in replying back, was entangled with some other project and other issues. (http://www.coderanch.com/t/549915/JBoss/JBoss-Oracle-Configuration-new-DataSource)

Well my project WEB-INF/lib contains both "log4j" and "commons-logging" JAR and to test, I have removed both the jar's from project location WEB-INF/lib in IDE.
Now IDE(Eclipse) is giving the following "Java Build Path Problem",

Project 'MYAPPUIWeb' is missing required library: 'WebContent/WEB-INF/lib/commons-logging.jar'
Project 'MYAPPUIWeb' is missing required library: 'WebContent/WEB-INF/lib/log4j.jar' 

Am I missing something ?

Thanks,
Joydeep

[Peter Johnson]

Your question has turned into a question about Eclipse. In fact, it is the same question that Naresh has in this post:
http://www.coderanch.com/t/550522/vc/ClassCastException-org-apache-struts-action

What you need to know is how to include a JAR file in your Eclipse build path so that Eclipse can compile your code, but how to prevent Eclipse from packaging that JAR within your web application when you need to deploy it to the application server. Personally, I rarely use Eclipse to build or package my applications (I use Ant or Maven), so I can't tell you how to accomplish this (without first doing some research on this topic myself). Perhaps someone on the Eclipse forum will know. I'll cross-link you post to that forum.

[Joydeep Ghatak]

Thanks a lot Peter for all the help !!!

Well sure putting the jar's in "eclipse build" path and the Application's "WEB-INF/lib" should be seperated.

Thanks again !!

~Joydeep