timeout - NHibernate command_timeout does not work with batches -

-

today experienced issue timeouts.

i have following configuration used create sessionfactory: 

 <property name="adonet.batch_size">50</property>  <property name="command_timeout">600</property>

i not store in web.config in xml file manually passed configuration:

configuration.configure(cfgfile)

thus can have multiple session factories (per database) independent configurations.

but command_timeout seems effective when nhibernate not using batches. if sql commands batched large batches get:

nhibernate.exceptions.genericadoexception: not execute batch command. [sql: sql not available] ---> system.data.sqlclient.sqlexception: timeout expired.  timeout period elapsed prior completion of operation or server not responding.

while googling solution, found article explains why happening: http://ronaldrosiernet.azurewebsites.net/blog/2013/04/20/timeout_in_nhibernate_batched_sessions

the cause of problem sql batching nhibernate using cfg.environment.commandtimeout instead of command_timeout passed configuration when creating session.

i found way implement workaround when creating configuration:

if (configuration.properties.containskey(nhibernate.cfg.environment.commandtimeout))     nhibernate.cfg.environment.properties[nhibernate.cfg.environment.commandtimeout] =              configuration.properties[nhibernate.cfg.environment.commandtimeout];

and colleagues timeout seems fixed now.

but confuses me following thread: https://forum.hibernate.org/viewtopic.php?f=25&t=983105

which says:

the property nhibernate.cfg.environment.properties returns copy of global properties, cannot modify it.

if nhibernate.cfg.environment.properties read-only copy, why workaround seems working fine? stable or maybe fix unreliable , might break in other cases?

and found related issue in nhibernate jira: https://nhibernate.jira.com/browse/nh-2153

if fixed issues command_timeout in v3.1.0., why still have use workaround in nhibernate v3.3.2. ?

does have insight on this?

i had same issue when using batches. nhibernate class sqlclientbatchingbatcher using command timeout environment.globalproperties read only. found 2 ways set timeout on sqlclientbatchingbatcher.currentbatch command

1) use timeout in app.config file 

<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">   <session-factory>     <property name="command_timeout">120</property>   </session-factory> </hibernate-configuration>

2) set environment.

fieldinfo field = typeof(global::nhibernate.cfg.environment).getfield("globalproperties", system.reflection.bindingflags.nonpublic |                                     system.reflection.bindingflags.static); dictionary<string, string> gloablproperties = field.getvalue(null) dictionary<string, string>; gloablproperties.add("command_timeout","120");

Comments

Post a Comment

Popular posts from this blog

java - Jmockit String final length method mocking Issue -

-
using jmockit 1.2 jar, trying mock string's length method getting unexpected invocation exception: failed: test java.lang.illegalstateexception: missing invocation mocked type @ point; please make sure such invocations appear after declaration of suitable mock field or parameter @ stringdemo.testa$1.<init>(testa.java:17) @ stringdemo.testa.test(testa.java:13) i using testng: @test public void test() throws exception { new expectations() { @mocked("length") string astring; { astring.length(); result = 2; } }; system.out.println(a.showa("test")); } } actual class a: public class { public static int showa(string str){ int a= str.length(); return a; } } this wrong way of recording expected results. shouldn't mock , record string's length() method, record showa() instead. here solution @suppresswarnings("unused...
Read more

What is the difference between data design and data model(ERD) -

-
i have google question , find answer in day. know, data design many many table have list column,and mark pk , fk. why er-diagram have find this? data design process of designing database. main output of data design detailed logical data model of database. some people data design includes of needed logical , physical design choices , physical storage parameters needed generate design in data definition language. technically, database analysis, database analysts (dbas) trained do. while person can both data design , database analysis, these 2 different tasks. data design models data. database analysis takes model , applies 1 or more database engines (relational, hierarchical, nosql). a logical data model 1 of main outputs of data design. data model represented entity relationship diagram, or er diagram.
Read more

ios - Can NSManagedObject conform to NSCoding -

-
i need transfer single object across device. right converting nsmanagedobject dictionary , archiving , sending nsdata. upon receiving unarchiving it. transfer nsmanagedobject archiving , unarchiving instead of creating intermediate data object. @interface test : nsmanagedobject<nscoding> @property (nonatomic, retain) nsstring * title; @end @implementation test @dynamic title; - (id)initwithcoder:(nscoder *)coder { self = [super init]; if (self) { self.title = [coder decodeobjectforkey:@"title"]; //<crash } return self; } - (void)encodewithcoder:(nscoder *)coder { [coder encodeobject:self.title forkey:@"title"]; } @end nsdata *archivedobjects = [nskeyedarchiver archiveddatawithrootobject:testobj]; nsdata *objectsdata = archivedobjects; if ([objectsdata length] > 0) { nsarray *objects = [nskeyedunarchiver unarchiveobjectwithdata:objectsdata]; } the problem above code is. crashes @ self.title in initwithcoder sa...
Read more