7:37 p.m.
Problem with JBoss 7.1.0 and oracle datasource configuration
------------------------------------------------------------
Key: AS7-3141
URL: https://issues.jboss.org/browse/AS7-3141
Project: Application Server 7
Issue Type: Bug
Environment: Centos 5.6, Oracle 11g JBoss 7.1.0.CR1b
Reporter: Peter Penzov
I cannot configure JBoss 7.1.0 to work with Oracle datasource. I used web manager to
create the datasource configuration. The problem occurs when I make a call from a managed
bean to access database resources.
This is the log file:
[root@Testserver bin]#
[root@Testserver bin]# ./standalone.sh
=========================================================================
JBoss Bootstrap Environment
JBOSS_HOME: /opt/jboss-as-7.1.0.CR1b
JAVA: /opt/jdk1.7.0_01/bin/java
JAVA_OPTS: -server -Xms64m -Xmx512m -XX:MaxPermSize=256m -Djava.net.preferIPv4Stack=true
-Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000
-Dsun.rmi.dgc.server.gcInterval=3600000 -Djboss.modules.system.pkgs=org.jboss.byteman
-Djava.awt.headless=true
=========================================================================
16:07:10,344 INFO [org.jboss.modules] JBoss Modules version 1.1.0.CR6
16:07:10,707 INFO [org.jboss.msc] JBoss MSC version 1.0.1.GA
16:07:10,766 INFO [org.jboss.as] JBoss AS 7.1.0.CR1b "Flux Capacitor" starting
16:07:12,100 INFO [org.jboss.as] Creating http management service using socket-binding
(management-http)
16:07:12,101 INFO [org.xnio] XNIO Version 3.0.0.CR7
16:07:12,146 INFO [org.xnio.nio] XNIO NIO Implementation Version 3.0.0.CR7
16:07:12,157 INFO [org.jboss.remoting] JBoss Remoting version 3.2.0.CR8
16:07:12,207 INFO [org.jboss.as.logging] JBAS011502: Removing bootstrap log handlers
16:07:12,217 INFO [org.jboss.as.clustering] (ServerService Thread Pool -- 30) JBAS010300:
Activating Infinispan subsystem.
16:07:12,330 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 38) JBAS011800:
Activating Naming Subsystem
16:07:12,336 INFO [org.jboss.as.connector] (MSC service thread 1-1) JBAS010408: Starting
JCA Subsystem (JBoss IronJacamar 1.0.6.Final)
16:07:12,356 INFO [org.jboss.as.naming] (MSC service thread 1-3) JBAS011802: Starting
Naming Service
16:07:12,357 INFO [org.jboss.as.jaxr] (MSC service thread 1-3) Binding JAXR
ConnectionFactory: java:jboss/jaxr/ConnectionFactory
16:07:12,362 INFO [org.jboss.as.osgi] (ServerService Thread Pool -- 39) JBAS011910:
Activating OSGi Subsystem
16:07:12,412 INFO [org.jboss.as.mail.extension] (MSC service thread 1-1) JBAS015400:
Bound mail session [java:jboss/mail/Default]
16:07:12,504 INFO [org.jboss.as.security] (ServerService Thread Pool -- 44) Activating
Security Subsystem
16:07:12,507 INFO [org.jboss.as.remoting] (MSC service thread 1-1) Listening on
/10.15.203.13:4447
16:07:12,548 INFO [org.jboss.as.webservices] (ServerService Thread Pool -- 48)
JBAS015537: Activating WebServices Extension
16:07:12,616 INFO [org.jboss.ws.common.management.AbstractServerConfig] (MSC service
thread 1-3) JBoss Web Services - Stack CXF Server 4.0.0.GA
16:07:12,632 INFO [org.jboss.as.security] (MSC service thread 1-4) Picketbox
version=4.0.6.Beta2
16:07:12,983 INFO [org.apache.coyote.http11.Http11AprProtocol] (MSC service thread 1-1)
Starting Coyote HTTP/1.1 on http--10.15.203.13-8080
16:07:13,634 INFO [org.jboss.as.remoting] (MSC service thread 1-4) Listening on
/10.15.203.13:9999
16:07:13,680 INFO [org.jboss.as.server.deployment] (MSC service thread 1-4) Starting
deployment of "SR_57-ear-1.0-SNAPSHOT.ear"
16:07:13,729 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread 1-3)
JBAS015012: Started FileSystemDeploymentService for directory
/opt/jboss-as-7.1.0.CR1b/standalone/deployments
16:07:13,824 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) Starting
deployment of "SR_57-ejb-1.0-SNAPSHOT.jar"
16:07:13,825 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) Starting
deployment of "SR_57-web-1.0-SNAPSHOT.war"
16:07:14,257 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed
"SR_57-ear-1.0-SNAPSHOT.ear"
16:07:14,355 INFO [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service
status report
JBAS014775: New missing/unsatisfied dependencies:
service jboss.naming.context.java.Oracle (missing) dependents: [service
jboss.deployment.subunit."SR_57-ear-1.0-SNAPSHOT.ear"."SR_57-web-1.0-SNAPSHOT.war".component."managed-bean.com.SR_57.userCheck".START]
16:07:14,398 ERROR [org.jboss.as] (Controller Boot Thread) JBoss AS 7.1.0.CR1b "Flux
Capacitor" started (with errors) in 4303ms - Started 190 of 268 services (3 services
failed or missing dependencies, 74 services are passive or on-demand)
16:07:14,403 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) Starting
deployment of "ojdbc6.jar"
16:07:14,776 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-3)
JBAS010403: Deploying JDBC-compliant driver class oracle.jdbc.OracleDriver (version 11.2)
16:07:14,827 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559:
Deployed "ojdbc6.jar"
16:08:36,979 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread
1-2) JBAS010400: Bound data source [java:/Oracle]
16:08:37,060 INFO [javax.enterprise.resource.webcontainer.jsf.config] (MSC service thread
1-2) Initializing Mojarra 2.1.5 (SNAPSHOT 20111202) for context '/SR_57-web'
16:08:37,935 INFO [org.hibernate.validator.util.Version] (MSC service thread 1-2)
Hibernate Validator 4.2.0.Final
16:08:38,867 INFO [javax.enterprise.resource.webcontainer.jsf.config] (MSC service thread
1-2) Monitoring jndi:/default-host/SR_57-web/WEB-INF/faces-config.xml for modifications
16:08:38,942 INFO [org.jboss.web] (MSC service thread 1-2) registering web context:
/SR_57-web
16:08:38,954 INFO [org.jboss.as.controller] (HttpManagementService-threads - 1)
JBAS014774: Service status report
JBAS014776: Newly corrected services:
service jboss.naming.context.java.Oracle (no longer required)
16:08:47,288 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool]
(HttpManagementService-threads - 2) IJ000604: Throwable while attempting to get a new
connection: null: javax.resource.ResourceException: Could not create connection
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277)
[ironjacamar-jdbc-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235)
[ironjacamar-jdbc-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:736)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:341)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:396)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:361)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.internalTestConnection(AbstractPool.java:622)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.strategy.OnePool.testConnection(OnePool.java:88)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.as.connector.pool.PoolOperations$TestConnectionInPool.invokeCommandOn(PoolOperations.java:114)
[jboss-as-connector-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.connector.pool.PoolOperations$1.execute(PoolOperations.java:53)
[jboss-as-connector-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:359)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:254)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:190)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.connector.pool.PoolOperations.execute(PoolOperations.java:67)
[jboss-as-connector-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:359)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:254)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:190)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.ModelControllerImpl$DefaultPrepareStepHandler.execute(ModelControllerImpl.java:432)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:359)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:254)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:190)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.controller.ModelControllerImpl.execute(ModelControllerImpl.java:119)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.controller.ModelControllerImpl$1.execute(ModelControllerImpl.java:302)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.controller.ModelControllerImpl$1.execute(ModelControllerImpl.java:292)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.domain.http.server.DomainApiHandler.processRequest(DomainApiHandler.java:273)
at org.jboss.as.domain.http.server.DomainApiHandler.handle(DomainApiHandler.java:192)
at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:78)
at org.jboss.sun.net.httpserver.AuthFilter.doFilter(AuthFilter.java:69)
at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:81)
at
org.jboss.sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(ServerImpl.java:710)
at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:78)
at
org.jboss.as.domain.http.server.RealmReadinessFilter.doFilter(RealmReadinessFilter.java:54)
at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:81)
at org.jboss.sun.net.httpserver.ServerImpl$Exchange.run(ServerImpl.java:682)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
[:1.7.0_01]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
[:1.7.0_01]
at java.lang.Thread.run(Thread.java:722) [:1.7.0_01]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
[jboss-threads-2.0.0.GA.jar:2.0.0.GA]
Caused by: java.sql.SQLRecoverableException: IO Error: Invalid number format for port
number
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249)
[ironjacamar-jdbc-1.0.6.Final.jar:1.0.6.Final]
... 37 more
Caused by: oracle.net.ns.NetException: Invalid number format for port number
at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:187)
at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:133)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:416)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
... 42 more
16:09:25,702 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool]
(http--10.15.203.13-8080-2) IJ000604: Throwable while attempting to get a new connection:
null: javax.resource.ResourceException: Could not create connection
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235)
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:736)
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:341)
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:396)
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:361)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:327)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:302)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:444)
at
org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129)
at com.SR_57.userCheck.CheckUserDB(userCheck.java:98) [classes:]
at com.SR_57.userCheck.userCompare(userCheck.java:200) [classes:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.7.0_01]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
[:1.7.0_01]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[:1.7.0_01]
at java.lang.reflect.Method.invoke(Method.java:601) [:1.7.0_01]
at org.apache.el.parser.AstValue.invoke(AstValue.java:262) [jbossweb-7.0.7.Final.jar:]
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278)
[jbossweb-7.0.7.Final.jar:]
at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at javax.faces.component.UICommand.broadcast(UICommand.java:315)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
[jbossweb-7.0.7.Final.jar:]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
[jbossweb-7.0.7.Final.jar:]
at
org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:151)
[jboss-as-web-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)
[jbossweb-7.0.7.Final.jar:]
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:897)
[jbossweb-7.0.7.Final.jar:]
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:626)
[jbossweb-7.0.7.Final.jar:]
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:2033)
[jbossweb-7.0.7.Final.jar:]
at java.lang.Thread.run(Thread.java:722) [:1.7.0_01]
Caused by: java.sql.SQLRecoverableException: IO Error: Invalid number format for port
number
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249)
... 40 more
Caused by: oracle.net.ns.NetException: Invalid number format for port number
at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:187)
at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:133)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:416)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
... 45 more
16:09:25,709 WARNING [javax.enterprise.resource.webcontainer.jsf.lifecycle]
(http--10.15.203.13-8080-2) #{loginController.userCompare}: java.sql.SQLException:
javax.resource.ResourceException: IJ000453: Unable to get managed connection for
java:/Oracle: javax.faces.FacesException: #{loginController.userCompare}:
java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed
connection for java:/Oracle
at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:118)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at javax.faces.component.UICommand.broadcast(UICommand.java:315)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
[jbossweb-7.0.7.Final.jar:]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
[jbossweb-7.0.7.Final.jar:]
at
org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:151)
[jboss-as-web-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)
[jbossweb-7.0.7.Final.jar:]
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:897)
[jbossweb-7.0.7.Final.jar:]
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:626)
[jbossweb-7.0.7.Final.jar:]
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:2033)
[jbossweb-7.0.7.Final.jar:]
at java.lang.Thread.run(Thread.java:722) [:1.7.0_01]
Caused by: javax.faces.el.EvaluationException: java.sql.SQLException:
javax.resource.ResourceException: IJ000453: Unable to get managed connection for
java:/Oracle
at
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
... 20 more
Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to
get managed connection for java:/Oracle
at
org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:137)
at com.SR_57.userCheck.CheckUserDB(userCheck.java:98) [classes:]
at com.SR_57.userCheck.userCompare(userCheck.java:200) [classes:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.7.0_01]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
[:1.7.0_01]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[:1.7.0_01]
at java.lang.reflect.Method.invoke(Method.java:601) [:1.7.0_01]
at org.apache.el.parser.AstValue.invoke(AstValue.java:262) [jbossweb-7.0.7.Final.jar:]
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278)
[jbossweb-7.0.7.Final.jar:]
at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
... 21 more
Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection
for java:/Oracle
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:370)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:302)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:444)
at
org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129)
... 31 more
Caused by: javax.resource.ResourceException: IJ000658: Unexpected throwable while trying
to create a connection: null
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:369)
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:396)
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:361)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:327)
... 34 more
Caused by: javax.resource.ResourceException: Could not create connection
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235)
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:736)
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:341)
... 37 more
Caused by: java.sql.SQLRecoverableException: IO Error: Invalid number format for port
number
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249)
... 40 more
Caused by: oracle.net.ns.NetException: Invalid number format for port number
at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:187)
at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:133)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:416)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
... 45 more
And when I try to access the JSF package this error appears:
java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed
connection for java:/Oracle
Can you help me to fix the problem?
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
8:30 p.m.
[
https://issues.jboss.org/browse/AS7-3141?page=com.atlassian.jira.plugin.s...
]
Peter Penzov commented on AS7-3141:
-----------------------------------
Problem solved!
I edited the ojdbc6.jar file in deployment directory to _ojdbc6.jar and it worked! Very
strange.
Problem with JBoss 7.1.0 and oracle datasource configuration
------------------------------------------------------------
Key: AS7-3141
URL: https://issues.jboss.org/browse/AS7-3141
Project: Application Server 7
Issue Type: Bug
Environment: Centos 5.6, Oracle 11g JBoss 7.1.0.CR1b
Reporter: Peter Penzov
I cannot configure JBoss 7.1.0 to work with Oracle datasource. I used web manager to
create the datasource configuration. The problem occurs when I make a call from a managed
bean to access database resources.
This is the log file:
[root@Testserver bin]#
[root@Testserver bin]# ./standalone.sh
=========================================================================
JBoss Bootstrap Environment
JBOSS_HOME: /opt/jboss-as-7.1.0.CR1b
JAVA: /opt/jdk1.7.0_01/bin/java
JAVA_OPTS: -server -Xms64m -Xmx512m -XX:MaxPermSize=256m
-Djava.net.preferIPv4Stack=true -Dorg.jboss.resolver.warning=true
-Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000
-Djboss.modules.system.pkgs=org.jboss.byteman -Djava.awt.headless=true
=========================================================================
16:07:10,344 INFO [org.jboss.modules] JBoss Modules version 1.1.0.CR6
16:07:10,707 INFO [org.jboss.msc] JBoss MSC version 1.0.1.GA
16:07:10,766 INFO [org.jboss.as] JBoss AS 7.1.0.CR1b "Flux Capacitor"
starting
16:07:12,100 INFO [org.jboss.as] Creating http management service using socket-binding
(management-http)
16:07:12,101 INFO [org.xnio] XNIO Version 3.0.0.CR7
16:07:12,146 INFO [org.xnio.nio] XNIO NIO Implementation Version 3.0.0.CR7
16:07:12,157 INFO [org.jboss.remoting] JBoss Remoting version 3.2.0.CR8
16:07:12,207 INFO [org.jboss.as.logging] JBAS011502: Removing bootstrap log handlers
16:07:12,217 INFO [org.jboss.as.clustering] (ServerService Thread Pool -- 30)
JBAS010300: Activating Infinispan subsystem.
16:07:12,330 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 38) JBAS011800:
Activating Naming Subsystem
16:07:12,336 INFO [org.jboss.as.connector] (MSC service thread 1-1) JBAS010408: Starting
JCA Subsystem (JBoss IronJacamar 1.0.6.Final)
16:07:12,356 INFO [org.jboss.as.naming] (MSC service thread 1-3) JBAS011802: Starting
Naming Service
16:07:12,357 INFO [org.jboss.as.jaxr] (MSC service thread 1-3) Binding JAXR
ConnectionFactory: java:jboss/jaxr/ConnectionFactory
16:07:12,362 INFO [org.jboss.as.osgi] (ServerService Thread Pool -- 39) JBAS011910:
Activating OSGi Subsystem
16:07:12,412 INFO [org.jboss.as.mail.extension] (MSC service thread 1-1) JBAS015400:
Bound mail session [java:jboss/mail/Default]
16:07:12,504 INFO [org.jboss.as.security] (ServerService Thread Pool -- 44) Activating
Security Subsystem
16:07:12,507 INFO [org.jboss.as.remoting] (MSC service thread 1-1) Listening on
/10.15.203.13:4447
16:07:12,548 INFO [org.jboss.as.webservices] (ServerService Thread Pool -- 48)
JBAS015537: Activating WebServices Extension
16:07:12,616 INFO [org.jboss.ws.common.management.AbstractServerConfig] (MSC service
thread 1-3) JBoss Web Services - Stack CXF Server 4.0.0.GA
16:07:12,632 INFO [org.jboss.as.security] (MSC service thread 1-4) Picketbox
version=4.0.6.Beta2
16:07:12,983 INFO [org.apache.coyote.http11.Http11AprProtocol] (MSC service thread 1-1)
Starting Coyote HTTP/1.1 on http--10.15.203.13-8080
16:07:13,634 INFO [org.jboss.as.remoting] (MSC service thread 1-4) Listening on
/10.15.203.13:9999
16:07:13,680 INFO [org.jboss.as.server.deployment] (MSC service thread 1-4) Starting
deployment of "SR_57-ear-1.0-SNAPSHOT.ear"
16:07:13,729 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread 1-3)
JBAS015012: Started FileSystemDeploymentService for directory
/opt/jboss-as-7.1.0.CR1b/standalone/deployments
16:07:13,824 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) Starting
deployment of "SR_57-ejb-1.0-SNAPSHOT.jar"
16:07:13,825 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) Starting
deployment of "SR_57-web-1.0-SNAPSHOT.war"
16:07:14,257 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed
"SR_57-ear-1.0-SNAPSHOT.ear"
16:07:14,355 INFO [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service
status report
JBAS014775: New missing/unsatisfied dependencies:
service jboss.naming.context.java.Oracle (missing) dependents: [service
jboss.deployment.subunit."SR_57-ear-1.0-SNAPSHOT.ear"."SR_57-web-1.0-SNAPSHOT.war".component."managed-bean.com.SR_57.userCheck".START]
16:07:14,398 ERROR [org.jboss.as] (Controller Boot Thread) JBoss AS 7.1.0.CR1b "Flux
Capacitor" started (with errors) in 4303ms - Started 190 of 268 services (3 services
failed or missing dependencies, 74 services are passive or on-demand)
16:07:14,403 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) Starting
deployment of "ojdbc6.jar"
16:07:14,776 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-3)
JBAS010403: Deploying JDBC-compliant driver class oracle.jdbc.OracleDriver (version 11.2)
16:07:14,827 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559:
Deployed "ojdbc6.jar"
16:08:36,979 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread
1-2) JBAS010400: Bound data source [java:/Oracle]
16:08:37,060 INFO [javax.enterprise.resource.webcontainer.jsf.config] (MSC service
thread 1-2) Initializing Mojarra 2.1.5 (SNAPSHOT 20111202) for context
'/SR_57-web'
16:08:37,935 INFO [org.hibernate.validator.util.Version] (MSC service thread 1-2)
Hibernate Validator 4.2.0.Final
16:08:38,867 INFO [javax.enterprise.resource.webcontainer.jsf.config] (MSC service
thread 1-2) Monitoring jndi:/default-host/SR_57-web/WEB-INF/faces-config.xml for
modifications
16:08:38,942 INFO [org.jboss.web] (MSC service thread 1-2) registering web context:
/SR_57-web
16:08:38,954 INFO [org.jboss.as.controller] (HttpManagementService-threads - 1)
JBAS014774: Service status report
JBAS014776: Newly corrected services:
service jboss.naming.context.java.Oracle (no longer required)
16:08:47,288 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool]
(HttpManagementService-threads - 2) IJ000604: Throwable while attempting to get a new
connection: null: javax.resource.ResourceException: Could not create connection
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277)
[ironjacamar-jdbc-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235)
[ironjacamar-jdbc-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:736)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:341)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:396)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:361)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.internalTestConnection(AbstractPool.java:622)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.strategy.OnePool.testConnection(OnePool.java:88)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.as.connector.pool.PoolOperations$TestConnectionInPool.invokeCommandOn(PoolOperations.java:114)
[jboss-as-connector-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.connector.pool.PoolOperations$1.execute(PoolOperations.java:53)
[jboss-as-connector-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:359)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:254)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:190)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.connector.pool.PoolOperations.execute(PoolOperations.java:67)
[jboss-as-connector-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:359)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:254)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:190)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.ModelControllerImpl$DefaultPrepareStepHandler.execute(ModelControllerImpl.java:432)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:359)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:254)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:190)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.controller.ModelControllerImpl.execute(ModelControllerImpl.java:119)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.controller.ModelControllerImpl$1.execute(ModelControllerImpl.java:302)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.controller.ModelControllerImpl$1.execute(ModelControllerImpl.java:292)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.domain.http.server.DomainApiHandler.processRequest(DomainApiHandler.java:273)
at org.jboss.as.domain.http.server.DomainApiHandler.handle(DomainApiHandler.java:192)
at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:78)
at org.jboss.sun.net.httpserver.AuthFilter.doFilter(AuthFilter.java:69)
at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:81)
at
org.jboss.sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(ServerImpl.java:710)
at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:78)
at
org.jboss.as.domain.http.server.RealmReadinessFilter.doFilter(RealmReadinessFilter.java:54)
at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:81)
at org.jboss.sun.net.httpserver.ServerImpl$Exchange.run(ServerImpl.java:682)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
[:1.7.0_01]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
[:1.7.0_01]
at java.lang.Thread.run(Thread.java:722) [:1.7.0_01]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
[jboss-threads-2.0.0.GA.jar:2.0.0.GA]
Caused by: java.sql.SQLRecoverableException: IO Error: Invalid number format for port
number
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249)
[ironjacamar-jdbc-1.0.6.Final.jar:1.0.6.Final]
... 37 more
Caused by: oracle.net.ns.NetException: Invalid number format for port number
at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:187)
at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:133)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:416)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
... 42 more
16:09:25,702 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool]
(http--10.15.203.13-8080-2) IJ000604: Throwable while attempting to get a new connection:
null: javax.resource.ResourceException: Could not create connection
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235)
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:736)
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:341)
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:396)
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:361)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:327)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:302)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:444)
at
org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129)
at com.SR_57.userCheck.CheckUserDB(userCheck.java:98) [classes:]
at com.SR_57.userCheck.userCompare(userCheck.java:200) [classes:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.7.0_01]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
[:1.7.0_01]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[:1.7.0_01]
at java.lang.reflect.Method.invoke(Method.java:601) [:1.7.0_01]
at org.apache.el.parser.AstValue.invoke(AstValue.java:262) [jbossweb-7.0.7.Final.jar:]
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278)
[jbossweb-7.0.7.Final.jar:]
at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at javax.faces.component.UICommand.broadcast(UICommand.java:315)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
[jbossweb-7.0.7.Final.jar:]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
[jbossweb-7.0.7.Final.jar:]
at
org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:151)
[jboss-as-web-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)
[jbossweb-7.0.7.Final.jar:]
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:897)
[jbossweb-7.0.7.Final.jar:]
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:626)
[jbossweb-7.0.7.Final.jar:]
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:2033)
[jbossweb-7.0.7.Final.jar:]
at java.lang.Thread.run(Thread.java:722) [:1.7.0_01]
Caused by: java.sql.SQLRecoverableException: IO Error: Invalid number format for port
number
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249)
... 40 more
Caused by: oracle.net.ns.NetException: Invalid number format for port number
at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:187)
at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:133)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:416)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
... 45 more
16:09:25,709 WARNING [javax.enterprise.resource.webcontainer.jsf.lifecycle]
(http--10.15.203.13-8080-2) #{loginController.userCompare}: java.sql.SQLException:
javax.resource.ResourceException: IJ000453: Unable to get managed connection for
java:/Oracle: javax.faces.FacesException: #{loginController.userCompare}:
java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed
connection for java:/Oracle
at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:118)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at javax.faces.component.UICommand.broadcast(UICommand.java:315)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
[jbossweb-7.0.7.Final.jar:]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
[jbossweb-7.0.7.Final.jar:]
at
org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:151)
[jboss-as-web-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)
[jbossweb-7.0.7.Final.jar:]
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:897)
[jbossweb-7.0.7.Final.jar:]
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:626)
[jbossweb-7.0.7.Final.jar:]
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:2033)
[jbossweb-7.0.7.Final.jar:]
at java.lang.Thread.run(Thread.java:722) [:1.7.0_01]
Caused by: javax.faces.el.EvaluationException: java.sql.SQLException:
javax.resource.ResourceException: IJ000453: Unable to get managed connection for
java:/Oracle
at
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
... 20 more
Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to
get managed connection for java:/Oracle
at
org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:137)
at com.SR_57.userCheck.CheckUserDB(userCheck.java:98) [classes:]
at com.SR_57.userCheck.userCompare(userCheck.java:200) [classes:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.7.0_01]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
[:1.7.0_01]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[:1.7.0_01]
at java.lang.reflect.Method.invoke(Method.java:601) [:1.7.0_01]
at org.apache.el.parser.AstValue.invoke(AstValue.java:262) [jbossweb-7.0.7.Final.jar:]
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278)
[jbossweb-7.0.7.Final.jar:]
at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
... 21 more
Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection
for java:/Oracle
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:370)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:302)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:444)
at
org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129)
... 31 more
Caused by: javax.resource.ResourceException: IJ000658: Unexpected throwable while trying
to create a connection: null
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:369)
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:396)
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:361)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:327)
... 34 more
Caused by: javax.resource.ResourceException: Could not create connection
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235)
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:736)
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:341)
... 37 more
Caused by: java.sql.SQLRecoverableException: IO Error: Invalid number format for port
number
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249)
... 40 more
Caused by: oracle.net.ns.NetException: Invalid number format for port number
at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:187)
at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:133)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:416)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
... 45 more
And when I try to access the JSF package this error appears:
java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed
connection for java:/Oracle
Can you help me to fix the problem?
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:34 p.m.
[
https://issues.jboss.org/browse/AS7-3141?page=com.atlassian.jira.plugin.s...
]
Brian Stansberry updated AS7-3141:
----------------------------------
Component/s: JCA
Problem with JBoss 7.1.0 and oracle datasource configuration
------------------------------------------------------------
Key: AS7-3141
URL: https://issues.jboss.org/browse/AS7-3141
Project: Application Server 7
Issue Type: Bug
Components: JCA
Environment: Centos 5.6, Oracle 11g JBoss 7.1.0.CR1b
Reporter: Peter Penzov
I cannot configure JBoss 7.1.0 to work with Oracle datasource. I used web manager to
create the datasource configuration. The problem occurs when I make a call from a managed
bean to access database resources.
This is the log file:
[root@Testserver bin]#
[root@Testserver bin]# ./standalone.sh
=========================================================================
JBoss Bootstrap Environment
JBOSS_HOME: /opt/jboss-as-7.1.0.CR1b
JAVA: /opt/jdk1.7.0_01/bin/java
JAVA_OPTS: -server -Xms64m -Xmx512m -XX:MaxPermSize=256m
-Djava.net.preferIPv4Stack=true -Dorg.jboss.resolver.warning=true
-Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000
-Djboss.modules.system.pkgs=org.jboss.byteman -Djava.awt.headless=true
=========================================================================
16:07:10,344 INFO [org.jboss.modules] JBoss Modules version 1.1.0.CR6
16:07:10,707 INFO [org.jboss.msc] JBoss MSC version 1.0.1.GA
16:07:10,766 INFO [org.jboss.as] JBoss AS 7.1.0.CR1b "Flux Capacitor"
starting
16:07:12,100 INFO [org.jboss.as] Creating http management service using socket-binding
(management-http)
16:07:12,101 INFO [org.xnio] XNIO Version 3.0.0.CR7
16:07:12,146 INFO [org.xnio.nio] XNIO NIO Implementation Version 3.0.0.CR7
16:07:12,157 INFO [org.jboss.remoting] JBoss Remoting version 3.2.0.CR8
16:07:12,207 INFO [org.jboss.as.logging] JBAS011502: Removing bootstrap log handlers
16:07:12,217 INFO [org.jboss.as.clustering] (ServerService Thread Pool -- 30)
JBAS010300: Activating Infinispan subsystem.
16:07:12,330 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 38) JBAS011800:
Activating Naming Subsystem
16:07:12,336 INFO [org.jboss.as.connector] (MSC service thread 1-1) JBAS010408: Starting
JCA Subsystem (JBoss IronJacamar 1.0.6.Final)
16:07:12,356 INFO [org.jboss.as.naming] (MSC service thread 1-3) JBAS011802: Starting
Naming Service
16:07:12,357 INFO [org.jboss.as.jaxr] (MSC service thread 1-3) Binding JAXR
ConnectionFactory: java:jboss/jaxr/ConnectionFactory
16:07:12,362 INFO [org.jboss.as.osgi] (ServerService Thread Pool -- 39) JBAS011910:
Activating OSGi Subsystem
16:07:12,412 INFO [org.jboss.as.mail.extension] (MSC service thread 1-1) JBAS015400:
Bound mail session [java:jboss/mail/Default]
16:07:12,504 INFO [org.jboss.as.security] (ServerService Thread Pool -- 44) Activating
Security Subsystem
16:07:12,507 INFO [org.jboss.as.remoting] (MSC service thread 1-1) Listening on
/10.15.203.13:4447
16:07:12,548 INFO [org.jboss.as.webservices] (ServerService Thread Pool -- 48)
JBAS015537: Activating WebServices Extension
16:07:12,616 INFO [org.jboss.ws.common.management.AbstractServerConfig] (MSC service
thread 1-3) JBoss Web Services - Stack CXF Server 4.0.0.GA
16:07:12,632 INFO [org.jboss.as.security] (MSC service thread 1-4) Picketbox
version=4.0.6.Beta2
16:07:12,983 INFO [org.apache.coyote.http11.Http11AprProtocol] (MSC service thread 1-1)
Starting Coyote HTTP/1.1 on http--10.15.203.13-8080
16:07:13,634 INFO [org.jboss.as.remoting] (MSC service thread 1-4) Listening on
/10.15.203.13:9999
16:07:13,680 INFO [org.jboss.as.server.deployment] (MSC service thread 1-4) Starting
deployment of "SR_57-ear-1.0-SNAPSHOT.ear"
16:07:13,729 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread 1-3)
JBAS015012: Started FileSystemDeploymentService for directory
/opt/jboss-as-7.1.0.CR1b/standalone/deployments
16:07:13,824 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) Starting
deployment of "SR_57-ejb-1.0-SNAPSHOT.jar"
16:07:13,825 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) Starting
deployment of "SR_57-web-1.0-SNAPSHOT.war"
16:07:14,257 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed
"SR_57-ear-1.0-SNAPSHOT.ear"
16:07:14,355 INFO [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service
status report
JBAS014775: New missing/unsatisfied dependencies:
service jboss.naming.context.java.Oracle (missing) dependents: [service
jboss.deployment.subunit."SR_57-ear-1.0-SNAPSHOT.ear"."SR_57-web-1.0-SNAPSHOT.war".component."managed-bean.com.SR_57.userCheck".START]
16:07:14,398 ERROR [org.jboss.as] (Controller Boot Thread) JBoss AS 7.1.0.CR1b "Flux
Capacitor" started (with errors) in 4303ms - Started 190 of 268 services (3 services
failed or missing dependencies, 74 services are passive or on-demand)
16:07:14,403 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) Starting
deployment of "ojdbc6.jar"
16:07:14,776 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-3)
JBAS010403: Deploying JDBC-compliant driver class oracle.jdbc.OracleDriver (version 11.2)
16:07:14,827 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559:
Deployed "ojdbc6.jar"
16:08:36,979 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread
1-2) JBAS010400: Bound data source [java:/Oracle]
16:08:37,060 INFO [javax.enterprise.resource.webcontainer.jsf.config] (MSC service
thread 1-2) Initializing Mojarra 2.1.5 (SNAPSHOT 20111202) for context
'/SR_57-web'
16:08:37,935 INFO [org.hibernate.validator.util.Version] (MSC service thread 1-2)
Hibernate Validator 4.2.0.Final
16:08:38,867 INFO [javax.enterprise.resource.webcontainer.jsf.config] (MSC service
thread 1-2) Monitoring jndi:/default-host/SR_57-web/WEB-INF/faces-config.xml for
modifications
16:08:38,942 INFO [org.jboss.web] (MSC service thread 1-2) registering web context:
/SR_57-web
16:08:38,954 INFO [org.jboss.as.controller] (HttpManagementService-threads - 1)
JBAS014774: Service status report
JBAS014776: Newly corrected services:
service jboss.naming.context.java.Oracle (no longer required)
16:08:47,288 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool]
(HttpManagementService-threads - 2) IJ000604: Throwable while attempting to get a new
connection: null: javax.resource.ResourceException: Could not create connection
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277)
[ironjacamar-jdbc-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235)
[ironjacamar-jdbc-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:736)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:341)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:396)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:361)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.internalTestConnection(AbstractPool.java:622)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.strategy.OnePool.testConnection(OnePool.java:88)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.as.connector.pool.PoolOperations$TestConnectionInPool.invokeCommandOn(PoolOperations.java:114)
[jboss-as-connector-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.connector.pool.PoolOperations$1.execute(PoolOperations.java:53)
[jboss-as-connector-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:359)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:254)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:190)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.connector.pool.PoolOperations.execute(PoolOperations.java:67)
[jboss-as-connector-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:359)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:254)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:190)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.ModelControllerImpl$DefaultPrepareStepHandler.execute(ModelControllerImpl.java:432)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:359)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:254)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:190)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.controller.ModelControllerImpl.execute(ModelControllerImpl.java:119)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.controller.ModelControllerImpl$1.execute(ModelControllerImpl.java:302)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.controller.ModelControllerImpl$1.execute(ModelControllerImpl.java:292)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.domain.http.server.DomainApiHandler.processRequest(DomainApiHandler.java:273)
at org.jboss.as.domain.http.server.DomainApiHandler.handle(DomainApiHandler.java:192)
at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:78)
at org.jboss.sun.net.httpserver.AuthFilter.doFilter(AuthFilter.java:69)
at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:81)
at
org.jboss.sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(ServerImpl.java:710)
at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:78)
at
org.jboss.as.domain.http.server.RealmReadinessFilter.doFilter(RealmReadinessFilter.java:54)
at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:81)
at org.jboss.sun.net.httpserver.ServerImpl$Exchange.run(ServerImpl.java:682)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
[:1.7.0_01]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
[:1.7.0_01]
at java.lang.Thread.run(Thread.java:722) [:1.7.0_01]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
[jboss-threads-2.0.0.GA.jar:2.0.0.GA]
Caused by: java.sql.SQLRecoverableException: IO Error: Invalid number format for port
number
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249)
[ironjacamar-jdbc-1.0.6.Final.jar:1.0.6.Final]
... 37 more
Caused by: oracle.net.ns.NetException: Invalid number format for port number
at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:187)
at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:133)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:416)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
... 42 more
16:09:25,702 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool]
(http--10.15.203.13-8080-2) IJ000604: Throwable while attempting to get a new connection:
null: javax.resource.ResourceException: Could not create connection
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235)
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:736)
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:341)
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:396)
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:361)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:327)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:302)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:444)
at
org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129)
at com.SR_57.userCheck.CheckUserDB(userCheck.java:98) [classes:]
at com.SR_57.userCheck.userCompare(userCheck.java:200) [classes:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.7.0_01]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
[:1.7.0_01]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[:1.7.0_01]
at java.lang.reflect.Method.invoke(Method.java:601) [:1.7.0_01]
at org.apache.el.parser.AstValue.invoke(AstValue.java:262) [jbossweb-7.0.7.Final.jar:]
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278)
[jbossweb-7.0.7.Final.jar:]
at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at javax.faces.component.UICommand.broadcast(UICommand.java:315)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
[jbossweb-7.0.7.Final.jar:]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
[jbossweb-7.0.7.Final.jar:]
at
org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:151)
[jboss-as-web-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)
[jbossweb-7.0.7.Final.jar:]
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:897)
[jbossweb-7.0.7.Final.jar:]
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:626)
[jbossweb-7.0.7.Final.jar:]
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:2033)
[jbossweb-7.0.7.Final.jar:]
at java.lang.Thread.run(Thread.java:722) [:1.7.0_01]
Caused by: java.sql.SQLRecoverableException: IO Error: Invalid number format for port
number
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249)
... 40 more
Caused by: oracle.net.ns.NetException: Invalid number format for port number
at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:187)
at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:133)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:416)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
... 45 more
16:09:25,709 WARNING [javax.enterprise.resource.webcontainer.jsf.lifecycle]
(http--10.15.203.13-8080-2) #{loginController.userCompare}: java.sql.SQLException:
javax.resource.ResourceException: IJ000453: Unable to get managed connection for
java:/Oracle: javax.faces.FacesException: #{loginController.userCompare}:
java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed
connection for java:/Oracle
at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:118)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at javax.faces.component.UICommand.broadcast(UICommand.java:315)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
[jbossweb-7.0.7.Final.jar:]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
[jbossweb-7.0.7.Final.jar:]
at
org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:151)
[jboss-as-web-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)
[jbossweb-7.0.7.Final.jar:]
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:897)
[jbossweb-7.0.7.Final.jar:]
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:626)
[jbossweb-7.0.7.Final.jar:]
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:2033)
[jbossweb-7.0.7.Final.jar:]
at java.lang.Thread.run(Thread.java:722) [:1.7.0_01]
Caused by: javax.faces.el.EvaluationException: java.sql.SQLException:
javax.resource.ResourceException: IJ000453: Unable to get managed connection for
java:/Oracle
at
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
... 20 more
Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to
get managed connection for java:/Oracle
at
org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:137)
at com.SR_57.userCheck.CheckUserDB(userCheck.java:98) [classes:]
at com.SR_57.userCheck.userCompare(userCheck.java:200) [classes:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.7.0_01]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
[:1.7.0_01]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[:1.7.0_01]
at java.lang.reflect.Method.invoke(Method.java:601) [:1.7.0_01]
at org.apache.el.parser.AstValue.invoke(AstValue.java:262) [jbossweb-7.0.7.Final.jar:]
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278)
[jbossweb-7.0.7.Final.jar:]
at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
... 21 more
Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection
for java:/Oracle
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:370)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:302)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:444)
at
org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129)
... 31 more
Caused by: javax.resource.ResourceException: IJ000658: Unexpected throwable while trying
to create a connection: null
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:369)
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:396)
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:361)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:327)
... 34 more
Caused by: javax.resource.ResourceException: Could not create connection
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235)
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:736)
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:341)
... 37 more
Caused by: java.sql.SQLRecoverableException: IO Error: Invalid number format for port
number
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249)
... 40 more
Caused by: oracle.net.ns.NetException: Invalid number format for port number
at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:187)
at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:133)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:416)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
... 45 more
And when I try to access the JSF package this error appears:
java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed
connection for java:/Oracle
Can you help me to fix the problem?
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
11:42 p.m.
[
https://issues.jboss.org/browse/AS7-3141?page=com.atlassian.jira.plugin.s...
]
Jesper Pedersen closed AS7-3141.
--------------------------------
Resolution: Won't Fix
Open a forum thread in the future if you have questions
Problem with JBoss 7.1.0 and oracle datasource configuration
------------------------------------------------------------
Key: AS7-3141
URL: https://issues.jboss.org/browse/AS7-3141
Project: Application Server 7
Issue Type: Bug
Components: JCA
Environment: Centos 5.6, Oracle 11g JBoss 7.1.0.CR1b
Reporter: Peter Penzov
I cannot configure JBoss 7.1.0 to work with Oracle datasource. I used web manager to
create the datasource configuration. The problem occurs when I make a call from a managed
bean to access database resources.
This is the log file:
[root@Testserver bin]#
[root@Testserver bin]# ./standalone.sh
=========================================================================
JBoss Bootstrap Environment
JBOSS_HOME: /opt/jboss-as-7.1.0.CR1b
JAVA: /opt/jdk1.7.0_01/bin/java
JAVA_OPTS: -server -Xms64m -Xmx512m -XX:MaxPermSize=256m
-Djava.net.preferIPv4Stack=true -Dorg.jboss.resolver.warning=true
-Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000
-Djboss.modules.system.pkgs=org.jboss.byteman -Djava.awt.headless=true
=========================================================================
16:07:10,344 INFO [org.jboss.modules] JBoss Modules version 1.1.0.CR6
16:07:10,707 INFO [org.jboss.msc] JBoss MSC version 1.0.1.GA
16:07:10,766 INFO [org.jboss.as] JBoss AS 7.1.0.CR1b "Flux Capacitor"
starting
16:07:12,100 INFO [org.jboss.as] Creating http management service using socket-binding
(management-http)
16:07:12,101 INFO [org.xnio] XNIO Version 3.0.0.CR7
16:07:12,146 INFO [org.xnio.nio] XNIO NIO Implementation Version 3.0.0.CR7
16:07:12,157 INFO [org.jboss.remoting] JBoss Remoting version 3.2.0.CR8
16:07:12,207 INFO [org.jboss.as.logging] JBAS011502: Removing bootstrap log handlers
16:07:12,217 INFO [org.jboss.as.clustering] (ServerService Thread Pool -- 30)
JBAS010300: Activating Infinispan subsystem.
16:07:12,330 INFO [org.jboss.as.naming] (ServerService Thread Pool -- 38) JBAS011800:
Activating Naming Subsystem
16:07:12,336 INFO [org.jboss.as.connector] (MSC service thread 1-1) JBAS010408: Starting
JCA Subsystem (JBoss IronJacamar 1.0.6.Final)
16:07:12,356 INFO [org.jboss.as.naming] (MSC service thread 1-3) JBAS011802: Starting
Naming Service
16:07:12,357 INFO [org.jboss.as.jaxr] (MSC service thread 1-3) Binding JAXR
ConnectionFactory: java:jboss/jaxr/ConnectionFactory
16:07:12,362 INFO [org.jboss.as.osgi] (ServerService Thread Pool -- 39) JBAS011910:
Activating OSGi Subsystem
16:07:12,412 INFO [org.jboss.as.mail.extension] (MSC service thread 1-1) JBAS015400:
Bound mail session [java:jboss/mail/Default]
16:07:12,504 INFO [org.jboss.as.security] (ServerService Thread Pool -- 44) Activating
Security Subsystem
16:07:12,507 INFO [org.jboss.as.remoting] (MSC service thread 1-1) Listening on
/10.15.203.13:4447
16:07:12,548 INFO [org.jboss.as.webservices] (ServerService Thread Pool -- 48)
JBAS015537: Activating WebServices Extension
16:07:12,616 INFO [org.jboss.ws.common.management.AbstractServerConfig] (MSC service
thread 1-3) JBoss Web Services - Stack CXF Server 4.0.0.GA
16:07:12,632 INFO [org.jboss.as.security] (MSC service thread 1-4) Picketbox
version=4.0.6.Beta2
16:07:12,983 INFO [org.apache.coyote.http11.Http11AprProtocol] (MSC service thread 1-1)
Starting Coyote HTTP/1.1 on http--10.15.203.13-8080
16:07:13,634 INFO [org.jboss.as.remoting] (MSC service thread 1-4) Listening on
/10.15.203.13:9999
16:07:13,680 INFO [org.jboss.as.server.deployment] (MSC service thread 1-4) Starting
deployment of "SR_57-ear-1.0-SNAPSHOT.ear"
16:07:13,729 INFO [org.jboss.as.server.deployment.scanner] (MSC service thread 1-3)
JBAS015012: Started FileSystemDeploymentService for directory
/opt/jboss-as-7.1.0.CR1b/standalone/deployments
16:07:13,824 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) Starting
deployment of "SR_57-ejb-1.0-SNAPSHOT.jar"
16:07:13,825 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) Starting
deployment of "SR_57-web-1.0-SNAPSHOT.war"
16:07:14,257 INFO [org.jboss.as.server] (Controller Boot Thread) JBAS018559: Deployed
"SR_57-ear-1.0-SNAPSHOT.ear"
16:07:14,355 INFO [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service
status report
JBAS014775: New missing/unsatisfied dependencies:
service jboss.naming.context.java.Oracle (missing) dependents: [service
jboss.deployment.subunit."SR_57-ear-1.0-SNAPSHOT.ear"."SR_57-web-1.0-SNAPSHOT.war".component."managed-bean.com.SR_57.userCheck".START]
16:07:14,398 ERROR [org.jboss.as] (Controller Boot Thread) JBoss AS 7.1.0.CR1b "Flux
Capacitor" started (with errors) in 4303ms - Started 190 of 268 services (3 services
failed or missing dependencies, 74 services are passive or on-demand)
16:07:14,403 INFO [org.jboss.as.server.deployment] (MSC service thread 1-3) Starting
deployment of "ojdbc6.jar"
16:07:14,776 INFO [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-3)
JBAS010403: Deploying JDBC-compliant driver class oracle.jdbc.OracleDriver (version 11.2)
16:07:14,827 INFO [org.jboss.as.server] (DeploymentScanner-threads - 2) JBAS018559:
Deployed "ojdbc6.jar"
16:08:36,979 INFO [org.jboss.as.connector.subsystems.datasources] (MSC service thread
1-2) JBAS010400: Bound data source [java:/Oracle]
16:08:37,060 INFO [javax.enterprise.resource.webcontainer.jsf.config] (MSC service
thread 1-2) Initializing Mojarra 2.1.5 (SNAPSHOT 20111202) for context
'/SR_57-web'
16:08:37,935 INFO [org.hibernate.validator.util.Version] (MSC service thread 1-2)
Hibernate Validator 4.2.0.Final
16:08:38,867 INFO [javax.enterprise.resource.webcontainer.jsf.config] (MSC service
thread 1-2) Monitoring jndi:/default-host/SR_57-web/WEB-INF/faces-config.xml for
modifications
16:08:38,942 INFO [org.jboss.web] (MSC service thread 1-2) registering web context:
/SR_57-web
16:08:38,954 INFO [org.jboss.as.controller] (HttpManagementService-threads - 1)
JBAS014774: Service status report
JBAS014776: Newly corrected services:
service jboss.naming.context.java.Oracle (no longer required)
16:08:47,288 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool]
(HttpManagementService-threads - 2) IJ000604: Throwable while attempting to get a new
connection: null: javax.resource.ResourceException: Could not create connection
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277)
[ironjacamar-jdbc-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235)
[ironjacamar-jdbc-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:736)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:341)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:396)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:361)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.internalTestConnection(AbstractPool.java:622)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.jca.core.connectionmanager.pool.strategy.OnePool.testConnection(OnePool.java:88)
[ironjacamar-core-impl-1.0.6.Final.jar:1.0.6.Final]
at
org.jboss.as.connector.pool.PoolOperations$TestConnectionInPool.invokeCommandOn(PoolOperations.java:114)
[jboss-as-connector-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.connector.pool.PoolOperations$1.execute(PoolOperations.java:53)
[jboss-as-connector-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:359)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:254)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:190)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.connector.pool.PoolOperations.execute(PoolOperations.java:67)
[jboss-as-connector-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:359)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:254)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:190)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.ModelControllerImpl$DefaultPrepareStepHandler.execute(ModelControllerImpl.java:432)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.executeStep(AbstractOperationContext.java:359)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.doCompleteStep(AbstractOperationContext.java:254)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.controller.AbstractOperationContext.completeStep(AbstractOperationContext.java:190)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.controller.ModelControllerImpl.execute(ModelControllerImpl.java:119)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.controller.ModelControllerImpl$1.execute(ModelControllerImpl.java:302)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.jboss.as.controller.ModelControllerImpl$1.execute(ModelControllerImpl.java:292)
[jboss-as-controller-7.1.0.CR1b.jar:7.1.0.CR1b]
at
org.jboss.as.domain.http.server.DomainApiHandler.processRequest(DomainApiHandler.java:273)
at org.jboss.as.domain.http.server.DomainApiHandler.handle(DomainApiHandler.java:192)
at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:78)
at org.jboss.sun.net.httpserver.AuthFilter.doFilter(AuthFilter.java:69)
at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:81)
at
org.jboss.sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(ServerImpl.java:710)
at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:78)
at
org.jboss.as.domain.http.server.RealmReadinessFilter.doFilter(RealmReadinessFilter.java:54)
at org.jboss.com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:81)
at org.jboss.sun.net.httpserver.ServerImpl$Exchange.run(ServerImpl.java:682)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
[:1.7.0_01]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
[:1.7.0_01]
at java.lang.Thread.run(Thread.java:722) [:1.7.0_01]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
[jboss-threads-2.0.0.GA.jar:2.0.0.GA]
Caused by: java.sql.SQLRecoverableException: IO Error: Invalid number format for port
number
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249)
[ironjacamar-jdbc-1.0.6.Final.jar:1.0.6.Final]
... 37 more
Caused by: oracle.net.ns.NetException: Invalid number format for port number
at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:187)
at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:133)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:416)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
... 42 more
16:09:25,702 WARN [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool]
(http--10.15.203.13-8080-2) IJ000604: Throwable while attempting to get a new connection:
null: javax.resource.ResourceException: Could not create connection
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235)
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:736)
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:341)
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:396)
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:361)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:327)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:302)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:444)
at
org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129)
at com.SR_57.userCheck.CheckUserDB(userCheck.java:98) [classes:]
at com.SR_57.userCheck.userCompare(userCheck.java:200) [classes:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.7.0_01]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
[:1.7.0_01]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[:1.7.0_01]
at java.lang.reflect.Method.invoke(Method.java:601) [:1.7.0_01]
at org.apache.el.parser.AstValue.invoke(AstValue.java:262) [jbossweb-7.0.7.Final.jar:]
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278)
[jbossweb-7.0.7.Final.jar:]
at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at javax.faces.component.UICommand.broadcast(UICommand.java:315)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
[jbossweb-7.0.7.Final.jar:]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
[jbossweb-7.0.7.Final.jar:]
at
org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:151)
[jboss-as-web-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)
[jbossweb-7.0.7.Final.jar:]
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:897)
[jbossweb-7.0.7.Final.jar:]
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:626)
[jbossweb-7.0.7.Final.jar:]
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:2033)
[jbossweb-7.0.7.Final.jar:]
at java.lang.Thread.run(Thread.java:722) [:1.7.0_01]
Caused by: java.sql.SQLRecoverableException: IO Error: Invalid number format for port
number
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249)
... 40 more
Caused by: oracle.net.ns.NetException: Invalid number format for port number
at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:187)
at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:133)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:416)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
... 45 more
16:09:25,709 WARNING [javax.enterprise.resource.webcontainer.jsf.lifecycle]
(http--10.15.203.13-8080-2) #{loginController.userCompare}: java.sql.SQLException:
javax.resource.ResourceException: IJ000453: Unable to get managed connection for
java:/Oracle: javax.faces.FacesException: #{loginController.userCompare}:
java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed
connection for java:/Oracle
at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:118)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at javax.faces.component.UICommand.broadcast(UICommand.java:315)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:794)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:1259)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:81)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:593)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
[jbossweb-7.0.7.Final.jar:]
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
[jbossweb-7.0.7.Final.jar:]
at
org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:151)
[jboss-as-web-7.1.0.CR1b.jar:7.1.0.CR1b]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
[jbossweb-7.0.7.Final.jar:]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)
[jbossweb-7.0.7.Final.jar:]
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:897)
[jbossweb-7.0.7.Final.jar:]
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:626)
[jbossweb-7.0.7.Final.jar:]
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:2033)
[jbossweb-7.0.7.Final.jar:]
at java.lang.Thread.run(Thread.java:722) [:1.7.0_01]
Caused by: javax.faces.el.EvaluationException: java.sql.SQLException:
javax.resource.ResourceException: IJ000453: Unable to get managed connection for
java:/Oracle
at
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
at
com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
... 20 more
Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to
get managed connection for java:/Oracle
at
org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:137)
at com.SR_57.userCheck.CheckUserDB(userCheck.java:98) [classes:]
at com.SR_57.userCheck.userCompare(userCheck.java:200) [classes:]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.7.0_01]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
[:1.7.0_01]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[:1.7.0_01]
at java.lang.reflect.Method.invoke(Method.java:601) [:1.7.0_01]
at org.apache.el.parser.AstValue.invoke(AstValue.java:262) [jbossweb-7.0.7.Final.jar:]
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:278)
[jbossweb-7.0.7.Final.jar:]
at com.sun.faces.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:105)
[jsf-impl-2.1.5-jbossorg-1.jar:2.1.5-SNAPSHOT]
at
javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
[jboss-jsf-api_2.1_spec-2.0.0.Beta1.jar:2.0.0.Beta1]
... 21 more
Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection
for java:/Oracle
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:370)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:302)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:444)
at
org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:129)
... 31 more
Caused by: javax.resource.ResourceException: IJ000658: Unexpected throwable while trying
to create a connection: null
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:369)
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:396)
at
org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:361)
at
org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:327)
... 34 more
Caused by: javax.resource.ResourceException: Could not create connection
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:277)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:235)
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:736)
at
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:341)
... 37 more
Caused by: java.sql.SQLRecoverableException: IO Error: Invalid number format for port
number
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at
org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:249)
... 40 more
Caused by: oracle.net.ns.NetException: Invalid number format for port number
at oracle.net.resolver.HostnameNamingAdapter.resolve(HostnameNamingAdapter.java:187)
at oracle.net.resolver.NameResolver.resolveName(NameResolver.java:133)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:416)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
... 45 more
And when I try to access the JSF package this error appears:
java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed
connection for java:/Oracle
Can you help me to fix the problem?
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
4614
days inactive
4669
days old
3 comments
4 participants
participants (4)
-
Brian Stansberry (JIRA) -
Jesper Pedersen (JIRA)
-
Peter Penzov (Commented) (JIRA)
-
Peter Penzov (Created) (JIRA)