Resolution:
Description:
============
Error thrown "java.sql.SQLRecoverableException: No more data to read from socket error thrown" while executing a Query.

Environment:
============
TIBCO BusinessEvents 4.0.1
All Operating Systems

Symptoms:
============
The following Oracle related error is thrown while executing a query using Oracle.executeQuery

2013 Aug 05 14:41:25:426 GMT _BE Error [$default.be.mt$.Thread.4] - [root] java.sql.SQLRecoverableException: No more data to read from socket
2013 Aug 05 14:41:25:426 GMT _BE Error [$default.be.mt$.Thread.4] - [root]       at oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1200)
2013 Aug 05 14:41:25:426 GMT _BE Error [$default.be.mt$.Thread.4] - [root]       at oracle.jdbc.driver.T4CMAREngine.unmarshalSB1(T4CMAREngine.java:1155)
2013 Aug 05 14:41:25:426 GMT_BE Error [$default.be.mt$.Thread.4] - [root]       at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:279)
2013 Aug 05 14:41:25:427 GMT_BE Error [$default.be.mt$.Thread.4] - [root]       at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
2013 Aug 05 14:41:25:427 GMT _BE Error [$default.be.mt$.Thread.4] - [root]       at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
2013 Aug 05 14:41:25:427 GMT_BE Error [$default.be.mt$.Thread.4] - [root]       at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
2013 Aug 05 14:41:25:427 GMT_BE Error [$default.be.mt$.Thread.4] - [root]       at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)


Resolution:
============
Try and execute the query using SQLPlus. You should be using the latest version of Oracle JDBC driver version. To be sure the correct JDBC driver is loaded by TIBCO BusinessEvents, update the classpath settings in the TRA and add the ojdbc6.jar at the beginning of the classpath.

Error thrown "java.sql.SQLRecoverableException: No more data to read from socket error thrown" while executing a Query.