Advertisement
Guest User

Untitled

a guest
Dec 19th, 2014
179
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.00 KB | None | 0 0
  1. PreparedStatement pStmt = null;
  2. ResultSet rs = null;
  3. try {
  4. String sql =
  5. " SELECT " + "ITEM_IMAGE" +
  6. " FROM " + "ITEM_IMAGES" +
  7. " WHERE " + "ITEM_CODE" + " = ? " +
  8. " FOR UPDATE";
  9. pStmt = con.prepareStatement(sql,ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_UPDATABLE);
  10. pStmt.setString(1, fileDesign.getItem_code());
  11. rs = pStmt.executeQuery();
  12. if (rs.next()) {
  13. Blob blob = rs.getBlob("ITEM_IMAGE");
  14. blob.truncate(0);
  15. blob.setBytes(1, fileDesign.getFile()); //here getFile() returns byte[] and causes exception here
  16. rs.updateBlob("ITEM_IMAGE", blob);
  17. rs.updateRow();
  18. }
  19. }
  20. finally {
  21. if(rs != null) rs.close();
  22. if(pStmt != null) pStmt.close();
  23. }
  24.  
  25. org.hibernate.exception.GenericJDBCException: error executing work
  26. at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
  27. at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
  28. at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
  29. at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:52)
  30. at org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:2001)
  31. at com.arex.cbs.dao.DesignMasterDaoImpl.saveDesignActionGifUpload(DesignMasterDaoImpl.java:432)
  32. at com.arex.cbs.service.DesignMasterManagerImpl.saveDesignActionGifUpload(DesignMasterManagerImpl.java:98)
  33. at com.arex.cbs.controller.DesignController.saveDesignActionGIF(DesignController.java:658)
  34. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  35. at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  36. at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  37. at java.lang.reflect.Method.invoke(Unknown Source)
  38. at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:175)
  39. at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:421)
  40. at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:409)
  41. at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:774)
  42. at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
  43. at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
  44. at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
  45. at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
  46. at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
  47. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
  48. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  49. at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
  50. at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
  51. at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
  52. at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
  53. at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
  54. at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
  55. at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
  56. at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
  57. at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
  58. at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
  59. at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
  60. at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1040)
  61. at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
  62. at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2441)
  63. at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2430)
  64. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  65. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  66. at java.lang.Thread.run(Unknown Source)
  67. Caused by: java.sql.SQLException: Io exception: Software caused connection abort: socket write error
  68. at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:113)
  69. at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:147)
  70. at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:257)
  71. at oracle.jdbc.driver.T4CConnection.putBytes(T4CConnection.java:2037)
  72. at oracle.sql.BLOB.setBytes(BLOB.java:742)
  73. at com.arex.cbs.dao.DesignMasterDaoImpl$3.execute(DesignMasterDaoImpl.java:450)
  74. at org.hibernate.impl.SessionImpl.doWork(SessionImpl.java:1997)
  75. ... 36 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement