Just an additional bit of info:
If I send a malformed query to Oracle using native drivers, and the error
occurs *after* the column headings are returned by the query (this happens
with certain types of errors), the CF server evidently believes the query is
still executing and therefore *no* error is returned to your browser. It
appears as if the server was hanging at this point. This was driving me
crazy until my server guru set the maximum query timeout on the CF server
from 0 to 60 seconds. If I run the same query in SQL Plus, Oracle returns
the column headings with an immediate error message, so anytime I have a
questionable query I always test drive it in SQL Plus first.
~~~~~~~~~~~~~~~~~~~~~~~~
Ricq Pattay <[EMAIL PROTECTED]>
Univ of MN College of Veterinary Medicine
----- Original Message -----
From: Dave Watts <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, July 18, 2000 11:56 AM
Subject: RE: Oracle... ODBC error messages different than native drivers?
> > Which leads me to ask... Would the native driver return a
> > different (or even better) error message than the Oracle
> > ODBC driver?
>
> In my experience, the Oracle native drivers return a different error
message
> than the ODBC error messages - they're even more obtuse. In fact, the
> Allaire knowledge base recommends using ODBC instead of native drivers
when
> you're trying to figure out why something isn't working.
>
> > How exactly does ColdFusion process database errors?
>
> CF never really communicates directly with the database, as I believe
> SQL*Plus does. It returns whatever message the middleware layer sends, as
> far as I can tell.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
> --------------------------------------------------------------------------
----
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
