I understand that a Singleton can only have one instance at any given time.
My question is can multiple threads use the same instance? If so what are the thread-safety issues with this? specifically:
1- Would class static variables be shared amongst the threads?
2- Would local variables to non staic methods be shared amongst the threads?
The reason I ask this is because I have designed a Data Access Facade Layer as a singleton. During instantiation it would initialize the data source, as I don't want it to be initialized more than once. Then I have member methods (instance methods) which perform insert, select, update ...etc to the database. Each of those methods gets its own connection, statement, resultset ...etc
Was just wondering if the above has any thread safety issues as it will be used by multiple threads.
Thanks for replying in advance
P.S. The above class will be running in Tomcat and called from a servlet, not sure if this is relevent.