Sounds like your code is submitting the record to the database twice. If the
data is already there when you checked, the code found it there when it
tried to submit, hence the error.
-----Original Message-----
From: Chris Econn [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 27, 2001 8:05 PM
To: [EMAIL PROTECTED]
Subject: Re: Tricky error!
Can you provide the source code?
--- Ravi Shankar Jagarapu <[EMAIL PROTECTED]>
wrote:
> Hi,
>
> I am trying to save a form ( get method) into the
> oracle database.
>
> I have the first column (varchar) as primary key.
>
> Now when I submit the form, I get a html page
> outputted by the servlet showing the data is
> commited.
>
> When I see the source code of the page, though, I
> get
> ---------- SQLException caught ----------
> Error Message: ORA-00001: unique constraint
> (SCOTT.MODULES_PK) violated
>
> SQLState: 23000
> Vendor: 1
>
> However, this happens, though I give a unique value
> for the primary column.
>
> What I don't understand is, why is the source code
> showing the SQLException?
>
> I have queried the database and it shows, the data I
> had submitted through the form.
>
> -- Ravi.
>
> __________________________________________________
> Do You Yahoo!?
> Get personalized email addresses from Yahoo! Mail
> http://personal.mail.yahoo.com/
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED]
> and include in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives:
>
http://archives.java.sun.com/archives/servlet-interest.html
> Resources:
>
http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help:
http://www.lsoft.com/manuals/user/user.html
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
