Out of Memory Exception in Devart.Data.PostgreSql, 5.0.86.0

jfarquharson · Post by **jfarquharson** » Tue 17 May 2011 17:00

We're occasionally getting out of memory exceptions when selecting data from a demographics table. The only sizable column in that table is a image, the rest is text only data and small. Here is the exception:

Message=Exception of type 'System.OutOfMemoryException' was thrown.

at Devart.Data.PostgreSql.PgSqlDataReader.e(Int32 A_0)
at Devart.Data.PostgreSql.PgSqlCommand.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords)
at Devart.Common.DbCommandBase.InternalExecute(CommandBehavior behavior, IDisposable stmt, Int32 startRecord, Int32 maxRecords, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior, Boolean nonQuery)
at Devart.Common.DbCommandBase.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)

Version: Devart.Data.PostgreSql, 5.0.86.0

Shalex · Post by **Shalex** » Wed 18 May 2011 12:33

Please refer to this thread: http://www.devart.com/forums/viewtopic.php?t=20579. It is about dotConnect for Oracle, but the same is true for dotConnect for PostgreSQL as well.