title: Socket Exception : recv failed with oracle thin driver
body: <p>I am facing an issue where my test suite randomly fails with an socket exception </p>
  
  <pre>
  <code>
  oracle.jdbc.driver.T4CStatement 1267 - Throwing SQLException: java.net.SocketException: Software caused connection abort: recv failed 
  </code>
  </pre>
  
  <p>The test suite fails with this exception when a given set of test cases are executed in a particular order. I got the above error log after enabling the oracle jdbc driver logs. The query which leads to this error is always a "DROP SEQUENCE  query". There is nothing special about this query since it is fired 'n' number of times during the execution flow.</p>
  
  <p>One of the <a href="http://blogs.oracle.com/oleksiys/entry/strange_software_caused_connection_abort" rel="nofollow">blog link</a> points out that the above error is because the server side sockets gets closed before the client expects. To troubleshoot more on this point I tried analyzing the Oracle TNSListener logs - listener.log file but was not able to gather much information since the log file only contained information about the socket CONNECT function call.</p>
  
  <ol>
  <li><p>What could be the possible causes of the above error in addition to the one the blog link mentions?</p></li>
  <li><p>How can I configure the Oracle TNSListener to provide more detailed information about the socket communication? For e.g. Trace information when the server socket close event is fired. </p></li>
  </ol>
  
  <p>I would appreciated if anyone could point out to a possible cause of this error or provide more information which could help me to troubleshoot this issue further based on the above two points</p>