The best solution will be, get the max id at the time of updation rather
than creation of the page. After the updation, you can show the id to the
user, if required.  This way, you are not restricting anybody from accessing
the page and there will be no delay at the time of updation because somebody
else has locked the table.

Best regards,

Dantus
----- Original Message -----
From: Hamid <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 17, 2001 1:44 PM
Subject: Re: Synchronization issue


> Hi,
> I have created JSP page in which it first selects max of id's from tables
,
> then inserting those max ids as new ids into tables. Now the problem i am
> getting is:
> When more than 1 concurent users hits the page, it creates the same ids
for
> all users as all r getting the same max ids before inserting. Now i want
to
> make the block in transaction as in Coldfusion/ASP. How can i do it in
JSP.
> Yours help will be regarded.
>
> Thanx
>
>
> Hamid Hassan
>
> -----Original Message-----
> From: A mailing list about Java Server Pages specification and reference
> [mailto:[EMAIL PROTECTED]]On Behalf Of Sachin S. Khanna
> Sent: Saturday, March 17, 2001 12:39 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Inner scriptlet tags
>
>
> Well <! .... > this is a jsp declaration and not a scriptlet.
> There has been a lot of discussion on the difference, use of jsp
declaration
> and scriptlets.
> All of which can be found at the mail archives of this list.
> Please help yourself as well as this list by searching for them out there.
> Have a nice day.
> With regards,
> Sachin S. Khanna.
> www.emailanorder.com
>
> ----- Original Message -----
> From: Rob L'Estrange <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, March 18, 2001 3:42 AM
> Subject: Inner scriptlet tags
>
>
> > Hi All
> >
> > I've been developing with ASP for sometime and have finally got around
to
> > checking out JSP.
> >
> > I've come across something curious. In the source code at the bottom of
> this
> > email, the highlighted code would be permissible (semantically) in ASP
but
> > is not permissible in JSP. I'm using Tomcat 3.2.
> >
> > I understand where the translator is "breaking down" and why - in short,
> the
> > translator has been built not to process scriptlet tags within a
> declaration
> > tag. And I understand that there are ways of achieving the same result,
> and
> > that not all people would see this feature as necessary. But... I have
> found
> > the technique useful in ASP development - which is the same as saying,
for
> > me at least, the technique is useful in server page development. Is
there
> a
> > good reason why JSP translators are not built to handle this kind of
> syntax?
> >
> > Thanks
> > Rob
> >
> > ==================================
> >
> > <%@ page language="Java" %>
> >
> > <%!
> >
> > private void testMethod(){
> >  /* Start: Here's the violating code. */
> >  %>
> >  <p align="center">How are you today?</p>
> >  <%
> >  /* End: The violating code. */
> > }
> >
> > %>
> >
> > <html>
> > <head>
> >  <title>Hello</title>
> > </head>
> >
> > <body bgcolor="#FFFFFF">
> >  <h1 align="center"><font face="Arial" color="#0000FF">Hello</font></h1>
> >
> >  <%
> >  testMethod();
> >  %>
> >
> > </body>
> > </html>
> >
> >
>
===========================================================================
> > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> > For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> DIGEST".
> > Some relevant FAQs on JSP/Servlets can be found at:
> >
> >  http://java.sun.com/products/jsp/faq.html
> >  http://www.esperanto.org.nz/jsp/jspfaq.html
> >  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >  http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
> >
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
> JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
> DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
>  http://java.sun.com/products/jsp/faq.html
>  http://www.esperanto.org.nz/jsp/jspfaq.html
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>  http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>

===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets

Reply via email to