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: Help saving large number of objects...
PostPosted: Thu Oct 06, 2011 12:24 pm 

Joined: Mon Apr 25, 2011 5:13 pm
Posts: 5
I am writing an application that incorporates NHibernate.

The load times and everything appear to be well within reason from my initial configuration. However, I am trying to perform a stress test for more of a worse case scenario for the application. This stress test has bumped up the number of objects substantially and I am now saving 3 classes: 2400 Intersections, 9600 Zones, and 5000 Vehicles.

My problem I am running across is trying to save the items to the database for the first time. I create all the items and then attempt to save them via:

using (var tx = session.BeginTransaction())
    foreach (Vehicle veh in Program.data.Vehicles.list)
    //  Commit transactions

However, I keep running across a:

System.StackOverflowException was unhandled Message: An unhandled exception of type 'System.StackOverflowException' occurred in System.Data.dll

I have tried adding a counter to call Flush every 10 iterations through the loop. The problem is that the Vehicle contains a list of Zones and the Zone contains a list of Vehicles. It just so happens that every vehicle has a list of every zone and vice versa. So calling the first session.Save is not only saving the first Vehicle, but queuing up the saving of every Zone, which in turns saves all the Vehicles.

I have the Zone list in the Vehicle set to inverse = false; therefore, it is saving all the Zones that are in the Vehicle list if they don't exist.

Is there any way to tell NHibernate to commit the changes ever so often so I don't hit the StackOverflowException? I tried adding a counter to Flush the session every 10 saves, but I hit the overflow exception before it ever reaches this. When it saves the first Vehicle, it is saving every Zone. Since every zone contains every Vehicle it is saving every vehicle. I never hit the flush before I get the overflow exception.

I'd really like to be able to just call save on the Vehicle and it cascade the save to the Zone. It will save me a lot of time from having to iterate through both the Zone list and then retouching the Zone again when I save the Vehicle.

If you need to see the mappings to give me better advice let me know and I'll post them.

It appears to be choking on the tx.Commit(). Any help getting this resolved would be greatly appreciated.

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.