recovery photo

[Rene Ribeiro]

Hello,

I'm trying in various ways to recover pictures, because these are in the database. I made an adjustment in code as my project.
What was missing?
I am running the servlet directly.

  public InputStream recoveryPhoto () {

        ResultSet rs = null;
        InputStream in = null;

        Conect objConect = new Conect();

        sql = "select image  from product where id = 13";
        try {

            objConect.openConectionMySQl();
            PreparedStatement stm = objConecta.con.prepareStatement(sql);
            objConecta.rs = stm.executeQuery();

            while (rs.next()) {
                Blob blob = rs.getBlob("image");
                in = blob.getBinaryStream();
            }
        } catch (SQLException ex) {
            ex.printStackTrace();

        }

        return in;
    }

  protected void doGet(HttpServletRequest request, HttpServletResponse response)
            throws ServletException, IOException {

        ProductDAO objProductDAO = new ProductDAO();

        response.setContentType("image/jpeg");
        ServletOutputStream out = response.getOutputStream();

        int tamanho = 1;
        byte[] buffer = new byte[1024 * tamanho];
        InputStream is = objProductDAO.recoveryPhoto();
        int bytesread = 0;
        while ((bytesread = is.read(buffer)) != -1) {
            out.write(buffer, 0, bytesread);
        }
        out.flush();
        out.close();
        is.close();

    }

[Dave Tolls]

What problems are you getting?

[Rene Ribeiro]

HTTP Status 500 - Internal Server Error


type Exception report

messageInternal Server Error

descriptionThe server encountered an internal error that prevented it from fulfilling this request.

exception 
java.lang.NullPointerException


note The full stack traces of the exception and its root causes are available in the GlassFish Server Open Source Edition 4.1 logs.


GlassFish Server Open Source Edition 4.1 

[Dave Tolls]

If you look in the glassfish logs you should find the stack trace.
That will tell you where in your code that NPE is occurring.

[Rene Ribeiro]

Result:

Advertência: StandardWrapperValve[servletimagem]: Servlet.service() for servlet servletimagem threw exception
java.lang.NullPointerException
at Classes.ProdutoDAO.recuperaFoto(ProdutoDAO.java:145)
at servlets.servletimagem.service(servletimagem.java:33)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1682)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:318)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:160)
at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:734)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:673)
at com.sun.enterprise.web.WebPipeline.invoke(WebPipeline.java:99)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:174)
at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:415)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:282)
at com.sun.enterprise.v3.services.impl.ContainerMapper$HttpHandlerCallable.call(ContainerMapper.java:459)
at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:167)
at org.glassfish.grizzly.http.server.HttpHandler.runService(HttpHandler.java:201)
at org.glassfish.grizzly.http.server.HttpHandler.doHandle(HttpHandler.java:175)
at org.glassfish.grizzly.http.server.HttpServerFilter.handleRead(HttpServerFilter.java:235)
at org.glassfish.grizzly.filterchain.ExecutorResolver$9.execute(ExecutorResolver.java:119)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeFilter(DefaultFilterChain.java:284)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.executeChainPart(DefaultFilterChain.java:201)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.execute(DefaultFilterChain.java:133)
at org.glassfish.grizzly.filterchain.DefaultFilterChain.process(DefaultFilterChain.java:112)
at org.glassfish.grizzly.ProcessorExecutor.execute(ProcessorExecutor.java:77)
at org.glassfish.grizzly.nio.transport.TCPNIOTransport.fireIOEvent(TCPNIOTransport.java:561)
at org.glassfish.grizzly.strategies.AbstractIOStrategy.fireIOEvent(AbstractIOStrategy.java:112)
at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.run0(WorkerThreadIOStrategy.java:117)
at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy.access$100(WorkerThreadIOStrategy.java:56)
at org.glassfish.grizzly.strategies.WorkerThreadIOStrategy$WorkerThreadRunnable.run(WorkerThreadIOStrategy.java:137)
at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:565)
at org.glassfish.grizzly.threadpool.AbstractThreadPool$Worker.run(AbstractThreadPool.java:545)
at java.lang.Thread.run(Thread.java:745)

[Rene Ribeiro]

I found the error.

While in line, had no connection to bring the resultset.

Thank you

 public InputStream recuperaFoto() {

        ResultSet rs = null;
        InputStream in = null;

        Conecta objConecta = new Conecta();

        sql = "select imagem  from produto where id = 13";
        try {

            objConecta.abreConexaoMySQl();
            PreparedStatement stm = objConecta.con.prepareStatement(sql);
            objConecta.rs = stm.executeQuery();

            while (objConecta.rs.next()) {
                Blob blob;
                blob = objConecta.rs.getBlob("imagem");
                in = blob.getBinaryStream();
            }
        } catch (SQLException ex) {
            ex.printStackTrace();

        }

        return in;
    }