Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

tomcat connection pool - oracle blob

 
satish
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It seems java.sql.Blob can handle blob size of < 4k.
Any size more gives SQLException: No more data to read from socket
That is why we need to use oracle.sql.BLOB and typecast resultset to OracleResultSet .
But TOMCAT connection pool gives classcast exception with OracleResultSet.

Any work around ?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic