Re: Transactions , Primary Keys

2007-09-23 Thread Aristedes Maniatis
On 23/09/2007, at 2:23 PM, Philip Copeland wrote: Did you have an issue committing every "several thousand records". What would you do if it failed at that stage - did you figure out a way to resume again at a known point? Handling large imports is never easy. Initially we had some memory i

RE: Transactions , Primary Keys

2007-09-22 Thread Philip Copeland
apache.org Subject: Re: Transactions , Primary Keys On 23/09/2007, at 8:26 AM, Philip Copeland wrote: > The main problem I'm facing is that objects don't get written to the > database (nor Primary Keys generated) unless we commit our > transaction. > What I'm wishing for is

Re: Transactions , Primary Keys

2007-09-22 Thread Aristedes Maniatis
On 23/09/2007, at 8:26 AM, Philip Copeland wrote: The main problem I'm facing is that objects don't get written to the database (nor Primary Keys generated) unless we commit our transaction. What I'm wishing for is a mode where all changes are made to the underlying database - but not commit