RE: Multiple result sets and XML parameters for stored procedures

[Andrea Tassinari <an...@i-mconsulting.com>]

Hello,

I had the same issue and I came out with this (It was very hard to find):

ISqlMapper _mapper = null;
..
ConfigureHandler handler = new ConfigureHandler(Configure);
DomSqlMapBuilder builder = new DomSqlMapBuilder();
_mapper = builder.ConfigureAndWatch(configFilePath, handler);

//this is the juicy line!
_mapper.SessionStore = new HybridWebThreadSessionStore(_mapper.Id);



Hope this helps

Regards,
Andrea

At 15.19 16/10/2007, Vincent Apesa wrote:

>Hello All,
>  I hope one of you has come across this problem and can provide some insight.
> 
>I am attempting to run a process using an thread after a user clicks a button in our web application. The process takes a long time so kicking it off and doing something else is good.
> 
>When I attempt to run the process Ibatis throw the following exception:
>WebSessionStore: Could not obtain reference to HttpContext at IBatisNet.DataAccess.SessionStore.WebSessionStore.ObtainSessionContext()
>at IBatisNet.DataAccess.SessionStore.WebSessionStore.get_LocalSession()
>at IBatisNet.DataAccess.Configuration.DaoProxy.Intercept(IInvocation invocation, Object[] arguments)
> 
>Any help would be great!
>thanks,
>Vince
>
>
>----------
>Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare! <http://onecare.live.com/standard/en-us/purchase/trial.aspx?s_cid=wl_hotmailnews>Try now! 
>
>No virus found in this incoming message.
>Checked by AVG Free Edition. 
>Version: 7.5.488 / Virus Database: 269.14.12/1072 - Release Date: 15/10/2007 17.55