This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Error: Connection got Reset

 
Vidu Greg
Greenhorn
Posts: 10
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

While writing Blob object in Oracle db, my connection is getting reset.

<<My Code-----
try {
PreparedStatement ps =null;
Connection conn = getConnection();
String sql = "INSERT INTO ATTACHMENT (ATTACHMENT.ID, DOC_DATA) "VALUES (?,?)";
ByteArrayInputStream inStream =
new ByteArrayInputStream(dto.getDoc_Data());
ps = conn.prepareStatement(sql);
ps.setInt(1,attachment_Id);
ps.setBinaryStream(4,inStream,inStream.available());
int rowsAdded = ps.executeUpdate();

} catch (SQLException e) {
e.printStackTrace();
}

>>>

I dont know why my my connection is getting reset so getting an error..i am trying to put a pdf file of size around 45kb...
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The Oracle drivers have never been very good at handling LOBs. Are you using the latest driver?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic