@JFinal 你好，想跟你请教个问题：Jfinal读取Oracle数据库中Blob数据时，Blob有值没事，但是Blob为空时就报错，报错信息：
[ERROR]-[Thread: http-bio-8888-exec-9]-[com.jfinal.core.ActionHandler.handle()]: /zd com.jfinal.plugin.activerecord.ActiveRecordException: java.lang.NullPointerException at com.jfinal.plugin.activerecord.Model.find(Model.java:455) at com.zdnw.model.IndexSiteInfo.findZDColumn(IndexSiteInfo.java:140) at com.zdnw.controller.ZDController.index(ZDController.java:69) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at com.jfinal.core.ActionInvocation.invoke(ActionInvocation.java:55) at com.zdnw.interceptor.IndexSiteInfoInterceptor.intercept(IndexSiteInfoInterceptor.java:11) at com.jfinal.core.ActionInvocation.invoke(ActionInvocation.java:51) at com.jfinal.plugin.activerecord.tx.TxByRegex.intercept(TxByRegex.java:60) at com.jfinal.core.ActionInvocation.invoke(ActionInvocation.java:51) at com.jfinal.plugin.activerecord.tx.TxByRegex.intercept(TxByRegex.java:60) at com.jfinal.core.ActionInvocation.invoke(ActionInvocation.java:51) at com.jfinal.plugin.activerecord.tx.TxByRegex.intercept(TxByRegex.java:60) at com.jfinal.core.ActionInvocation.invoke(ActionInvocation.java:51) at com.jfinal.plugin.activerecord.tx.TxByActionMethods.intercept(TxByActionMethods.java:57) at com.jfinal.core.ActionInvocation.invoke(ActionInvocation.java:51) at com.jfinal.core.ActionHandler.handle(ActionHandler.java:73) at com.zdnw.handler.GlobalHandler.handle(GlobalHandler.java:20) at com.jfinal.core.JFinalFilter.doFilter(JFinalFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225) 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:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) 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:1001) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.NullPointerException at oracle.sql.BLOB.getBytes(BLOB.java:344) at oracle.jdbc.driver.OracleBlobInputStream.needBytes(OracleBlobInputStream.java:181) at oracle.jdbc.driver.OracleBufferedStream.readInternal(OracleBufferedStream.java:169) at oracle.jdbc.driver.OracleBufferedStream.read(OracleBufferedStream.java:143) at oracle.jdbc.driver.OracleBufferedStream.read(OracleBufferedStream.java:132) at com.jfinal.plugin.activerecord.ModelBuilder.handleBlob(ModelBuilder.java:83) at com.jfinal.plugin.activerecord.ModelBuilder.build(ModelBuilder.java:57) at com.jfinal.plugin.activerecord.Model.find(Model.java:437) at com.jfinal.plugin.activerecord.Model.find(Model.java:453) ... 36 more
版权声明：本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
这是因为 com.jfinal.plugin.activerecord.ModelBuilder.handleBlob(Blob blog) 方法的 is = blob.getBinaryStream(); 这一行代码返回的 is 对象为 null，所以添加一个判断，当 is 为 null 时直接 return null，并且在 finally 块中也判断一下内有在 is != null 时才关闭 InputStream，具体的代码如下：
public static byte[] handleBlob(Blob blob) throws SQLException { if (blob == null) return null; InputStream is = null; try { is = blob.getBinaryStream(); if (is == null) return null; byte[] data = new byte[(int)blob.length()]; is.read(data); return data; } catch (IOException e) { throw new RuntimeException(e); } finally { if (is != null) try {is.close();} catch (IOException e) {throw new RuntimeException(e);} } }
public static byte[] handleBlob(Blob blob) throws SQLException {
if (blob == null) {
return null;
}
InputStream is = null;
try {
is = blob.getBinaryStream();
if (is == null) {
return null;
}
byte[] data = new byte[(int) blob.length()];
if (data.length <= 0) {
return null;
}
is.read(data);
return data;
} catch (IOException e) {
throw new RuntimeException(e);
} finally {
if (is != null) {
try {
is.close();
} catch (IOException e) {
throw new RuntimeException(e);
}
}
}
}