haha...it's only confusing when you describe it.
put it in simple words (I think what's you've been trying to describe):
1. your app is the only app
that's accessing the DB;
2. you are trying to do read/write to the DB
3. you get table is locked error.
Solution:
someone has suggested,
1. close your DB connection after trieving the records.
2. reopen your db connection to update a record
> -----Original Message-----
> From: Ruaidhrí Fernandes [mailto:[EMAIL PROTECTED]]
> Sent: Monday, May 07, 2001 5:04 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Database locked?
>
>
> 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
>
===========================================================================
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
