Oracle-L: ColdFusion and Oracle

From: Rusnak, George A. <george.rusnak_at_deca.mil>
Date: Mon, 10 Jun 2002 05:53:18 -0800
Message-ID: <F001.00478E1F.20020610055318@fatcity.com>

Group,
I have an Oracle database 8.1.7.2 on Sun Solaris 5.0. We have another server running ColdFusion. The ColdFusion log has the following representative message (the Unable to instantiate ... - is the same):

Fri Jun 07 11:23:33 2002,Oracle Error Code = 0Unable to instantiate environment for 'ORACLE80.' SQL = "SELECT sos_name name, conus_flg conus, dibs_region region

FROM         scan_dodaac
Where           dodaac=_CF_:?_"<P>

Query Parameter Value(s) - Parameter #1 = HQCNEY Data Source = "WEBREAD"The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position
(100:6) to (100:56)., ,

/opt/iplanet_web_server.4/docs/log_in/html/cr.cfm?dodaac=HQCNEY&CID=2

This message is repeated many, many times. I have nothing in my Oracle logs to indicate any problem. We started an endless loop on the ColdFusion server to the database server that just selects data from a table and then sleeps for 5 seconds, we do not get the above error messages in the ColdFusion log.

Checked MetaLink, etc. Oh, bye the way we use Oracle MTS.

TIA Al Rusnak
804-734-8453
rusnakga_at_hqlee.deca.mil

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rusnak, George A.
  INET: george.rusnak_at_deca.mil

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Mon Jun 10 2002 - 08:53:18 CDT