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 session.createEntry to insert each dictionary entry. Two questions:
- Coming from a database background, best practice is to commit periodically. Is this a valid approach here? (We could have large volumes)
- So far I am only running tests. In the test, when I call
TransactionHelper.commitOrRollbackTransaction I am getting a warning: [SQLDirectory$TxSessionCleaner] Closing a sql directory session for you SQLSession[directory=<mydir>, sid=<-nnnnnnnnnnnnnn>]
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 PlatformFeature.class.
