JDBC - Blob insertion problem - java.sql.SQLException: Data size bigger
While Attachment of File Upload , following exception is thrown , I am trying to store file info in to a BLOB column of DB through converting data in binary input stream . If I am trying to upload/ attach a file morethan 4KB , exception is thrown ,. Please help me in this matter
06/11/24 20:34:24 java.sql.SQLException: Data size bigger than max size for this type: 328805
06/11/24 20:34:24 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:137)
06/11/24 20:34:24 at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:174)
06/11/24 20:34:24 at oracle.jdbc.driver.OraclePreparedStatement.setRAW(OraclePreparedStatement.java:5359)
06/11/24 20:34:24 at oracle.jdbc.driver.OraclePreparedStatement.setBinaryStreamInternal(OraclePreparedStatement .java:6903)
06/11/24 20:34:24 at oracle.jdbc.driver.OracleCallableStatement.setBinaryStream(OracleCallableStatement.java:45 10)
06/11/24 20:34:24 at com.p6spy.engine.spy.P6PreparedStatement.setBinaryStream(P6PreparedStatement.java:214)
06/11/24 20:34:24 at com.p6spy.engine.spy.P6PreparedStatement.setBinaryStream(P6PreparedStatement.java:214)
06/11/24 20:34:24 at com.evermind.sql.PreparedStatementBCELProxy.setBinaryStream(PreparedStatementBCELProxy.jav a:291)
06/11/24 20:34:24 at eva.shm.ABfmsattachments.insFBfmsattachments(ABfmsattachments.java:178)
06/11/24 20:34:24 at eva.shm.C890100H.doProcess(C890100H.java:308)
06/11/24 20:34:24 at eva.global.ControllerSupport.getModelView(Unknown Source)
06/11/24 20:34:24 at eva.shm.C890100H.execute(C890100H.java:91)
06/11/24 20:34:24 at servlet.global.DispatcherServlet.doGet(Unknown Source)
06/11/24 20:34:24 at servlet.global.DispatcherServlet.doPost(Unknown Source)
06/11/24 20:34:24 at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
06/11/24 20:34:24 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
06/11/24 20:34:24 at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:65)
06/11/24 20:34:24 at com.foursoft.util.filter.GZIPFilter.doFilter(Unknown Source)
06/11/24 20:34:24 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:649 )
06/11/24 20:34:24 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher .java:322)
06/11/24 20:34:24 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
06/11/24 20:34:24 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:270)
06/11/24 20:34:24 at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:112)
06/11/24 20:34:24 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledEx ecutor.java:186)
06/11/24 20:34:24 at java.lang.Thread.run(Thread.java:534)

