How to upload .txt file to mysql using JDBC

[sks]

Hi all,
Please help me how to upload .txt file to mysql. the parameter in sql is BLOB.
Do i need to save the file in my local disk first then query the file to sql?
or mayb u can suggest any link for me....

thanks in advance

[Tolls]

You have a stream for the uploaded file, just use that in the insert query (setBinaryStream() in PreparedStatement). No need to go via disk.

[UJJAL DHAR]

BLOB is not needed.You can make a table with a single field parameter TEXT.And you can upload a .text from your desktop on it using FILE class .

       String fileName ="C:/insert.txt";
       File file = new File(fileName);
       FileInputStream fis = new FileInputStream(file);
       pstmt = conn.prepareStatement("insert into tablename(columnname) values (?)");
     
      pstmt.setAsciiStream(1, fis, (int) file.length());
      pstmt.executeUpdate();