Hi again,
It's a standalone application. Im writing a e-commerce
web site for my final year project. I have tomcat
running on my machine.It is the only application open.
Do u know what i mean?
Basically, one page pulls columns from a table and
puts this information in forms so the user can edit
the information on the web page. When the user hits
the update button, the Update.jsp page is invoked and
this pages tries updating the table with the values in
the forms. But i keep getting that error message
saying the data base is locked by the user who pulled
the values from the table in the first page. Get me?
Confusing stuff, i know.
Let me know if you know anymore on this, and thanks
for helping.
Cheers
Rui
--- Shawn Zhu <[EMAIL PROTECTED]> wrote:
> close your admin application that's using your
> Access
> database on machine 'RUI'.
>
> > -----Original Message-----
> > From: Justin Owens [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, May 07, 2001 9:05 AM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Database locked?
> >
> >
> > You are running into a deadlock. You are try to
> access
> > records/tables that
> > are locked by the database. There are a couple of
> ways to
> > remedy this. The
> > first one is to close your first connection and
> recordset. By closing
> > these, it should free up resources. I am not sure
> of the
> > syntax or if you
> > can do this in java/jsp as I have just started
> learning (my
> > experience comes
> > from ASP programming), it sounds like a readonly
> lock on the database.
> > There should be richer lock types than this.
> >
> > Justin
> >
> > -----Original Message-----
> > From: A mailing list about Java Server Pages
> specification
> > and reference
> > [mailto:[EMAIL PROTECTED]]On Behalf Of
> Ruaidhrm Fernandes
> > Sent: Monday, May 07, 2001 10:33 PM
> > To: [EMAIL PROTECTED]
> > Subject: Database locked?
> >
> >
> > Hi all,
> > I'm getting an error saying :
> > java.sql.SQLException: [Microsoft][ODBC Microsoft
> > Access 97 Driver] Couldn't update; currently
> locked by
> > user 'admin' on machine 'RUI'.
> >
> > What my program does is,I have a JSP page that
> opens a
> > connection with the database and retrieves fields
> from
> > a products table in my database and stores them in
> > forms. This allows users to edit/delete/add
> entries to
> > the database. When the user clicks the submit
> button
> > it should invoke the Updatetable.jsp page.
> > The Updatetable.jsp page creates another
> connection
> > and either updates/deletes/adds entries to the
> same
> > products table depending on what the users choice
> was.
> > When I click the submit button, i get the error at
> the
> > top of this e-mail.
> > Does anyone know why this is happening?
> > Thanks Rui
> >
> > =====
> > "If a rabbit's foot is so lucky,..... what
> happened to the rabbit?"
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Auctions - buy the things you want at great
> prices
> > http://auctions.yahoo.com/
> >
> >
>
==============================================================
> > =============
> > 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
=====
"If a rabbit's foot is so lucky,..... what happened to the rabbit?"
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
===========================================================================
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
