Here's an odd one - I've got two instances where an error was, at the same time,
caught and handled by cfcatch, and NOT-CAUGHT and hit the CFserver.
I'll put the shorter of the two examples below - one is the application.log file
entry, and the other is our logging of all error.vars available. Note that in each
case the date/time, error code, and specific data used in the query are the same.
Any ideas?
thanks,
Chris Norloff
CF 4.5 SP2 on Solaris 2.6, with Oracle 8i
--------------------------
APPLICATION.LOG ENTRY:
"Error","TID=15","01/03/02","15:03:04","Oracle Error Code = 1<P>ORA-00001: unique
constraint (PERMIT.P_SEC_USER_CORP_LINK_PK) violated <P> <P> SQL = "INSERT into
p_sec_user_corp_link(user_seq_no, corp_ref_seq_no, location_seq_no, activity_date,
audit_user_no) values(2886, 25, 359, sysdate, 2886)" "
--------------------------
ERROR CAUGHT AND LOGGED:
Date 2002-01-03 Time 15:03:04
QueryName=,
Type=DATABASE,
Msg=Oracle Error Code = 1<P>ORA-00001: unique constraint
(PERMIT.P_SEC_USER_CORP_LINK_PK) violated
<P>,
Detail=<P>SQL = "INSERT into p_sec_user_corp_link(user_seq_no, corp_ref_seq_no,
location_seq_no, activity_date, audit_user_no)
values(2886, 25, 359, sysdate, 2886)"<P>Data Source = "QALIME"<P>,
NativeErrorCode=1,
SQLstate=
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
