SQLRecoverableException from Oracle JDBC datasource in JBoss EAP

Solution Verified - Updated -

Issue

  • Errors such as the below are encountered by the application

        ... java.sql.SQLRecoverableException: No more data to read from socket
             at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1200)
             at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)
             ...
    
    ... java.sql.SQLRecoverableException: Keine weiteren Daten aus Socket zu lesen
        at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1200)
        at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)
        ...
    
    ... java.sql.BatchUpdateException: IO Error: Broken Pipe
    
  • The datasource connection pool is failing, the below error has been observed in the server.log file:

    ... WARN  [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Unable to fill pool 
        org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: No more data to read from socket)
            at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:164)
            at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:519)
            at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.fillToMin(InternalManagedConnectionPool.java:466)
            at org.jboss.resource.connectionmanager.PoolFiller.run(PoolFiller.java:70)
            at java.lang.Thread.run(Thread.java:595)
        Caused by: java.sql.SQLException: No more data to read from socket
            at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1157)
            at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:290)
            ...
    

Environment

  • Red Hat JBoss Enterprise Application Platform (EAP)
    • 7
    • 6
    • 5
    • 4

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In