2 Replies Latest reply on May 29, 2015 7:54 PM by SANJAY GAUTAM

    Wildfly2.0.0.Final Not able to connect to Oracle

    AKumar Tyagi Newbie

      Hello 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