Re: [Macromedia][Oracle JDBC Driver]No more data available to read.
This is a common problem. If it persists, reduce your max pooled statements to 0. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/8/5 Wes Middendorff wmiddendo...@gmail.com: Not sure if my last post took since I didn't see it in the list or my email, so sorry if this is redundant. I am getting the following error [Macromedia][Oracle JDBC Driver]No more data available to read. when ever I try to execute a stored procedure that returns a ref cursor. I am currently running CF7 and have updated to the data direct 3.5 drivers (required for support of ref cursors). I have tried restarting the CF server and other drivers, but have had no luck so far. Just curious if any of you have experienced this issue and how you resolved it? ~| 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:325206 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: [Macromedia][Oracle JDBC Driver]No more data available to read.
Thanks for the speedy reply James. I have done as you suggested, but I still recieve the error. Afterwards, just to see if it would have an affect, disabled the maintain connections settings and it also had no affect. Not sure if it matters in this case, but I am using oracle 10gR2. Wes ~| 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:325208 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: [Macromedia][Oracle JDBC Driver]No more data available to read.
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/ 2009/8/5 Wes Middendorff wmiddendo...@gmail.com: Thanks for the speedy reply James. I have done as you suggested, but I still recieve the error. Afterwards, just to see if it would have an affect, disabled the maintain connections settings and it also had no affect. Not sure if it matters in this case, but I am using oracle 10gR2. Wes ~| 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:325209 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: [Macromedia][Oracle JDBC Driver]No more data available to read.
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
Re: [Macromedia][Oracle JDBC Driver]No more data available to read.
On Tuesday 16 Dec 2003 18:28 pm, Stacy Young wrote: You're probably still running 6.0 for specific reason but in general 6.0 = evil. Think there were major driver updates in 6.1 This issue affects 6.1 too. MM are aware, and keep promising a fix 'soon'. In the meantime, I believe you need to upgrade to the latest patch's for 6.0 - the fix for the 6.1 issue is to use the drivers from the 6.0 updater. -- Tom Chiverton Advanced ColdFusion Programmer Tel: +44(0)1749 834997 email: [EMAIL PROTECTED] BlueFinger Limited Underwood Business Park Wookey Hole Road, WELLS. BA5 1AF Tel: +44 (0)1749 834900 Fax: +44 (0)1749 834901 web: www.bluefinger.com Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple Quay, BRISTOL. BS1 6EG. *** This E-mail contains confidential information for the addressee only. If you are not the intended recipient, please notify us immediately. You should not use, disclose, distribute or copy this communication if received in error. No binding contract will result from this e-mail until such time as a written document is signed on behalf of the company. BlueFinger Limited cannot accept responsibility for the completeness or accuracy of this message as it has been transmitted over public networks.*** [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: [Macromedia][Oracle JDBC Driver]No more data available to read.
You're probably still running 6.0 for specific reason but in general 6.0 = evil. Think there were major driver updates in 6.1 Stace _ From: Smith, Don , CTR , WHS/PSD [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 12:29 PM To: CF-Talk Subject: [Macromedia][Oracle JDBC Driver]No more data available to read. I am running CFMX 6.0, no updates, on Apache 1.3.27 and using Oracle 9i on the back end.I am getting intermittent 500 Errors: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [EMAIL PROTECTED] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
RE: [Macromedia][Oracle JDBC Driver]No more data available to read.
I've seen this error a lot when working with ORACLE from EJB's on CFMX J2EE - usually when callingprocedures that return XML.Have you tried using the thin client drivers?Can you put updater 3 on the box first? ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator http://www.how2cf.com/ -Original Message- From: Smith, Don , CTR , WHS/PSD [mailto:[EMAIL PROTECTED] Sent: 16 December 2003 17:29 To: CF-Talk Subject: [Macromedia][Oracle JDBC Driver]No more data available to read. I am running CFMX 6.0, no updates, on Apache 1.3.27 and using Oracle 9i on the back end.I am getting intermittent 500 Errors: Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [EMAIL PROTECTED] and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]