It doesn't matter where you are trying to perform this action from: Servlets, an
application, SQL*Plus, whatever. Oracle sees that you are trying to violate a
constraint, and it logs it. If you want to log the error on the servlet side, you'll
have to programmatically deal with it. In other words, this is normal behaviour.
Bart Cassady
Database Analyst
Associated Engineering Group Ltd.
[EMAIL PROTECTED]
>>> Vitaly Yermolenko <[EMAIL PROTECTED]> 09/02 11:43 PM >>>
Hi!
I am using Oracle 7 with the JDBC thin driver. I have a servlet that
updates/inserts values in a tables. Sometimes inserted value of the HTML form's field
has incorrect format (Oracle's constraint CHECK is present) and after submitting this
form Oracle's alert log file logs the message, like next:
Errors in file /ora_srv/app/oracle/admin/z1/udump/ora_z1_1175.trc:
ORA-02290: check constraint (ADMSUBS.CK_FIRMS_CONTACTPHONE) violated
Is locating of the log messages like above in the Oracle's system alert_z1.log
file correct? Or, may be, this message must be in the Apache's system error.log file?
Why this message is located in the Oracle's log file?
If you can give me some explanation regarding this it will be nice...
Thanks in advance!
Regards,
Vitaly ([EMAIL PROTECTED])
___________________________________________________________________________
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
