急,用java读取sqlserver中的image!
请问各位高人,如何在sqlserver中读取一个30兆左右的image(oa_data),如果用sql语句查询image字段直接就内存溢出了
select oa_data from oa_wffiles where id=?;
pstmt.setString(1,id);
执行下面一句话已经出错了,更别提读取了,可能java虚拟机承受不了把几十兆的数据一次加载到内存里:
ResultSet rs = pstmt.executeQuery();
大家有什么解决办法
出错信息如下:
Could not execute query
2005-11-16 09:30:40,062 WARN [net.sf.hibernate.util.JDBCExceptionReporter] - SQL Error: 0, SQLState: null
2005-11-16 09:30:40,062 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] - Out of memory - please use a server side cursor for large result sets:java.lang.OutOfMemoryError, Result set size:105478288, JVM total memory size:66650112
2005-11-16 09:30:40,062 WARN [net.sf.hibernate.util.JDBCExceptionReporter] - SQL Error: 0, SQLState: null
2005-11-16 09:30:40,078 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] - Out of memory - please use a server side cursor for large result sets:java.lang.OutOfMemoryError, Result set size:105478288, JVM total memory size:66650112
2005-11-16 09:30:40,078 ERROR [net.sf.hibernate.util.JDBCExceptionReporter] - Could not execute query
com.jnetdirect.jsql.u: Out of memory - please use a server side cursor for large result sets:java.lang.OutOfMemoryError, Result set size:105478288, JVM total memory size:66650112