title: sybase and jdbc. Could not commit jdbc transaction. Read time out
body: <p>After my app tries committing many transactions after several mins, I'm getting the following exception:</p>
  
  <blockquote>
    <p>could not commit jdbc transaction nested exception is
    java.sql.sqlexception: jz006: caught ioexception:
    java.net.SocketTimeoutException: Read timed out..."</p>
  </blockquote>
  
  <p>I'm using Sybase with the JDBC 4 driver with Spring JDBC, and I found this link: <a href="http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc39001.0707/html/prjdbc0707/prjdbc070714.htm" rel="nofollow noreferrer">http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc39001.0707/html/prjdbc0707/prjdbc070714.htm</a>
  Could I just use any of the following:</p>
  
  <blockquote>
    <p>SESSION_TIMEOUT<br/>
    DEFAULT_QUERY_ TIMEOUT<br/>
    INTERNAL_QUERY_TIMEOUT<br/></p>
  </blockquote>
  
  <p>One idea is to make the transactions in batch, but I have no time to develop that.
  What options are there to avoid getting that error? </p>