File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Error: Connection got Reset Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Error: Connection got Reset " Watch "Error: Connection got Reset " New topic
Author

Error: Connection got Reset

Vidu Greg
Greenhorn

Joined: Sep 05, 2005
Posts: 10
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

Joined: Apr 14, 2004
Posts: 10336

The Oracle drivers have never been very good at handling LOBs. Are you using the latest driver?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Error: Connection got Reset