Look here: http://www.nhforge.org/doc/nh/en/index.html#configuration-hibernatejdbc
Table 3.1 provides the valid values. It is specified in the connections settings as <add key="connection.isolation" value="ReadUncommitted"/> There's also command_timeout which you might want to set for your service. See the link above. -Markus 2009/6/20 Cesar Sanz <[email protected]> > Hello, I've read this thread that touch this same problem > > http://groups.google.com/group/castle-project-users/browse_thread/thread/e81a71b546266449/ead3853cd6d620a6?lnk=raot > > and sorry about the question, but where do I specifiy that Transaction > Isolation? > > ----- Original Message ----- > *From:* Markus Zywitza <[email protected]> > *To:* [email protected] > *Sent:* Saturday, June 20, 2009 11:00 AM > *Subject:* Re: Active Record Bulk Insert > > Hi > > 2009/6/20 Cesar Sanz <[email protected]> > >> >> >> Question: >> *********** >> The table that I am inserting in is being monitored by another process ( a >> service), but I see the table is locked when inserting >> and my services is reading the table each 2 seconds. >> >> What kind of problem will I have in these scenarios: >> >> 1. If I am inserting, will my service be hang? >> 2. If I am reading the table from my sevice, will my insertion fails? >> *********** >> > > Generally it depends on the isolation level. If you have default > (read-committed) and have uncommitted changes (which you have, because > IDENTITY-fields require to call insert immediately, then SQL-Server blocks > other connections from reading the table. The service will therefore > eventually get a timeout when you are inserting some 60,000 records (as the > default timeout is 30 seconds). > If it is a separate application inserting the data, you can change the > transaction isolation to read-uncommited. Then the service can read the > table at any time. > > -Markus > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
