code save word file in 10g database

Hi Friend,

Try the following code:

import java.io.*;
import java.sql.*;

public class InsertFile {

public static Connection getConnection() throws Exception {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection ("jdbc:oracle:thin:@localhost:3306:test","root", "root"); return conn;
}

public static void main(String[] args)throws Exception {
String id = "001";
String fileName = "C:\\New.doc";

FileInputStream fis = null;
PreparedStatement pstmt = null;
Connection conn = null;
try {
conn = getConnection();
conn.setAutoCommit(false);
File file = new File(fileName);
fis = new FileInputStream(file);
pstmt = conn.prepareStatement("insert into file( file, file_data) values ( ?, ?)");
//pstmt.setString(1, id);
pstmt.setString(1, fileName);
pstmt.setAsciiStream(2, fis, (int) file.length());
pstmt.executeUpdate();
conn.commit();
} catch (Exception e) {
System.err.println("Error: " + e.getMessage());
e.printStackTrace();
} finally {
pstmt.close();
fis.close();
conn.close();
}
}
}

Hope that it will be helpful for you.
Thanks