Hi,

I am trying to insert a file from my local system into the database using a web application. The application is running on a remote server.

The problem is my application on the server is not able to get the file from my local system.

Can any one help how to solve this problem.

Regards

__________________
Regards

Little more info about how you implemented and what error you are getting will help us solve your problem.

- Rakesh

Try FileI/O inside the service/doXXX methods like below.


//process the action
 conn = getConnection();
      conn.setAutoCommit(false);
      File file = new File(fileName);
      fir = new FileReader(file);
      pstmt = conn.prepareStatement("insert into DataFiles(id, fileName, fileBody) values (?, ?, ?)");
      pstmt.setString(1, id);
      pstmt.setString(2, fileName);
      pstmt.setAsciiStream(3, fis, (int) file.length());
      pstmt.executeUpdate();
      conn.commit();


}