java.sql.SQLException: Io exception: Connection reset by peer: socket.....
hai
when i am tring to store an image into oracle database using the following program
import java.sql.*;
import java.io.*;
import java.util.*;
publicclass test{
publicstaticvoid main(String args[])throws Exception{
FileInputStream fr=new FileInputStream("d:\\murthy\\work\\image\\Photo.JPG");
int l=fr.available();
System.out.println(l);
DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver());
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.1:1521:OIRIS","murthy","murthy");
System.in.read();
System.out.println("Connection to Oracle");
String str="insert into itab values(?,?)";
PreparedStatement pstmt=con.prepareStatement(str);
pstmt.setString(1,"1");
pstmt.setBinaryStream(2,fr,l);
pstmt.executeUpdate();
con.close();
}
}
I got this Exception but it works fine in SQLsever
Connection to Oracle
Exception in thread "main" java.sql.SQLException: Io exception: Connection reset by peer: socket write error
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:648)
at oracle.jdbc.driver.OraclePreparedStatement.privateClose(OraclePrepare
dStatement.java:485)
at oracle.jdbc.driver.OraclePreparedStatement.close(OraclePreparedStatem
ent.java:393)
at oracle.jdbc.driver.OracleConnection.close_statements(OracleConnection
.java:2333)
at oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:1412)
at test.main(test.java:48)
please help me
