You said that you ONLY want one thread ever accessing/updating the
DB at any one time. So why I have a custom `Object' that locks your database.
class DBMethoden {
protected Object databaseLock = new Object();
...
void doFunkyPigeon() throws SQLException
{
synchronized ( databaseLock ) {
DBPool pool = DBPool.getInstance();
Connection conx = pool.acquire();
try {
funkyPigeon101( conx );
}
finally {
pool.release( conx );
}
}
}
}
--
Peter Pilgrim
Welcome to the "Me Too" generation.
---------------------------------------- Message History
----------------------------------------
From: [EMAIL PROTECTED] on 05/10/2000 15:44
Please respond to [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: Re: Synchronize method in the servlet
The reason I think I have to put static keyword for the method is because my
method is going to update the database by JDBC connection. I don't want multiple
thread updating the database at the same time.
Here is my code:
public static synchronized String assignNum(String name, String uID, String
requestType, String comment){
String rID = "";
try{
rID = db.DBinsert(name, uID, requestType, comment);
db.updateSeqNum(requestType);
} catch (Exception e) {
System.err.println(e.toString());
}
return rID;
}
Thanks for the replys.
Tiana
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
--
This e-mail may contain confidential and/or privileged information. If you are not the
intended recipient (or have received this e-mail in error) please notify the sender
immediately and destroy this e-mail. Any unauthorised copying, disclosure or
distribution of the material in this e-mail is strictly forbidden.
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
