Re: .NET Managed Provider
Abhi and others: Thanks for the post - one of your colleagues also e-mailed me with the PDF documentation, which was very helpful. The GA version looks just like our beta copy in terms of file date/timestamps. Overall, it works great. However, we've run into a problem when trying to use it with a multithreaded application. Here the scenario... I am using a thread pool, with 15 max threads - this isn't the built-in thread pool, but is an implementation based on a posting on GotDotNet - see Stephen Toub's posting at http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=44f8045b-81ad-4cd8-a153-4acbec7c2cfd . Within each unit of work (which runs within a thread managed by the thread manager class) I make several calls(selects,inserts,deletes) to the database. Everything runs fine until nearing the end of the process when all the remaining active threads seem to hang. If I pause the application and look at the "Threads" window I notice that IBM.Data.Informix.CMDWrapper.DismissStatement is listed along with some of my other active threads, leading me to believe that there some type of deadlocking issue. One thing to not...there are other threads in a waiting state, and it seems as if it only happens when there are some available threads. The same exact code works fine using ODBC. I'm hoping someone has seen this behavior or is familiar with any known issues with multi-threaded apps using the new provider. One other note - this implementation runs as a Windows Service, not in ASP.NET - not sure if that makes a difference, but as a service, the app should behave pretty much like a WinForm application, so there are some differences there. Thanks all - look forward to any feedback. I'll also log a call with tech support unless someone on the group knows about this issue. Abhishek Mathur <abhishek@us.ibm.com> wrote in message news:<c2si37$h45$1@terabinaries.xmission.com>... > Hi, > You should be able to get Informix .NET provider with CSDK > 2.81.TC3 which can be downloaded from the following location - > http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxdl > > Cheers, > Abhi. > -------------------------------------------------------------------- > There are 10 kinds of people,,,,, > .... those who understand binary notations, and those who don't. > -------------------------------------------------------------------- > > > > > eric@fakeisp.net (-=Eric=-) > Sent by: owner-informix-list@iiug.org > 03/11/2004 10:37 PM > Please respond to > eric > > > To > informix-list@iiug.org > cc > > Subject > .NET Managed Provider > > > > > > > Does anyone know when the .NET managed provider for Informix will be > released? > > We're working with a beta right now, but running into a few bugs. > ODBC refuses to connection pool, among other problems, so the managed > provider is our only hope. > Have an open case with tech support (which was fast and > professional!), but I was previously told that the provider would be > released end of Feb. - haven't heard anything and can't find anything > on IBM's site... > > > sending to informix-list
Hi, a managed .NET Provider for Informix can be downloaded from http://www.openlinksw.com Details about this Provider can be found at http://www.openlinksw.com/info/docs/uda51/mt/dnetarch.html If you have any questions please send me a mail. Kind Regards, Jan Csisko Professional Services Consultant OpenLink Software Web: http://www.openlinksw.com Product Weblogs: Virtuoso: http://www.openlinksw.com/weblogs/virtuoso UDA: http://www.openlinksw.com/weblogs/uda Universal Data Access & Virtual Database Technology Providers eric@fakeisp.net (-=Eric=-) wrote in message news:<239f0f07.0403171435.45cbce5f@posting.google.com>... > Abhi and others: > > Thanks for the post - one of your colleagues also e-mailed me with the > PDF documentation, which was very helpful. The GA version looks just > like our beta copy in terms of file date/timestamps. Overall, it > works great. > > However, we've run into a problem when trying to use it with a > multithreaded application. > Here the scenario... > I am using a thread pool, with 15 max threads - this isn't the > built-in thread pool, but is an implementation based on a posting on > GotDotNet - see Stephen Toub's posting at > http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=44f8045b-81ad-4cd8-a153-4acbec7c2cfd > . Within each unit of work (which runs within a thread managed by the > thread manager class) I make several calls(selects,inserts,deletes) to > the database. Everything runs fine until nearing the end of the > process when all the remaining active threads seem to hang. If I pause > the application and look at the "Threads" window I notice that > IBM.Data.Informix.CMDWrapper.DismissStatement is listed along with > some of my other active threads, leading me to believe that there some > type of deadlocking issue. One thing to not...there are other threads > in a waiting state, and it seems as if it only happens when there are > some available threads. > > The same exact code works fine using ODBC. I'm hoping someone has > seen this behavior or is familiar with any known issues with > multi-threaded apps using the new provider. > > One other note - this implementation runs as a Windows Service, not in > ASP.NET - not sure if that makes a difference, but as a service, the > app should behave pretty much like a WinForm application, so there are > some differences there. > > Thanks all - look forward to any feedback. I'll also log a call with > tech support unless someone on the group knows about this issue. > > > Abhishek Mathur <abhishek@us.ibm.com> wrote in message news:<c2si37$h45$1@terabinaries.xmission.com>... > > Hi, > > You should be able to get Informix .NET provider with CSDK > > 2.81.TC3 which can be downloaded from the following location - > > http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxdl > > > > Cheers, > > Abhi. > > -------------------------------------------------------------------- > > There are 10 kinds of people,,,,, > > .... those who understand binary notations, and those who don't. > > -------------------------------------------------------------------- > > > > > > > > > > eric@fakeisp.net (-=Eric=-) > > Sent by: owner-informix-list@iiug.org > > 03/11/2004 10:37 PM > > Please respond to > > eric > > > > > > To > > informix-list@iiug.org > > cc > > > > Subject > > .NET Managed Provider > > > > > > > > > > > > > > Does anyone know when the .NET managed provider for Informix will be > > released? > > > > We're working with a beta right now, but running into a few bugs. > > ODBC refuses to connection pool, among other problems, so the managed > > provider is our only hope. > > Have an open case with tech support (which was fast and > > professional!), but I was previously told that the provider would be > > released end of Feb. - haven't heard anything and can't find anything > > on IBM's site... > > > > > > sending to informix-list