I am trying to create video files from bytes received from a database. The program worked up to several hours. After downloading a large file, when I try to restore it, it creates a java.lang.OutOfMemoryError: error java.lang.OutOfMemoryError:
My code is:
conn = prepareConnection(); StringBuilder sb=new StringBuilder(1024); sb.append("select videoname,videoid,videofull from ").append(uname.trim()).append("video"); String sql=sb.toString(); stmt = conn.prepareStatement(sql); ResultSet rs = stmt.executeQuery(); while(rs.next()){ byte[] videoData = rs.getBytes("videofull"); //#57 int vid=rs.getInt("videoid"); StringBuilder sb1 = new StringBuilder(); sb1.append(vid); String videoid=sb1.toString(); String vname=rs.getString("videoname"); File file=new File("C:/Users/JamesPJ/Documents/skypark/skypark/WebContent/sp/resources/videos/"+vname+""+videoid+".mp4"); if(file.exists() && !file.isDirectory()){ continue; } else { FileOutputStream output = new FileOutputStream(file); IOUtils.write(videoData, output); output.close(); } } request.setAttribute("uname", uname); RequestDispatcher dispatcher = request.getRequestDispatcher("/VideoList"); if(dispatcher != null) { dispatcher.forward(request, response); }
Console output:
Exception in thread "http-bio-8080-exec-3" java.lang.OutOfMemoryError: Java heap space at oracle.sql.BLOB.getBytes(BLOB.java:217) at oracle.jdbc.driver.T4CBlobAccessor.getBytes(T4CBlobAccessor.java:462) at oracle.jdbc.driver.OracleResultSetImpl.getBytes(OracleResultSetImpl.java:716) at oracle.jdbc.driver.OracleResultSet.getBytes(OracleResultSet.java:402) at skypark.VideoFileCreator.doGet(VideoFileCreator.java:57) at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:749) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:487) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:412) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:339) at skypark.VideoStream.processRequest(VideoStream.java:48) at skypark.VideoStream.doGet(VideoStream.java:64) at javax.servlet.http.HttpServlet.service(HttpServlet.java:621) at javax.servlet.http.HttpServlet.service(HttpServlet.java:728) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:931) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1004) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
Please tell me what this error says. What I need to fix in this ....... Thanks .....
user2024438
source share