Can you debug the actual queries CF sends to Oracle? I know Oracle keeps a query history somewhere. Then use those queries in SQL Plus, see if you get the same results.
Also, perhaps get a packet sniffer going on the CF side of the firewall to see what connections are being attempted and whether or not the firewall is allowing those (also check firewall logs for clues). Sorry it's vague, but it's an elimination troubleshooting approach. - Peter -----Original Message----- From: Osullivan Karl (RKB) Senior Analyst/Programmer [mailto:[EMAIL PROTECTED]] Sent: 06 January 2003 10:48 To: 'CF - Development Group' Subject: [ cf-dev ] Oracle / CF Error Hi, Happy New Year to you all. I know I've run this one past the group before, but I thought I'd give it another go as I'm completely stuck. We use the Oracle native driver in CF (SQL Plus/SQLnet 8.1.5) to talk to the Oracle database. This works absolutely fine, and will bring back 1 or 1000 records, depending on the selection criteria. We also have the same software on a server the other side of our firewall (using Borderware v.6.5 (Feature Pack A)) with a port through the firewall to the same Oracle database. This also uses the native driver. When we run queries (the same ones I was talking about above) then sometimes we get the message: Error Diagnostic Information Oracle Error Code = 3113 ORA-03113: end-of-file on communication channel There seems to be no pattern to this. Sometimes it's on queries that only return 30 records, and sometimes on queries that return 200 records. But then again it can work on queries that return 500 records! It's the same query, the only difference is that is running through the firewall. If I take ColdFusion out of the equation and run the query through SQL/Plus on the firewall server (so going through the same port as with CF) then the queries run fine everytime, which makes me think it is something to do with CF. I've also tried the Merant Oracle ODBC driver and this produces the same message. Does anyone have any ideas? Please!! Karl O'Sullivan Senior Analyst Programmer University Hospitals Coventry and Warwickshire NHS Trust Tel: 024 7660 2020 x7578 [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
