nefarious986 Posted December 27, 2007 Share Posted December 27, 2007 Ok, I am a little confused here, maybe you guys can clear it up. What I am trying to do is create a db abstraction class that allows EACH user ONE db connection. How I was planning to go about this is to create ONE connection to the db, then store it in a static variable of Connection class. Then, the class would not create any more connections if the static variable was a resource object. Singleton pattern basically. BUT .. I m not too sure about static variables. Would ALL instances of that class share that value ? In another word, would ALL users on my sites be sharing the SAME connection if I used a static variable to store the connection object ? Any thoughts guys? Kinda hard to test for multiple connections since I am one developer. LOL. Quote Link to comment Share on other sites More sharing options...
trq Posted December 27, 2007 Share Posted December 27, 2007 BUT .. I m not too sure about static variables. Would ALL instances of that class share that value ? In another word, would ALL users on my sites be sharing the SAME connection if I used a static variable to store the connection object ? No. Each user (request) would get there own single connection resource. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.