7 Replies Latest reply on Jan 13, 2015 1:52 PM by hirenshahbridge

Jboss EAP 6.2 connection Pool

hirenshahbridge Jan 13, 2015 10:18 AM

Hello Jboss team

My connection pool for jboss eap 6.2 is not working.I have setup my pool in the standalone.xml and it gets deployed properly.

[org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-2) JBAS010400: Bound data source [java:/Oracle_LPBridge_DS]

standalone.xml configuration is

<datasources>

<datasource jndi-name="java:/Oracle_LPBridge_DS" pool-name="Oracle_LPBridge_DS" enabled="true" use-java-context="true">

<connection-url>jdbc:oracle:thin:@aa.bbb.cc.com:1522:ddd111spc1</connection-url>

<driver>oracle</driver>

<security>

<user-name>cccccccc</user-name>

<password>cccccccc</password>

</security>

<validation>

<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"></valid-connection-checker>

<stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleStaleConnectionChecker"></stale-connection-checker>

<exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"></exception-sorter>

</validation>

</datasource>

<drivers>

<driver name="oracle" module="com.oracle.jdbc">

<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>

<xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>

</driver>

</drivers>

</datasources>

Connection pool is getting deployed.

In my spring applicationContex.xml i used below but it always gives that java:/Oracle_LPBridge_DS not found error.

<bean id="dataSourcelpbridge" class="org.springframework.jndi.JndiObjectFactoryBean">

<property name="jndiName" value="java:/Oracle_LPBridge_DS" />

</bean>

Please suggest what am i doing wrong.

I also tried jboss-web.xml ,web.xml and then added that in applicationContext.xml.That also didnt work.

Thankyou for help.

Message was edited by: hiren hiren

Log.log.zip 3.2 KB

1. Re: Jboss EAP 6.2 connection Pool

rafachies Jan 13, 2015 7:22 AM (in response to hirenshahbridge)

Can you attach here your server.log file? Just to get sure the way datasource is bound, and what is the stacktrace when you get the name not bound. Please, attach the entire file.
Actions
2. Re: Jboss EAP 6.2 connection Pool

hirenshahbridge Jan 13, 2015 10:10 AM (in response to rafachies)

Hi Rafael
The log file is attached in 1st post.Please let me know if any more details to be added.

Thanks
Hiren
Actions
3. Re: Jboss EAP 6.2 connection Pool

rafachies Jan 13, 2015 10:45 AM (in response to hirenshahbridge)

Have you tried to put the full jndi name, with comp and env?
   <property name="jndiName" value="java:comp/env/Oracle_LPBridge_DS" />
In any case, I would suggest you to use the default pattern for JNDI name in EAP, that would be "java:jboss/datasources/Oracle_LPBridge_DS. Put this name in the datasource definition (standalone.xml), and also in your components.xml.

However, as I can see, you are using Spring 3.X. In this case, there is a better option! Replace your:

<bean id="dataSourcelpbridge" class="org.springframework.jndi.JndiObjectFactoryBean">
     <property name="jndiName" value="java:jboss/datasources/Oracle_LPBridge_DS" />
   </bean>

By:

<jee:jndi-lookup id="dataSource" jndi-name="java:jboss/datasources/Oracle_LPBridge_DS"/>

Of course I'm considering you have already changed your datasource definition to use the default pattern java:jboss/datasources/Oracle_LPBridge_DS
Actions
4. Re: Re: Jboss EAP 6.2 connection Pool

hirenshahbridge Jan 13, 2015 12:31 PM (in response to rafachies)

I tried 2 ways as per your recommendation
1st Approach:-
1.) Standalone.xml as
<datasource jndi-name="java:jboss/datasources/Oracle_LPBridge_DS" pool-name="Oracle_LPBridge_DS" enabled="true" use-java-context="true">
    <connection-url>jdbc:oracle:thin:@xx.xx.xx.xx:1233:dsdsds1</connection-url>
    <driver>oracle</driver>
    <security>
      <user-name>xxxx</user-name>
      <password>xxxxxxxxxxx</password>
    </security>
    <validation>
      <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"></valid-connection-checker>
      <stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleStaleConnectionChecker"></stale-connection-checker>
      <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"></exception-sorter>
    </validation>
</datasource>

2.)jboss-web.xml
<jboss-web>
<resource-ref>
<description>DB Connection</description>
<res-ref-name>CARMADS</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<jndi-name>java:jboss/datasources/Oracle_LPBridge_DS</jndi-name>
<res-auth>Container</res-auth>
</resource-ref>
</jboss-web>

3.) web.xml
<resource-ref>
    <res-ref-name>CARMADS</res-ref-name>
    <res-type>javax.sql.DataSource</res-type>
    <res-auth>Container</res-auth>
</resource-ref>

4.)
applicationContext.xml
<jee:jndi-lookup id="dataSourcelpbridge" jndi-name="CARMADS"/>

Exception Logs :-
12:28:05,481 INFO [org.jboss.modules] (main) JBoss Modules version 1.3.0.Final-redhat-2
12:28:05,809 INFO [org.jboss.msc] (main) JBoss MSC version 1.0.4.GA-redhat-1
12:28:05,908 INFO [org.jboss.as] (MSC service thread 1-7) JBAS015899: JBoss EAP 6.2.0.GA (AS 7.3.0.Final-redhat-14) starting
12:28:08,080 INFO [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015003: Found chaplin-boilerplate-master.war in deployment directory. To trigger deployment create a file called chaplin-boilerplate-master.war.dodeploy
12:28:08,081 INFO [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015003: Found bridge.war in deployment directory. To trigger deployment create a file called bridge.war.dodeploy
12:28:08,113 INFO [org.xnio] (MSC service thread 1-2) XNIO Version 3.0.7.GA-redhat-1
12:28:08,115 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS015888: Creating http management service using socket-binding (management-http)
12:28:08,119 INFO [org.xnio.nio] (MSC service thread 1-2) XNIO NIO Implementation Version 3.0.7.GA-redhat-1
12:28:08,127 INFO [org.jboss.remoting] (MSC service thread 1-2) JBoss Remoting version 3.2.18.GA-redhat-1
12:28:08,172 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 29) JBAS010280: Activating Infinispan subsystem.
12:28:08,197 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 37) JBAS011800: Activating Naming Subsystem
12:28:08,234 INFO [org.jboss.as.webservices] (ServerService Thread Pool -- 46) JBAS015537: Activating WebServices Extension
12:28:08,251 INFO [org.jboss.as.security] (ServerService Thread Pool -- 42) JBAS013171: Activating Security Subsystem
12:28:08,275 INFO [org.jboss.as.security] (MSC service thread 1-5) JBAS013170: Current PicketBox version=4.0.19.SP2-redhat-1
12:28:08,327 INFO [org.jboss.as.jsf] (ServerService Thread Pool -- 35) JBAS012605: Activated the following JSF Implementations: [main, 1.2]
12:28:08,371 INFO [org.jboss.as.connector.logging] (MSC service thread 1-5) JBAS010408: Starting JCA Subsystem (IronJacamar 1.0.23.Final-redhat-1)
12:28:08,414 INFO [org.jboss.as.naming] (MSC service thread 1-4) JBAS011802: Starting Naming Service
12:28:08,422 INFO [org.jboss.as.mail.extension] (MSC service thread 1-7) JBAS015400: Bound mail session [java:jboss/mail/Default]
12:28:08,808 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 25) JBAS010403: Deploying JDBC-compliant driver class oracle.jdbc.driver.OracleDriver (version 10.2)
12:28:08,967 INFO [org.apache.coyote.http11] (MSC service thread 1-3) JBWEB003001: Coyote HTTP/1.1 initializing on : http-localhost/127.0.0.1:8080
12:28:08,978 INFO [org.apache.coyote.http11] (MSC service thread 1-3) JBWEB003000: Coyote HTTP/1.1 starting on: http-localhost/127.0.0.1:8080
12:28:09,078 INFO [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015876: Starting deployment of "chaplin-boilerplate-master.war" (runtime-name: "chaplin-boilerplate-master.war")
12:28:09,081 INFO [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015876: Starting deployment of "bridge.war" (runtime-name: "bridge.war")
12:28:09,082 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread 1-1) JBAS015012: Started FileSystemDeploymentService for directory C:\Users\502312813\Documents\LP Bridge\Installables\jboss-eap-6.2.0.1\jboss-eap-6.2\standalone\deployments
12:28:09,130 INFO [org.jboss.as.remoting] (MSC service thread 1-2) JBAS017100: Listening on 127.0.0.1:9999
12:28:09,134 INFO [org.jboss.as.remoting] (MSC service thread 1-4) JBAS017100: Listening on 127.0.0.1:4447
12:28:09,469 INFO [org.jboss.ws.common.management] (MSC service thread 1-5) JBWS022052: Starting JBoss Web Services - Stack CXF Server 4.2.3.Final-redhat-1
12:28:09,491 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-7) JBAS010400: Bound data source [java:jboss/datasources/Oracle_LPBridge_DS]
12:28:15,361 WARN [org.jboss.as.ee] (MSC service thread 1-8) JBAS011006: Not installing optional component org.springframework.web.context.request.async.StandardServletAsyncWebRequest due to an exception (enable DEBUG log level to see the cause)
12:28:15,364 WARN [org.jboss.as.ee] (MSC service thread 1-8) JBAS011006: Not installing optional component org.eclipse.jetty.continuation.Servlet3Continuation$1 due to an exception (enable DEBUG log level to see the cause)
12:28:15,364 WARN [org.jboss.as.ee] (MSC service thread 1-8) JBAS011006: Not installing optional component org.eclipse.jetty.continuation.Servlet3Continuation$2 due to an exception (enable DEBUG log level to see the cause)
12:28:15,437 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-8) JBAS010404: Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1)
12:28:15,495 INFO [org.jboss.web] (ServerService Thread Pool -- 65) JBAS018210: Register web context: /bridge
12:28:15,520 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/bridge]] (ServerService Thread Pool -- 65) No Spring WebApplicationInitializer types detected on classpath
12:28:15,541 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/bridge]] (ServerService Thread Pool -- 65) Initializing Spring root WebApplicationContext
12:28:19,500 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/bridge]] (ServerService Thread Pool -- 65) JBWEB000287: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSourcelpbridge': Invocation of init method failed; nested exception is javax.naming.NameNotFoundException; remaining name 'CARMADS'
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1488) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:524) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:461) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:608) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:389) [spring-web-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:294) [spring-web-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112) [spring-web-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.apache.catalina.core.StandardContext.contextListenerStart(StandardContext.java:3339) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3777) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:156) [jboss-as-web-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]
at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:60) [jboss-as-web-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]
at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:93) [jboss-as-web-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [rt.jar:1.7.0_55]
at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_55]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_55]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_55]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_55]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
Caused by: javax.naming.NameNotFoundException; remaining name 'CARMADS'
at org.eclipse.jetty.jndi.local.localContextRoot.lookup(localContextRoot.java:432) [jetty-jndi-8.1.14.v20131031.jar:8.1.14.v20131031]
at org.eclipse.jetty.jndi.local.localContextRoot.lookup(localContextRoot.java:536) [jetty-jndi-8.1.14.v20131031.jar:8.1.14.v20131031]
at javax.naming.InitialContext.lookup(InitialContext.java:411) [rt.jar:1.7.0_55]
at org.springframework.jndi.JndiTemplate$1.doInContext(JndiTemplate.java:154) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.jndi.JndiTemplate.execute(JndiTemplate.java:87) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:152) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:178) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.jndi.JndiLocatorSupport.lookup(JndiLocatorSupport.java:104) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.jndi.JndiObjectLocator.lookup(JndiObjectLocator.java:105) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.jndi.JndiObjectFactoryBean.lookupWithFallback(JndiObjectFactoryBean.java:201) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.jndi.JndiObjectFactoryBean.afterPropertiesSet(JndiObjectFactoryBean.java:187) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1547) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1485) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
... 23 more

12:28:19,506 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/bridge]] (ServerService Thread Pool -- 65) Set web app root system property: 'webapp.root' = [C:\Users\502312813\Documents\LP Bridge\Installables\jboss-eap-6.2.0.1\jboss-eap-6.2\standalone\deployments\bridge.war\]
12:28:19,508 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/bridge]] (ServerService Thread Pool -- 65) Set web app root system property: 'webapp.root' = [C:\Users\502312813\Documents\LP Bridge\Installables\jboss-eap-6.2.0.1\jboss-eap-6.2\standalone\deployments\bridge.war\]
12:28:19,509 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/bridge]] (ServerService Thread Pool -- 65) Initializing log4j from [classpath:log4j.properties]
12:28:19,597 ERROR [org.apache.catalina.core] (ServerService Thread Pool -- 65) JBWEB001103: Error detected during context /bridge start, will stop it
12:28:19,612 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/bridge]] (ServerService Thread Pool -- 65) Shutting down log4j
12:28:19,613 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/bridge]] (ServerService Thread Pool -- 65) Closing Spring root WebApplicationContext
12:28:19,620 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 65) MSC000001: Failed to start service jboss.web.deployment.default-host./bridge: org.jboss.msc.service.StartException in service jboss.web.deployment.default-host./bridge: org.jboss.msc.service.StartException in anonymous service: JBAS018040: Failed to start context
at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:96)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [rt.jar:1.7.0_55]
at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_55]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_55]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_55]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_55]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
Caused by: org.jboss.msc.service.StartException in anonymous service: JBAS018040: Failed to start context
at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:161)
at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:60)
at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:93)
... 6 more

12:28:20,085 INFO [org.jboss.as.server] (ServerService Thread Pool -- 26) JBAS018559: Deployed "chaplin-boilerplate-master.war" (runtime-name : "chaplin-boilerplate-master.war")
12:28:20,086 INFO [org.jboss.as.server] (ServerService Thread Pool -- 26) JBAS018559: Deployed "bridge.war" (runtime-name : "bridge.war")
12:28:20,087 INFO [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report
JBAS014775:    New missing/unsatisfied dependencies:
      service jboss.naming.context.java.Oracle_LPBridge_DS (missing) dependents: [service jboss.naming.context.java.module.chaplin-boilerplate-master.chaplin-boilerplate-master.env.Oracle_LPBridge_DS]
JBAS014777:   Services which failed to start:      service jboss.web.deployment.default-host./bridge: org.jboss.msc.service.StartException in service jboss.web.deployment.default-host./bridge: org.jboss.msc.service.StartException in anonymous service: JBAS018040: Failed to start context

12:28:20,138 INFO [org.jboss.as] (Controller Boot Thread) JBAS015961: Http management interface listening on http://127.0.0.1:9990/management
12:28:20,139 INFO [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990
12:28:20,139 ERROR [org.jboss.as] (Controller Boot Thread) JBAS015875: JBoss EAP 6.2.0.GA (AS 7.3.0.Final-redhat-14) started (with errors) in 15158ms - Started 432 of 507 services (12 services failed or missing dependencies, 62 services are passive or on-demand)

It didnt works.Second appproach in post below.
Actions
5. Re: Re: Jboss EAP 6.2 connection Pool

hirenshahbridge Jan 13, 2015 12:41 PM (in response to hirenshahbridge)

This is 2nd approach i tried.
1.) Standalone.xml as
<datasource jndi-name="java:jboss/datasources/Oracle_LPBridge_DS" pool-name="Oracle_LPBridge_DS" enabled="true" use-java-context="true">
    <connection-url>jdbc:oracle:thin:@xx.xx.xx.xx:1233:dsdsds1</connection-url>
    <driver>oracle</driver>
    <security>
      <user-name>xxxx</user-name>
      <password>xxxxxxxxxxx</password>
    </security>
    <validation>
      <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"></valid-connection-checker>
      <stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleStaleConnectionChecker"></stale-connection-checker>
      <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"></exception-sorter>
    </validation>
</datasource>

2.)
applicationContext.xml
<jee:jndi-lookup id="dataSourcelpbridge" jndi-name="java:jboss/datasources/Oracle_LPBridge_DS"/>

Removed the web.xml and jboss-web.xml configuration.

Then i got below logs
12:38:44,151 INFO [org.jboss.modules] (main) JBoss Modules version 1.3.0.Final-redhat-2
12:38:44,407 INFO [org.jboss.msc] (main) JBoss MSC version 1.0.4.GA-redhat-1
12:38:44,491 INFO [org.jboss.as] (MSC service thread 1-6) JBAS015899: JBoss EAP 6.2.0.GA (AS 7.3.0.Final-redhat-14) starting
12:38:46,822 INFO [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015003: Found chaplin-boilerplate-master.war in deployment directory. To trigger deployment create a file called chaplin-boilerplate-master.war.dodeploy
12:38:46,823 INFO [org.jboss.as.server.deployment.scanner] (DeploymentScanner-threads - 1) JBAS015003: Found bridge.war in deployment directory. To trigger deployment create a file called bridge.war.dodeploy
12:38:46,864 INFO [org.xnio] (MSC service thread 1-8) XNIO Version 3.0.7.GA-redhat-1
12:38:46,866 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS015888: Creating http management service using socket-binding (management-http)
12:38:46,872 INFO [org.xnio.nio] (MSC service thread 1-8) XNIO NIO Implementation Version 3.0.7.GA-redhat-1
12:38:46,882 INFO [org.jboss.remoting] (MSC service thread 1-8) JBoss Remoting version 3.2.18.GA-redhat-1
12:38:46,965 INFO [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 29) JBAS010280: Activating Infinispan subsystem.
12:38:46,971 INFO [org.jboss.as.webservices] (ServerService Thread Pool -- 46) JBAS015537: Activating WebServices Extension
12:38:46,983 INFO [org.jboss.as.security] (ServerService Thread Pool -- 42) JBAS013171: Activating Security Subsystem
12:38:46,984 INFO [org.jboss.as.jsf] (ServerService Thread Pool -- 35) JBAS012605: Activated the following JSF Implementations: [main, 1.2]
12:38:47,063 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 37) JBAS011800: Activating Naming Subsystem
12:38:47,084 INFO [org.jboss.as.security] (MSC service thread 1-1) JBAS013170: Current PicketBox version=4.0.19.SP2-redhat-1
12:38:47,104 INFO [org.jboss.as.connector.logging] (MSC service thread 1-6) JBAS010408: Starting JCA Subsystem (IronJacamar 1.0.23.Final-redhat-1)
12:38:47,136 INFO [org.jboss.as.naming] (MSC service thread 1-6) JBAS011802: Starting Naming Service
12:38:47,148 INFO [org.jboss.as.mail.extension] (MSC service thread 1-6) JBAS015400: Bound mail session [java:jboss/mail/Default]
12:38:47,301 INFO [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 25) JBAS010403: Deploying JDBC-compliant driver class oracle.jdbc.driver.OracleDriver (version 10.2)
12:38:47,681 INFO [org.jboss.ws.common.management] (MSC service thread 1-3) JBWS022052: Starting JBoss Web Services - Stack CXF Server 4.2.3.Final-redhat-1
12:38:47,824 INFO [org.apache.coyote.http11] (MSC service thread 1-4) JBWEB003001: Coyote HTTP/1.1 initializing on : http-localhost/127.0.0.1:8080
12:38:47,845 INFO [org.apache.coyote.http11] (MSC service thread 1-4) JBWEB003000: Coyote HTTP/1.1 starting on: http-localhost/127.0.0.1:8080
12:38:47,915 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread 1-2) JBAS015012: Started FileSystemDeploymentService for directory C:\Users\502312813\Documents\LP Bridge\Installables\jboss-eap-6.2.0.1\jboss-eap-6.2\standalone\deployments
12:38:47,917 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015876: Starting deployment of "chaplin-boilerplate-master.war" (runtime-name: "chaplin-boilerplate-master.war")
12:38:47,919 INFO [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015876: Starting deployment of "bridge.war" (runtime-name: "bridge.war")
12:38:47,968 INFO [org.jboss.as.remoting] (MSC service thread 1-3) JBAS017100: Listening on 127.0.0.1:4447
12:38:48,032 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-4) JBAS010400: Bound data source [java:jboss/datasources/Oracle_LPBridge_DS]
12:38:48,077 INFO [org.jboss.as.remoting] (MSC service thread 1-2) JBAS017100: Listening on 127.0.0.1:9999
12:38:54,206 WARN [org.jboss.as.ee] (MSC service thread 1-5) JBAS011006: Not installing optional component org.springframework.web.context.request.async.StandardServletAsyncWebRequest due to an exception (enable DEBUG log level to see the cause)
12:38:54,209 WARN [org.jboss.as.ee] (MSC service thread 1-5) JBAS011006: Not installing optional component org.eclipse.jetty.continuation.Servlet3Continuation$1 due to an exception (enable DEBUG log level to see the cause)
12:38:54,210 WARN [org.jboss.as.ee] (MSC service thread 1-5) JBAS011006: Not installing optional component org.eclipse.jetty.continuation.Servlet3Continuation$2 due to an exception (enable DEBUG log level to see the cause)
12:38:54,298 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-5) JBAS010404: Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1)
12:38:54,349 INFO [org.jboss.web] (ServerService Thread Pool -- 62) JBAS018210: Register web context: /bridge
12:38:54,367 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/bridge]] (ServerService Thread Pool -- 62) No Spring WebApplicationInitializer types detected on classpath
12:38:54,388 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/bridge]] (ServerService Thread Pool -- 62) Initializing Spring root WebApplicationContext
12:38:57,635 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/bridge]] (ServerService Thread Pool -- 62) JBWEB000287: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSourcelpbridge': Invocation of init method failed; nested exception is javax.naming.NameNotFoundException; remaining name 'java:jboss/datasources/Oracle_LPBridge_DS'
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1488) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:524) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:461) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:295) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:608) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:932) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:479) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:389) [spring-web-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:294) [spring-web-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:112) [spring-web-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.apache.catalina.core.StandardContext.contextListenerStart(StandardContext.java:3339) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.apache.catalina.core.StandardContext.start(StandardContext.java:3777) [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1]
at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:156) [jboss-as-web-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]
at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:60) [jboss-as-web-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]
at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:93) [jboss-as-web-7.3.0.Final-redhat-14.jar:7.3.0.Final-redhat-14]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [rt.jar:1.7.0_55]
at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_55]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_55]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_55]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_55]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
Caused by: javax.naming.NameNotFoundException; remaining name 'java:jboss/datasources/Oracle_LPBridge_DS'
at org.eclipse.jetty.jndi.local.localContextRoot.lookup(localContextRoot.java:490) [jetty-jndi-8.1.14.v20131031.jar:8.1.14.v20131031]
at org.eclipse.jetty.jndi.local.localContextRoot.lookup(localContextRoot.java:536) [jetty-jndi-8.1.14.v20131031.jar:8.1.14.v20131031]
at javax.naming.InitialContext.lookup(InitialContext.java:411) [rt.jar:1.7.0_55]
at org.springframework.jndi.JndiTemplate$1.doInContext(JndiTemplate.java:154) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.jndi.JndiTemplate.execute(JndiTemplate.java:87) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:152) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.jndi.JndiTemplate.lookup(JndiTemplate.java:178) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.jndi.JndiLocatorSupport.lookup(JndiLocatorSupport.java:95) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.jndi.JndiObjectLocator.lookup(JndiObjectLocator.java:105) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.jndi.JndiObjectFactoryBean.lookupWithFallback(JndiObjectFactoryBean.java:201) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.jndi.JndiObjectFactoryBean.afterPropertiesSet(JndiObjectFactoryBean.java:187) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1547) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1485) [spring-beans-3.2.2.RELEASE.jar:3.2.2.RELEASE]
... 23 more

12:38:57,642 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/bridge]] (ServerService Thread Pool -- 62) Set web app root system property: 'webapp.root' = [C:\Users\502312813\Documents\LP Bridge\Installables\jboss-eap-6.2.0.1\jboss-eap-6.2\standalone\deployments\bridge.war\]
12:38:57,643 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/bridge]] (ServerService Thread Pool -- 62) Set web app root system property: 'webapp.root' = [C:\Users\502312813\Documents\LP Bridge\Installables\jboss-eap-6.2.0.1\jboss-eap-6.2\standalone\deployments\bridge.war\]
12:38:57,644 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/bridge]] (ServerService Thread Pool -- 62) Initializing log4j from [classpath:log4j.properties]
12:38:57,765 ERROR [org.apache.catalina.core] (ServerService Thread Pool -- 62) JBWEB001103: Error detected during context /bridge start, will stop it
12:38:57,783 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/bridge]] (ServerService Thread Pool -- 62) Shutting down log4j
12:38:57,783 INFO [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/bridge]] (ServerService Thread Pool -- 62) Closing Spring root WebApplicationContext
12:38:57,790 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 62) MSC000001: Failed to start service jboss.web.deployment.default-host./bridge: org.jboss.msc.service.StartException in service jboss.web.deployment.default-host./bridge: org.jboss.msc.service.StartException in anonymous service: JBAS018040: Failed to start context
at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:96)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [rt.jar:1.7.0_55]
at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_55]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_55]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_55]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_55]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
Caused by: org.jboss.msc.service.StartException in anonymous service: JBAS018040: Failed to start context
at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:161)
at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:60)
at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:93)
... 6 more

12:38:58,261 INFO [org.jboss.as.server] (ServerService Thread Pool -- 26) JBAS018559: Deployed "chaplin-boilerplate-master.war" (runtime-name : "chaplin-boilerplate-master.war")
12:38:58,262 INFO [org.jboss.as.server] (ServerService Thread Pool -- 26) JBAS018559: Deployed "bridge.war" (runtime-name : "bridge.war")
12:38:58,265 INFO [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report
JBAS014775:    New missing/unsatisfied dependencies:
      service jboss.naming.context.java.Oracle_LPBridge_DS (missing) dependents: [service jboss.naming.context.java.module.chaplin-boilerplate-master.chaplin-boilerplate-master.env.Oracle_LPBridge_DS]
JBAS014777:   Services which failed to start:      service jboss.web.deployment.default-host./bridge: org.jboss.msc.service.StartException in service jboss.web.deployment.default-host./bridge: org.jboss.msc.service.StartException in anonymous service: JBAS018040: Failed to start context

12:38:58,342 INFO [org.jboss.as] (Controller Boot Thread) JBAS015961: Http management interface listening on http://127.0.0.1:9990/management
12:38:58,342 INFO [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990
12:38:58,342 ERROR [org.jboss.as] (Controller Boot Thread) JBAS015875: JBoss EAP 6.2.0.GA (AS 7.3.0.Final-redhat-14) started (with errors) in 14597ms - Started 431 of 506 services (12 services failed or missing dependencies, 62 services are passive or on-demand)

This approach also gave error.Please suggest what do i need to correct.
Actions
6. Re: Re: Jboss EAP 6.2 connection Pool

rafachies Jan 13, 2015 12:59 PM (in response to hirenshahbridge)

Humm.. it's weird, second approach should work ...
However, there is a weird thing in the stacktrace

Caused by: javax.naming.NameNotFoundException; remaining name 'java:jboss/datasources/Oracle_LPBridge_DS'
at org.eclipse.jetty.jndi.local.localContextRoot.lookup(localContextRoot.java:490) [jetty-jndi-8.1.14.v20131031.jar:8.1.14.v20131031]
at org.eclipse.jetty.jndi.local.localContextRoot.lookup(localContextRoot.java:536) [jetty-jndi-8.1.14.v20131031.jar:8.1.14.v20131031]
at javax.naming.InitialContext.lookup(InitialContext.java:411) [rt.jar:1.7.0_55]
at org.springframework.jndi.JndiTemplate$1.doInContext(JndiTemplate.java:154) [spring-context-3.2.2.RELEASE.jar:3.2.2.RELEASE]

Look that the component the complains about the NameNotFound is from jetty-jndi-8.1.14..jar. It should not be the responsible for this lookup, eap modules should do that. Is this lib packaged in your application? Maybe it was lost after a migration from jetty to eap!? Are you able to take off this library from the package and test again?!
Actions
7. Re: Re: Jboss EAP 6.2 connection Pool

hirenshahbridge Jan 13, 2015 1:52 PM (in response to rafachies)

Hi Rafael It started working after i removed the jetty-jdni .jar.I had been on this for many hours - more than 5 days to fix it.your tips are very helpful. Highly appreciated. Thanks Hiren
Actions

Go to original post