Tenho uma aplicação WEB que possui um janela que alem de trazer os dados cadastrais dos clientes, exibe também as fotos, e o estranho é que a primeira vez que clico no botão que detalha os clientes, sempre que esse tem foto ele dá um erro, aí é necessário eu fazer um logoff e entrar na aplicação novamente, aí repito o processo e tudo flui normalmente.As fotos estão armazenadas em um BD Oracle 10G, Data Type BLOB
INFO: Server startup in 1563 ms
ERRO ACTION EXIBIRFOTO.DO -> Violação de protocolo
[color=red]java.sql.SQLException: Exceção de E/S: Invalid Packet Lenght[/color]
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:389)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:413)
at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:119)
at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:92)
at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:950)
at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:802)
at com.biosystem.utils.SQLUtils.getRowCount(SQLUtils.java:43)
at com.biosystem.vlh.VLH.open(VLH.java:117)
at com.biosystem.vlh.VLH.open(VLH.java:112)
at com.biosystem.bd.Compra_ItensBD.open(Compra_ItensBD.java:112)
at com.biosystem.bd.Compra_ItensBD.open(Compra_ItensBD.java:96)
at com.biosystem.bd.Compra_ItensBD.open(Compra_ItensBD.java:92)
at com.biosystem.ui.actions.Compra_Itenss.processDataGrid(Compra_Itenss.java:132)
at com.biosystem.ui.actions.Compra_Itenss.process(Compra_Itenss.java:190)
at com.biosystem.ui.actions.Compra_Itenss.execute(Compra_Itenss.java:195)
at br.com.modsoft.actions.ActionServlet.doProcess(ActionServlet.java:175)
at br.com.modsoft.actions.ActionServlet.doGet(ActionServlet.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:619)
[color=red]java.sql.SQLException: Tamanho de tipo maior que o Máximo[/color]
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160)
at oracle.jdbc.ttc7.MAREngine.buffer2Value(MAREngine.java:2753)
at oracle.jdbc.ttc7.MAREngine.unmarshalUB4(MAREngine.java:1290)
at oracle.jdbc.ttc7.TTIoer.unmarshal(TTIoer.java:114)
at oracle.jdbc.ttc7.Oopen.receive(Oopen.java:117)
at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java:586)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:385)
at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:413)
at oracle.jdbc.driver.OraclePreparedStatement.<init>(OraclePreparedStatement.java:119)
at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:944)
at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:857)
at com.biosystem.vlh.VLH.getResultSet(VLH.java:96)
at com.biosystem.vlh.VLH.open(VLH.java:120)
at com.biosystem.vlh.VLH.open(VLH.java:112)
at com.biosystem.bd.Compra_ItensBD.open(Compra_ItensBD.java:112)
at com.biosystem.bd.Compra_ItensBD.open(Compra_ItensBD.java:96)
at com.biosystem.bd.Compra_ItensBD.open(Compra_ItensBD.java:92)
at com.biosystem.ui.actions.Compra_Itenss.processDataGrid(Compra_Itenss.java:132)
at com.biosystem.ui.actions.Compra_Itenss.process(Compra_Itenss.java:190)
at com.biosystem.ui.actions.Compra_Itenss.execute(Compra_Itenss.java:195)
at br.com.modsoft.actions.ActionServlet.doProcess(ActionServlet.java:175)
at br.com.modsoft.actions.ActionServlet.doGet(ActionServlet.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:619)