Hi,
I'll try that.
thanks for the help.
Rui
--- Shawn Zhu <[EMAIL PROTECTED]> wrote:
> 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
> > > >
> > >
> > >
>
=== message truncated ===
=====
"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
