Yes my mistake the `databaseLock' has to be static because the method
is static method and cannot there access a non-static individual attribute.
--
Peter Pilgrim
Welcome to the "Me Too" generation.
---------------------------------------- Message History
----------------------------------------
From: [EMAIL PROTECTED] on 10/10/2000 08:29
Please respond to [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
cc:
Subject: Re: Synchronize method in the servlet
Hi,
I tried this but it doesnt work if I dont declare the databaseLock as
static. Do I need to declare it as static ?
BTW: The databaseLock is just an example of code. You might have
another a class and a method that provides the lock for you as
a single point of accessing the database.
synchronized ( DBPool.getDatabaseLock() ) {
..
}
PS: Most database will provide locking of tables implicity,
integrity of information, otherwise it is __not__ a DB. So
the above in general is not required.
Thanx and Regards,
Raj
----- Original Message -----
From: Peter Pilgrim
To: [EMAIL PROTECTED]
Sent: Friday, October 06, 2000 3:56 PM
Subject: Re: Synchronize method in the servlet
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
___________________________________________________________________________
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
