Wildfly2.0.0.Final Not able to connect to Oracle
tyagiarya May 29, 2015 2:49 PMHello Everyone,
We have urgent issue here, till last night out wildfly server was running fine but from this morning it is not able to deploy our application.We are getting Oracle connectivity error's
2015-05-29 14:59:16,705 INFO (AbstractLoggingWriter.java:write:71) Loading POSInformation Class.....
2015-05-29 14:59:17,105 INFO (BinderServiceUtil.java:transition:84) JBAS011605: Unbound messaging object to jndi name java:/XAConnectionFactory
2015-05-29 14:59:17,108 INFO (DataSourceEnable.java:transition:244) JBAS010409: Unbound data source [java:/jdbc/oraclexads]
2015-05-29 14:59:17,111 INFO (DriverService.java:stop:75) JBAS010418: Stopped Driver service with driver-name = POSWeb.war_com.mysql.jdbc.Driver_5_1
2015-05-29 14:59:17,113 INFO (AS7BindingRegistry.java:unbind:100) JBAS011605: Unbound messaging object to jndi name java:jboss/exported/jms/queue/POSAppsInboundQueue
2015-05-29 14:59:17,112 INFO (DriverService.java:stop:75) JBAS010418: Stopped Driver service with driver-name = com.mysql
2015-05-29 14:59:17,116 WARN (SemaphoreArrayListManagedConnectionPool.java:shutdown:961) IJ000615: Destroying active connection in pool: oraclexads (org.jboss.jca.adapters.jdbc.xa.XAManagedConnection@78a77f6c)
2015-05-29 14:59:17,120 INFO (AS7BindingRegistry.java:unbind:100) JBAS011605: Unbound messaging object to jndi name java:/queue/POSAppsOutboundQueue3
2015-05-29 14:59:17,118 INFO (DataSourceEnable.java:transition:244) JBAS010409: Unbound data source [java:/jdbc/oracleds]
2015-05-29 14:59:17,123 INFO (AS7BindingRegistry.java:unbind:100) JBAS011605: Unbound messaging object to jndi name java:jboss/exported/jms/queue/POSAppsOutboundQueue3
2015-05-29 14:59:17,124 INFO (DriverService.java:stop:75) JBAS010418: Stopped Driver service with driver-name = oracle
2015-05-29 14:59:17,124 INFO (AS7BindingRegistry.java:unbind:100) JBAS011605: Unbound messaging object to jndi name java:jboss/exported/jms/queue/POSAppsOutboundQueue9
2015-05-29 14:59:17,125 INFO (AS7BindingRegistry.java:unbind:100) JBAS011605: Unbound messaging object to jndi name java:/queue/POSAppsOutboundQueue9
2015-05-29 14:59:17,126 INFO (AS7BindingRegistry.java:unbind:100) JBAS011605: Unbound messaging object to jndi name java:jboss/exported/jms/RemoteConnectionFactory
2015-05-29 14:59:17,127 INFO (AS7BindingRegistry.java:unbind:100) JBAS011605: Unbound messaging object to jndi name java:jboss/exported/jms/queue/POSAppsOutboundQueue8
2015-05-29 14:59:17,128 INFO (AS7BindingRegistry.java:unbind:100) JBAS011605: Unbound messaging object to jndi name java:/queue/POSAppsOutboundQueue8
2015-05-29 14:59:17,129 INFO (AS7BindingRegistry.java:unbind:100) JBAS011605: Unbound messaging object to jndi name java:jboss/exported/jms/HTTPConnectionFactory
2015-05-29 14:59:17,132 INFO (AS7BindingRegistry.java:unbind:100) JBAS011605: Unbound messaging object to jndi name java:/queue/POSAppsOutboundQueue1
2015-05-29 14:59:17,141 INFO (AS7BindingRegistry.java:unbind:100) JBAS011605: Unbound messaging object to jndi name java:jboss/exported/jms/queue/POSAppsOutboundQueue1
2015-05-29 14:59:17,143 INFO (MailSessionAdd.java:transition:140) JBAS015401: Unbound mail session [java:jboss/mail/Default]
Also sometimes we are getting following error
2015-05-29 14:31:30,450 WARN (SemaphoreArrayListManagedConnectionPool.java:getConnection:478) 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.createLocalManagedConnection(LocalManagedConnectionFactory.java:347)
at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:354)
at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:288)
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:1166)
at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:446)
at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getTransactionNewConnection(AbstractPool.java:541)
at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:442)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:379)
at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:421)
at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:515)
at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:146)
at com.osi.pos.common.util.POSConnectionManager.getConnectionForMDB(POSConnectionManager.java:113)
at com.osi.pos.ejb.POSAppsInboundMDB.insertMessage(POSAppsInboundMDB.java:303)
at com.osi.pos.ejb.POSAppsInboundMDB.onMessage(POSAppsInboundMDB.java:93)
at sun.reflect.GeneratedMethodAccessor29.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at org.jboss.as.ee.component.ManagedReferenceMethodInterceptor.processInvocation(ManagedReferenceMethodInterceptor.java:52)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
at org.jboss.invocation.WeavedInterceptor.processInvocation(WeavedInterceptor.java:53)
at org.jboss.as.ee.component.interceptors.UserInterceptorFactory$1.processInvocation(UserInterceptorFactory.java:63)
at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:309)
at org.jboss.as.ejb3.component.invocationmetrics.ExecutionTimeInterceptor.processInvocation(ExecutionTimeInterceptor.java:43)
...................
Caused by: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:673)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:715)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:385)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:30)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:564)
at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:322)
... 85 more
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:445)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:464)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:594)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:229)
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1360)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:486)
... 90 more
Caused by: java.net.NoRouteToHostException: No route to host
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:579)
at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:162)
at oracle.net.nt.ConnOption.connect(ConnOption.java:133)
at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:411)
But our Oracle is running fine and we are able to connect to it through SQL Developer. Any help is greatly appreciated.
Thanks,
Abhinandan