Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

JDBC - Blob insertion problem - java.sql.SQLException: Data size bigger

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)
[3260 byte] By [krishnakanth] at [2007-11-11 9:56:17]