I wish our DBA gave me that level of access the server, but I will let him know what to check into. The servers we are on are most certainly dedicated (I am the administrator for the CF side). Also I am able to connect to the DB and execute queries using the Oracle JDBC driver with any problem. I would just the Oracle provided driver, but there are issues with that driver and using ref cursors in CF.
Thanks again for the ideas! >It's possible the DB is actually unavailable (either due to network >congestion, Oracle problems or other issues) when the errors occur. >It's also possible that you're using shared servers rather than >dedicated servers and the shared servers are having an issue. Check >memory on the Oracle server, check for dead Oracle sessions etc. > >With maintain connections off, it's less likely to be a problem at the >CF end, since the most common cause of the error is CF attempting to >use a pooled connection that's no longer available. > >mxAjax / CFAjax docs and other useful articles: >http://www.bifrost.com.au/blog/ >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325213 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
