-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 
Author Message
 Post subject: Hibernate Out Of Memory Exception
PostPosted: Wed Dec 05, 2012 4:41 am 
Newbie

Joined: Wed Dec 05, 2012 3:22 am
Posts: 1
There's a database table (2000 records in it and has 2 BLOB fields).
We started to get OutOfMemory Exception from NHibernate. Is it because the record count and BLOBs? If so what can we do?

CREATE TABLE DOCUMENTS
(
ID NUMBER NOT NULL,
PARENT NUMBER,
NAME VARCHAR2(4000 BYTE),
FILENAME VARCHAR2(200 BYTE),
PATH VARCHAR2(4000 BYTE),
DESCRIPTION VARCHAR2(4000 BYTE),
REVISION VARCHAR2(32 BYTE),
DISPLAYDATE DATE,
DOCUMENTTYPE NUMBER,
PROJECT NUMBER,
DELETED NUMBER,
CREATEDBY VARCHAR2(512 BYTE),
CREATEDATE DATE,
UPDATEDBY VARCHAR2(512 BYTE),
UPDATEDATE DATE,
PO_VALUE FLOAT(126),
DATE_ORDERED DATE,
FIRST_SHP_DATE DATE,
YD_NO NUMBER,
YD_VALUE FLOAT(126),
BECHTEL_SCN_NO VARCHAR2(512 BYTE),
FILE_CONTENT BLOB,
INVOICE_DATE DATE,
DOCUMENTATION_DATE DATE,
COC_DATE DATE,
CONTRACTUAL_PAYMENT_DATE DATE,
ACTUAL_PAYMENT_DATE DATE,
FILE_CONTENT2 BLOB,
FILENAME2 VARCHAR2(200 BYTE),
ARCHIVED CHAR(1 BYTE)
)

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

Source:
mscorlib

StackTrace:
at System.String.GetStringForStringBuilder(String value, Int32 startIndex, Int32 length, Int32 capacity)
at System.Text.StringBuilder.GetNewString(String currentString, Int32 requiredLength)
at System.Text.StringBuilder.Append(String value)
at NHibernate.AdoNet.Util.SqlStatementLogger.GetCommandLineWithParameters(IDbCommand command)
at NHibernate.AdoNet.Util.SqlStatementLogger.LogCommand(String message, IDbCommand command, FormatStyle style)
at NHibernate.AdoNet.Util.SqlStatementLogger.LogCommand(IDbCommand command, FormatStyle style)
at NHibernate.AdoNet.AbstractBatcher.LogCommand(IDbCommand command)
at NHibernate.AdoNet.AbstractBatcher.Prepare(IDbCommand cmd)
at NHibernate.AdoNet.AbstractBatcher.ExecuteNonQuery(IDbCommand cmd)
at NHibernate.AdoNet.NonBatchingBatcher.AddToBatch(IExpectation expectation)
at NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session)
at NHibernate.Persister.Entity.AbstractEntityPersister.UpdateOrInsert(Object id, Object[] fields, Object[] oldFields, Object rowId, Boolean[] includeProperty, Int32 j, Object oldVersion, Object obj, SqlCommandInfo sql, ISessionImplementor session)
at NHibernate.Persister.Entity.AbstractEntityPersister.Update(Object id, Object[] fields, Int32[] dirtyFields, Boolean hasDirtyCollection, Object[] oldFields, Object oldVersion, Object obj, Object rowId, ISessionImplementor session)
at NHibernate.Action.EntityUpdateAction.Execute()
at NHibernate.Engine.ActionQueue.Execute(IExecutable executable)
at NHibernate.Engine.ActionQueue.ExecuteActions(IList list)
at NHibernate.Engine.ActionQueue.ExecuteActions()
at NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session)
at NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event)
at NHibernate.Impl.SessionImpl.Flush()
at NHibernate.Transaction.AdoTransaction.Commit()
at Data.Repositories.DocumentRepository.addDocument(Project project, DocumentType documentType, Document addingDocument) in G:\KaynakKodlar2\trunk\GENERAL\net\Docushare\Data\Repositories\DocumentRepository.cs:line 507
at Web.Private.Forms.Documentf.tqGV_RowInserting(Object sender, ASPxDataInsertingEventArgs e) in G:\KaynakKodlar2\trunk\GENERAL\net\Docushare\Web\Private\Forms\Documentf.aspx.cs:line 689


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 1 post ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.