Problem Storing image file in MySQL

[Scott Updike]

I'm attempting to write a procedure to take a .gif file and store it in my MySQL database. So, in order, this is what happens:
1) user selects which file to save.
2) I take that file selection, store it locally on the web server.
3) Create a FileInputStream object based on the File object in (2).
4) Call my DAO with the FileInputStream where I insert the gif file using the PreparedStatement.setBinaryStream method.

When I run this code (below), I get the following error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(inv_id, caption, inv_image) values (63,'test',_binary'����\0JFIF\0\0\0d\0d\0' at line 1

Code snippets are below:

This code snippet takes the request object and parses out the parameters for the DAO call (one of which is the file itself).

InsertInvImageForm uploadInvImageForm = (InsertInvImageForm) form;
            FormFile formFileNew = uploadInvImageForm.getImageNew();
            
 
            String caption = uploadInvImageForm.getCaption();
            int invID = uploadInvImageForm.getInvID();
            
            
            if (formFileNew!=null) {
                
               //log.info("Attempting to save " + formFileNew.getFileName() + " image to file system." );  
               byte[] bytes = formFileNew.getFileData();
               ServletContext sc = getServlet().getServletContext();
               String savepath = sc.getRealPath("/WEB-INF/imagefiles");
               String fname = formFileNew.getFileName();
               File uploadedFile = new File(savepath, fname);
               RandomAccessFile raf = new RandomAccessFile(uploadedFile, "rw");
               raf.write(bytes,0,bytes.length-2);
               raf.close();
               log.info(formFileNew.getFileName() + " successfully saved. " + Integer.toString(formFileNew.getFileSize()) + "bytes loaded.");
               
            
                
               try {
                    log.info("Attempting to save " + formFileNew.getFileName() + " image to database." );
                    //Insert new inventory image 
                    FileInputStream fis = new FileInputStream(uploadedFile);
                    log.info(Integer.toString(fis.available()));
                    FileManagementDAO filemanDAO = DAOFactory.getInstance().getFileManagementDAO();
                    filemanDAO.createInvImage(invID,caption,fis, (int)uploadedFile.length());
                    fis.close();

Here's the code in my DAO:

public void createInvImage(int invid, String caption, FileInputStream fis, int filelength)
      throws Exception {
    
            Connection connection = null;
            PreparedStatement pStatement = null;
            
            
            try {
 
                connection=getConnection();
                pStatement= connection.prepareStatement(INSERT_INV_IMAGE_SQL);
                pStatement.setInt(1,invid);
                pStatement.setString(2,caption);
                pStatement.setBinaryStream(3,fis,filelength);
                pStatement.executeUpdate();
                pStatement.close(); 

I can verify that the file is valid and stored properly locally on the web server, so I know the chained File to the FileInputStream object is valid and is not null.

Here's the table that I'm writing to:

CREATE TABLE  inv_picture (
  INV_ID int(10) unsigned NOT NULL,
  CAPTION varchar(45) NOT NULL,
  INV_IMAGE longblob NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

My MySQL Connector is version 3.1.12.

Does anyone have any ideas?

Thanks,
Scott