jdbc auto commit driver depend autocommit set connect creat pool 
properti avail check properti avail properti paramet bean 
check valu collect valu properti size 
paramet present check paramet object present 
paramet present check paramet object present exampl usag paramet present prepend employe type paramet present 
iter attribut prepend overrid sql prepend statement option 
reus sql fragment write sql map encount duplic fragment sql exampl claus constraint statement ibati offer simpl power tag reus sake simplic let assum want item want count normal write like select id select item count result select count total item parentid select select id select item result item select id item parentid select elimin duplic us tag sql includ sql tag contain fragment reus includ tag includ fragment statement exampl sql id select item fragment item parentid sql select id select item count result select count total includ refid select item fragment select select id select item result item select id includ refid select item fragment select includ tag namespac awar refer fragment locat map wai ibati load sql map includ fragment load includ statement fragment includ process queri execut paramet us sql id select item fragment item parentid valu sql select id select item count paramet result select count total includ refid select item fragment select select id select item paramet result item select id includ refid select item fragment select 
soft refer type reduc likelihood run memori result current us memori need object aggress refer type regard memori alloc unavail import object 
serializ read write cach agre cach session describ offer littl benefit global applic perform type read write cach offer perform benefit entir applic just session serializ read write cach cach differ instanc copi cach object session session safe modifi instanc return realiz differ semant usual expect instanc return cach ll differ note object store serializ cach serializ mean difficulti us lazi load featur combin serializ cach lazi proxi serializ best wai figur combin cach lazi load tabl join simpli us serializ cach set read serial cach model read non serializ read cach serial benefit 
automat transact us explicit transact highli recommend simplifi semant us simpl requir gener read explicitli demarc transact us start transact commit transact end transact method call automat execut statement outsid transact block demonstr exampl reader reader resourc resourc reader com ibati exampl sql map config xml sql map client sql map sql map client builder build sql map reader updat item descript item id descript sql except item item item sql map queri object item item id item set descript tx transact demarc transact automat impli sql map updat updat item item item set descript descript item set descript tx transact demarc transact automat impli sql map updat updat item item sql except sql except stack trace note care us automat transact attract run troubl unit work requir singl updat databas exampl second updat item fail item descript updat descript tx transact behavior 
jta transact manag us jta global transact sql map activ includ wider scope transact possibl involv databas transact resourc configur requir user transact properti set locat user transact jndi resourc jndi datasourc exampl exampl configur 
extern allow manag transact configur data sourc transact commit roll framework lifecycl mean applic extern data mapper manag transact set us non transact databas read 
configur configur sql map trivial creat sql map xml definit file sql map configur file discuss sql map client instanc built us sql map client builder primari method name build sql map build sql map method simpli take reader instanc read content sql map config xml necessarili name resourc com ibati exampl sql map config xml reader reader resourc resourc reader resourc sql map client sql map sql map client builder build sql map reader 
