https://connect.hyland.com/t5/nuxeo-forum/closing-a-sql-directory-session-for-you/m-p/323812#M10813 <P>I am writing code to load a dictionary from a CSV. (Have to implement some custom functionality.) I am looping through the CSV and have code to commit every 10,000 rows. I'm using <CODE>session.createEntry</CODE> to insert each dictionary entry. Two questions:</P> <OL> <LI>Coming from a database background, best practice is to commit periodically. Is this a valid approach here? (We could have large volumes)</LI> <LI>So far I am only running tests. In the test, when I call <CODE>TransactionHelper.commitOrRollbackTransaction</CODE> I am getting a warning: <CODE>[SQLDirectory$TxSessionCleaner] Closing a sql directory session for you SQLSession[directory=&lt;mydir&gt;, sid=&lt;-nnnnnnnnnnnnnn&gt;]</CODE></LI> </OL> <P>On entry into the loop I am checking to see if a transaction is active. If not, I create one. However, on entry into the loop it appears that a transaction is always active. I am only using one <CODE>PlatformFeature.class</CODE>.</P> Thu, 16 Mar 2017 12:22:44 GMT Eric_Ace 2017-03-16T12:22:44Z https://connect.hyland.com/t5/nuxeo-forum/closing-a-sql-directory-session-for-you/m-p/323812#M10813 <P>I am writing code to load a dictionary from a CSV. (Have to implement some custom functionality.) I am looping through the CSV and have code to commit every 10,000 rows. I'm using <CODE>session.createEntry</CODE> to insert each dictionary entry. Two questions:</P> <OL> <LI>Coming from a database background, best practice is to commit periodically. Is this a valid approach here? (We could have large volumes)</LI> <LI>So far I am only running tests. In the test, when I call <CODE>TransactionHelper.commitOrRollbackTransaction</CODE> I am getting a warning: <CODE>[SQLDirectory$TxSessionCleaner] Closing a sql directory session for you SQLSession[directory=&lt;mydir&gt;, sid=&lt;-nnnnnnnnnnnnnn&gt;]</CODE></LI> </OL> <P>On entry into the loop I am checking to see if a transaction is active. If not, I create one. However, on entry into the loop it appears that a transaction is always active. I am only using one <CODE>PlatformFeature.class</CODE>.</P> Thu, 16 Mar 2017 12:22:44 GMT https://connect.hyland.com/t5/nuxeo-forum/closing-a-sql-directory-session-for-you/m-p/323812#M10813 Eric_Ace 2017-03-16T12:22:44Z