JDBC 2005 Driver

Hi guys,
I'm finding that if I run a query that returns a large amount of data I get
java heap crashes. I have already set the jvm heap size but it's made no
difference.

Below is an exception trace - any comments appreciated!

Thanks
Shane
<<
Caused by: java.lang.OutOfMemoryError: Java heap space
at java.nio.HeapByteBuffer.<init>(HeapByteBuffer.java:39)
at java.nio.ByteBuffer.allocate(ByteBuffer.java:312)
at sun.nio.cs.StreamDecoder$CharsetSD.<init>(StreamDecoder.java:378)
at sun.nio.cs.StreamDecoder$CharsetSD.<init>(StreamDecoder.java:358)
at sun.nio.cs.StreamDecoder.forInputStreamReader(StreamDecoder.java:74)
at java.io.InputStreamReader.<init>(InputStreamReader.java:83)
at com.microsoft.sqlserver.jdbc.DDC.convertNonUnicodeNonPLPToObject(Unknown
Source)
at com.microsoft.sqlserver.jdbc.ServerDTVImpl.getValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.DTV.getValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.Column.getValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.Column.getValue(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getObject(Unknown Source)
at
org.apache.commons.dbcp.DelegatingResultSet.getObject(DelegatingResultSet.java:287)
at
aam.spring.SpringBeanContextHelperImpl.populateBeanFromResultSet(SpringBeanContextHelperImpl.java:110)
at
aam.spring.SpringBeanContextHelperImpl.populateBeanFromResultSet(SpringBeanContextHelperImpl.java:138)
at
aam.calypso.prototype.dao.MethodCallBackImpl.callback(MethodCallBackImpl.java:55)
at
aam.calypso.prototype.dao.RowCallBackHandlerImpl.processRow(RowCallBackHandlerImpl.java:3
at
org.springframework.jdbc.core.JdbcTemplate$RowCallbackHandlerResultSetExtractor.extractData(JdbcTemplate.java:1250)
at
org.springframework.jdbc.core.JdbcTemplate.processResultSet(JdbcTemplate.java:1035)
at
org.springframework.jdbc.core.JdbcTemplate.extractReturnedResultSets(JdbcTemplate.java:953)
at
org.springframework.jdbc.core.JdbcTemplate$5.doInCallableStatement(JdbcTemplate.java:924)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:882)
at org.springframework.jdbc.core.JdbcTemplate.call(JdbcTemplate.java:914)
at
org.springframework.jdbc.object.StoredProcedure.execute(StoredProcedure.java:113)
>>

Hi Shane,

If you need to retrieve a very large column value, then you should use one
of the ResultSet getter methods that returns a stream: getAsciiStream,
getBinaryStream, or getCharacterStream.

It looks like you are using the v1.2 JDBC driver CTP, so you'll also want
to enable adaptive response buffering to minimize memory usage (e.g. set
"responseBuffering=adaptive" in the connection properties). See
http://blogs.msdn.com/jdbcteam/archive/2007/05/02/what-is-adaptive-response-
buffering-and-why-should-i-use-it.aspx for more details on its usage and
restrictions.

Regards,
--David Olix [MSFT]