JBoss 5.1.0 and Oracle 10g Configuration Issue with new DataSource

[Joydeep Ghatak]

NOTE :: This issue looks similar to http://www.coderanch.com/t/549502/JBoss/JBoss-Oracle-Configuration-new-DataSource, but the application, config info and JBoss server version all are different.

I have a EAR file which runs fine on IBM websphere (6.0 and 6.1), now I want to run it on Jboss 5.1.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,

1. Created the oracle-ds.xml with DB and application specific parameters.
2. Deployed the oracle-ds.xml in C:\jboss-5.1.0.GA_MYAPP\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-5.1.0.GA_MYAPP\common\lib
5. Created and kept jboss-web.xml in <project_home>/src/web/WEB-INF

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

..................

16:25:42,206 INFO  [QueueService] Queue[/queue/ExpiryQueue] started, fullSize=200000, pageSize=2000, downCacheSize=2000
16:25:43,191 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
16:25:43,456 INFO  [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=MY_ds' to JNDI name 'java:MY_ds'
16:25:46,097 INFO  [JBossASKernel] Created KernelDeployment for: profileservice-secured.jar
.................

16:25:54,362 INFO  [TomcatDeployment] deploy, ctxPath=/admin-console
16:25:54,971 INFO  [config] Initializing Mojarra (1.2_12-b01-FCS) for context '/admin-console'
16:26:08,346 INFO  [TomcatDeployment] deploy, ctxPath=/
16:26:08,971 INFO  [TomcatDeployment] deploy, ctxPath=/jmx-console
16:26:09,252 INFO  [Http11Protocol] Starting Coyote HTTP/1.1 on http-127.0.0.1-8080
16:26:09,284 INFO  [AjpProtocol] Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009
16:26:09,346 INFO  [ServerImpl] JBoss (Microcontainer) [5.1.0.GA (build: SVNTag=JBoss_5_1_0_GA date=200905221053)] Started in 3m:24s:573ms
.................

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

2.1
.................
.................
**16:31:32,838 INFO  [TomcatDeployment] deploy, ctxPath=/APPNAMEUI
16:31:32,994 ERROR [AbstractKernelController] Error installing to Start: name=jboss.web.deployment:war=/APPNAMEUI state=Create mode=Manual requiredState=Installed
org.jboss.deployers.spi.DeploymentException: URL file:/C:/jboss-5.1.0.GA_MYAPP/server/default/tmp/1415c6r-wyjk2i-grjlvwgw-1-grjm6tlb-9q/APPNAMEUIWeb.war/ deployment failed
	at org.jboss.deployers.spi.DeploymentException.rethrowAsDeploymentException(DeploymentException.java:49)
	at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:316)
................
2.2 
.................
.................
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
	at java.lang.Thread.run(Thread.java:595)
Caused by: LifecycleException:  Error initializaing :  javax.management.ReflectionException: Cannot find method addChild with this signature
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4150)
	at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:310)
	... 62 more
2.3 
.................
.................
16:31:33,728 ERROR [AbstractKernelController] Error installing to Real: name=vfszip:/C:/jboss-5.1.0.GA_MYAPP/server/default/deploy/APPNAMEUI.ear/ state=PreReal mode=Manual requiredState=Real
org.jboss.deployers.spi.DeploymentException: URL file:/C:/jboss-5.1.0.GA_MYAPP/server/default/tmp/1415c6r-wyjk2i-grjlvwgw-1-grjm6tlb-9q/APPNAMEUIWeb.war/ deployment failed
	at org.jboss.deployers.spi.DeploymentException.rethrowAsDeploymentException(DeploymentException.java:49)
	at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:316)
	at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(TomcatDeployment.java:142)
	at org.jboss.web.deployers.AbstractWarDeployment.start(AbstractWarDeployment.java:461)
2.4
.................
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
	at java.lang.Thread.run(Thread.java:595)
Caused by: LifecycleException:  Error initializaing :  javax.management.ReflectionException: Cannot find method addChild with this signature
	at org.apache.catalina.core.StandardContext.start(StandardContext.java:4150)
	at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:310)
	... 62 more
16:31:33,791 WARN  [HDScanner] Failed to process changes
org.jboss.deployers.client.spi.IncompleteDeploymentException: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):

*** DEPLOYMENTS IN ERROR: Name -> Error

vfszip:/C:/jboss-5.1.0.GA_MYAPP/server/default/deploy/APPNAMEUI.ear/ -> org.jboss.deployers.spi.DeploymentException: URL file:/C:/jboss-5.1.0.GA_MYAPP/server/default/tmp/1415c6r-wyjk2i-grjlvwgw-1-grjm6tlb-9q/APPNAMEUIWeb.war/ deployment failed

DEPLOYMENTS IN ERROR:
  Deployment "vfszip:/C:/jboss-5.1.0.GA_MYAPP/server/default/deploy/APPNAMEUI.ear/" is in error due to the following reason(s): LifecycleException:  Error initializaing :  javax.management.ReflectionException: Cannot find method addChild with this signature

	at org.jboss.deployers.plugins.deployers.DeployersImpl.checkComplete(DeployersImpl.java:993)
	at org.jboss.deployers.plugins.deployers.DeployersImpl.checkComplete(DeployersImpl.java:939)
	at org.jboss.deployers.plugins.main.MainDeployerImpl.checkComplete(MainDeployerImpl.java:873)
	at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.checkComplete(MainDeployerAdapter.java:128)
	at org.jboss.system.server.profileservice.hotdeploy.HDScanner.scan(HDScanner.java:369)
	at org.jboss.system.server.profileservice.hotdeploy.HDScanner.run(HDScanner.java:255)
................

Need some insight of the error please.

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

<?xml version="1.0" encoding="UTF-8"?>
<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>

2. web.xml of the application is as follows,

.................
	<resource-ref id="ResourceRef_1188483814926">
		<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>

3. jboss-web.xml

<jboss-web>
   <resource-ref>
      <res-ref-name>jdbc/MY_ds</res-ref-name>
      <jndi-name>java:/jdbc/MY_ds</jndi-name>
   </resource-ref>
 </jboss-web>

Thanks,
Joydeep

[Jaikiran Pai]

Are you packaging any JBoss specific jars or apache catalina jars within your application? If yes, remove those jars from the application packaging.

[Joydeep Ghatak]

Thanks Jaikiran,

Well I have double checked, the project contains some apache.commons packages,apache.struts, xalan and xerces related jars only, but nothing related to JBoss and apache catalina jars.

Thanks for the help !!!

Thanks,
Joydeep

[Joydeep Ghatak]

Also when I am trying to access the application in browser,

http://localhost:<port>/MYAPPUI/jsp/login.jsp, it is giving HTTP 404 error and the console exception, as mentioned earlier.

[Joydeep Ghatak]

Hi all,

Any suggestion on the above mentioned error message please ?

thanks,
Joydeep

[Jaikiran Pai]

http://community.jboss.org/message/7214

[Joydeep Ghatak]

Thanks Jaikiran,

I am working on to resolve the issue as per the given link.
Thanks for all the help !!!

~Joydeep

[Joydeep Ghatak]

Hi Jaikiran,

Thanks for the help !!!
Well I tried my bets to delete all the JBoss specific jars or apache catalina jars from my WEB-INF/lib and it seems I am able to delete the jar files, as now the application .ear file is getting deployed in JBoss successfully (no exception in UI and/or in log file).
But when I tried to log into the application it was throwing the following exception.

Note :: The same configuration file is working fine in WebSpehe 6.0 and 6.1

UI Exception :: 
================
HTTP Status 500 - 

--------------------------------------------------------------------------------

type Exception report

message 

description The server encountered an internal error () that prevented it from fulfilling this request.

exception 

java.lang.IllegalArgumentException: Path jsp/jobStatus.jsp does not start with a "/" character
	org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1062)
	org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1069)
	org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)


note The full stack trace of the root cause is available in the JBoss Web/2.1.3.GA logs.

Server Error ::
===============

2011-08-26 15:34:00,278 INFO  [STDOUT] (http-127.0.0.1-8080-2) 15:34:00,278 INFO  [PropertyMessageResources] Initializing, 
config='org.apache.struts.actions.LocalStrings', returnNull=true
2011-08-26 15:34:00,371 INFO  [STDOUT] (http-127.0.0.1-8080-2) 15:34:00,371 INFO  [PropertyMessageResources] Initializing, 
config='org.apache.struts.actions.LocalStrings', returnNull=true
2011-08-26 15:34:01,184 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/MYAPPUI].[action]] (http-127.0.0.1-8080-2) Servlet.service() 

for servlet action threw exception
java.lang.IllegalArgumentException: Path jsp/jobStatus.jsp does not start with a "/" character
	at org.apache.catalina.core.ApplicationContext.getRequestDispatcher(ApplicationContext.java:370)
	at org.apache.catalina.core.ApplicationContextFacade.getRequestDispatcher(ApplicationContextFacade.java:196)
	at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1062)
	at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:455)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:279)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)

[Joydeep Ghatak]

Hi Jaikiran,

Thanks again for all the help.
BTW, the current problem has been resolved by updating the struts-config.xml of the project.

It seems that Jboss and Websphere considers, relative path(s) differently and hence here(In Jboss Domain) I had to modify the Action Mappings section of the
struts-config.xml as follows,


<action
path="/statusPage"
type="Action class for the statusPage"
parameter = "method"
name = "statusPageForm"
input= "jsp/statusPage.jsp">

<forward
name="statusPage"
path="/jsp/statusPage.jsp" redirect="false"/>

Thanks again !!!


~Thanks
Joydeep