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
