Couldn't able to insert image file in MySQL, Data truncation: Data too long for column 'image' at...

[Venkattesh Iyer]

Hello friends,

I dont know what to do, i am tring to insert the image (blob) in to the table but I am getting such error
Data truncation: Data too long for column 'image' at row 1

Here is the code.

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

public class insertImage {
    public static void main(String[] args) {
    System.out.println("Insert Image Example!");
    String driverName = "com.mysql.jdbc.Driver";
    String url = "jdbc:mysql://localhost:3306/";
    String dbName = "mynewdatabase";
    String userName = "root";
    String password = "admin";
    Connection con = null;
    try{
      Class.forName(driverName);
      con = DriverManager.getConnection(url+dbName,userName,password);
      Statement st = con.createStatement();
      File imgfile = new File("Template.jpg");
      FileInputStream fin = new FileInputStream(imgfile);
      PreparedStatement pre = con.prepareStatement("insert into save_image values(?,?,?)");
      pre.setInt(1,100);
      pre.setString(2,"Template");
      pre.setBinaryStream(3,fin,(int)imgfile.length());
     // pre.setBinaryStream(3,fin,fin.available());
      pre.executeUpdate();
      System.out.println("Inserting Successfully!");
      pre.close();
      con.close();
    }
    catch (Exception e){
      System.out.println(e.getMessage());
    }
  }

} 

Please guide me,


Thanks,

Venkat.

[Campbell Ritchie]

Don't know, but what size image are you passing and what size BLOB did you specify?

[Venkattesh Iyer]

Ya the size of the file was more than tha size of BLOB.
I could solve by using LONGBLOB

Thanks, Venkat

[Campbell Ritchie]

You're welcome