Symeon is spot-on. If you use Connection Pooling your COMMON block belongs to whichever CP member (server process) which you happened to get when you used THAT pool. This can be very useful, it can also catch you out if you are not aware of it. Also remember that CP members persist after you disconnect (they are shared amongst all CP users of that pool) . After a period of time they will terminate naturally if not used.
If you only have use one CP connection at a time for a CP you may not have noticed this yet - it will however come back to bite you if you get more activity on the same CP when you hit a different CP member the next time round, You can also get bitten if you disconnect from one CP and try to use another if you don't have enough CP licenses. Always remember disconnecting from a CP does not make it go away..... Regards JayJay -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: 16 July 2008 10:49 To: [email protected] Subject: RE: [U2] UniObjects and setting up Common Block Worth noting a common block will not persist between uniobjects connections unless you use connection pooling. Rgds Symeon. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jason Rowlings Sent: 16 July 2008 03:44 To: [email protected] Subject: [U2] UniObjects and setting up Common Block Greetings by the newbie, I am an asp.net developer and a recent adopter of UniObjects to connect to our Universe database (our student records system). We are experiencing some issues with odd values returning from some IType dictionary items, which we have narrowed to the absence of initialised globalised variables in subroutine calls. In searching the forums I think it may have been referred to in Universe parlance as the "common block". I have not found a solution on the Technical Postings forums and thinking it would have to be a fairly common issue in legacy systems request a bit of advice/direction. What is the approach used to set up these global variables(common block) via UniObjects? We don't have the same issue using web service calls to the same subroutines/ITypes. We have a substantial code base that would be a nightmare to re-code, which we need to avoid. Our U2 programmers are already taxed with updating an ever changing system. regards Jason ____________________________________________________________________________ __ Jason Rowlings Phone: (03) 6324 3726 (Ext 3726) Web & Systems Officer Fax: (03) 6324 3026 (Ext 3026) Student & Academic Services MailTo:[EMAIL PROTECTED] University of Tasmania Duties: - Web Application Development ASP.NET; ASP; HTML etc - MS SQL server admin - Student Records (USRS) ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.138 / Virus Database: 270.4.11/1554 - Release Date: 7/15/2008 6:03 PM ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
