[
https://issues.apache.org/jira/browse/DERBY-5090?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13007017#comment-13007017
]
Unai Vivi commented on DERBY-5090:
----------------------------------
Hi Knut,
thank you for having a look into this.
Here is the stack trace:
java.io.IOException
at
org.apache.derby.iapi.services.io.NewByteArrayInputStream.read(Unknown Source)
at
org.apache.commons.io.input.ProxyInputStream.read(ProxyInputStream.java:99)
at java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
at java.io.BufferedInputStream.read(BufferedInputStream.java:237)
at eu.vv_tech.domo.db.Icone.costrIcone(Icone.java:90)
at eu.vv_tech.domo.db.Icone.<init>(Icone.java:127)
at org.apache.jsp.insBottone_jsp._jspService(insBottone_jsp.java:188)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.netbeans.modules.web.monitor.server.MonitorFilter.doFilter(MonitorFilter.java:393)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at
org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859)
at
org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579)
at
org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555)
at java.lang.Thread.run(Thread.java:619)
I don't know about the internals of
org.apache.derby.iapi.services.io.NewByteArrayInputStream.read(), but my guess
is that if you match the Blob with an InputStream and then (before actually
using the InputStream) you read other columns, something gets misplaced...
> Retrieving BLOB fields sometimes fails
> --------------------------------------
>
> Key: DERBY-5090
> URL: https://issues.apache.org/jira/browse/DERBY-5090
> Project: Derby
> Issue Type: Bug
> Components: JDBC, Miscellaneous
> Affects Versions: 10.7.1.1
> Environment: JDBC derby embedded driver
> Reporter: Unai Vivi
> Labels: BLOB, Ordering, exception, null, order, read
>
> This is my first issue report, so please be understanding if I'm posting the
> wrong thing, in the wrong place or in the wrong way. I just want to help. :)
> While iterating through a ResultSet, when accessing a BLOB field to read its
> contents via an InputStream, I noticed that:
> - if the current ResultSet's has been "warmed up" by retrieving another
> column first, everything it's fine;
> - if, on the other hand, you first-thing access the BLOB (and read other
> columns later), then upon reading the first byte out the InputStream bound to
> the BLOB field (ResultSet.getBinaryStream("col_name")) an IOException is
> thrown (and IOException's getMessage() method returns null).
> Following is an example, taken from a real application. The two code segments
> only differ in the fact that a SMALLINT & VARCHAR read is done before/after
> the BLOB read.
> --Working snippet--
> [...]
> icRelPath[i] = "imm" + File.separator + "ic" + "_" +
> rs.getShort("setIcone") + "_" + i + "." + rs.getString("estensione");
> AutoCloseInputStream acis = new
> AutoCloseInputStream(rs.getBinaryStream("ic" + i));
> if (rs.wasNull())
> icRelPath[i] = null;
> else
> {
> //icRelPath[i] = "imm" + File.separator + "ic" + "_"
> + rs.getShort("setIcone") + "_" + i + "." + rs.getString("estensione");
> BufferedInputStream bis = new
> BufferedInputStream(acis);
> int b = bis.read();//READS FINE
> [...]
> --Broken snippet--
> [...]
> //icRelPath[i] = "imm" + File.separator + "ic" + "_" +
> rs.getShort("setIcone") + "_" + i + "." + rs.getString("estensione");
> AutoCloseInputStream acis = new
> AutoCloseInputStream(rs.getBinaryStream("ic" + i));
> if (rs.wasNull())
> icRelPath[i] = null;
> else
> {
> icRelPath[i] = "imm" + File.separator + "ic" + "_" +
> rs.getShort("setIcone") + "_" + i + "." + rs.getString("estensione");
> BufferedInputStream bis = new
> BufferedInputStream(acis);
> int b = bis.read();//THROWS IOException WITH A null
> ERROR MESSAGE STRING
> [...]
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
