preparedstatement throws sqlexception

[azhar bharat]

I have a code to upload file to database.
I use preparedstatements.

When I run the code, i am able to upload text files. If i choose any images or other files a SQLException is thrown.

String contentType = image.getContentType();
        
String fileName=image.getFileName();
       
int size = image.getFileSize();
        
String data = null;       
        
IDatabase idb;
 
try {
    byte[] imagedata=image.getFileData();
    ByteArrayInputStream bais=new ByteArrayInputStream(imagedata);
            
    idb=new Connect();          
            
    Connection connection=idb.connectToDB();
            
    connection.setAutoCommit(false);
 
    String sql = "insert into filetable " +
                 "(CurrentSessionID,ContentType,FileData,FileName,Module)"+
                 "values (?,?,?,?,?)";
            //FileData column is of BLOB datatype.
            PreparedStatement prst=connection.prepareStatement(sql);
            
            prst.setString(1, ses.getId());
            prst.setString(2, contentType);
            prst.setBinaryStream(3, bais, size);
            prst.setString(4, fileName);
            prst.setInt(5, 1);
            
            prst.execute();
            connection.commit();
            
            idb.closeAll();           
                        
        } 
//catch statements                       

Any idea why it happens?

[Scott Johnson]

Please post the full exception message and stacktrace.

[azhar bharat]

java.sql.SQLException: Data too long for column 'FileData' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1997) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1167) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1278) at com.mysql.jdbc.Connection.execSQL(Connection.java:2251) at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1371) at recolo.classifieds.image.ImageUpload.upload(ImageUpload.java:73) at recolo.classifieds.image.ImageUploadAction.execute(ImageUploadAction.java:51) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:226) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1164) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:415) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:738) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:362) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:825) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:738) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:526) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)

[azhar bharat]

As you can see it says
"Data too long for column 'FileData' at row 1"

But most files i tried to upload are less than 1mb.

[azhar bharat]

ok, i got it working.
Changed the column type to "MEDIUMBLOB".