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
,
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
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
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,
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
this exception.
Here's the exception diagnostics:
Error Executing Database Query. [Macromedia][SQLServer JDBC
Driver]No more data available to read. brThe error occurred
on line 24.
Here's one of the queries:
SELECT Salt FROM Users WHERE Username = (param 1)
(param
to perform simple
SELECT queries. The queries did not throw this exception on development and
test machines. Sometimes they work and sometimes they throw this exception.
Here's the exception diagnostics:
Error Executing Database Query. [Macromedia][SQLServer JDBC
Driver]No more data
queries. The queries did not throw this exception on development and
test machines. Sometimes they work and sometimes they throw this exception.
Here's the exception diagnostics:
Error Executing Database Query. [Macromedia][SQLServer JDBC
Driver]No more data available to read. brThe
PROTECTED]
Sent: Tuesday, April 05, 2005 3:29 PM
To: CF-Talk
Subject: Re: Error Message No more data available to read. on CFMX 6
If your CF server is located on a different server than your SQL server,
uncheck Maintain Connections in CF admin/datasource setup/advanced
settings
In my
If your CF server is located on a different server than your
SQL server, uncheck Maintain Connections in CF
admin/datasource setup/advanced settings
In my experience, you get this error when you try to
'maintain connections' to a remote db. Your cf app makes a
query, then you go to
I thought that this was that rather well documented issue where SQL Server
had actually maxed out its connections and was refusing to accept any more
but the data direct drivers return the rather less helpful 'no more data'
error...
If you can, increase your max permissable connections in SQL and
Here is some info from Steven Erat.
http://www.talkingtree.com/blog/index.cfm?mode=entryentry=40F4C7EA-45A6-284
4-7D0C4841EA190125
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
-Original Message-
From: Bryan F. Hogan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 05, 2005 4:29 PM
To: CF-Talk
Subject: RE: Error Message No more data available to read. on CFMX 6
Driver]No more data available
to read
I just upgraded my CF server from 6.0 to 6.1 and I keep getting this
error:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]No more data available to
read.
I don't get it all the time, just occasionally. It seems to happen with
pages that have
I just upgraded my CF server from 6.0 to 6.1 and I keep getting this
error:
Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver]No more data available to
read.
I don't get it all the time, just occasionally. It seems to happen with
pages that have been sitting for awhile (like
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
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
]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
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
-Original Message-
From: Calvin Ward [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 3:18 PM
To: CF-Talk
Subject: Re: [Macromedia][SQLServer JDBC Driver] No more data available to read
Considering an upgrade got me this error, but solved a much worse one, surely there's got
Alan,
Did you ever find out anything about the error that reads: [Macromedia][SQLServer JDBC Driver] No more data available to read
Or anyone else?
Also I have the August 1 drivers that resolve the 100 percent cpu problem.
Thanks,
Calvin
[Todays Threads]
[This Message]
[Subscription
I'm resending this in case anyone might have some ideas
Thanks,
Calvin
- Original Message -
From: Calvin Ward
To: CF-Talk
Sent: Wednesday, October 08, 2003 5:43 AM
Subject: [Macromedia][SQLServer JDBC Driver] No more data available to read
Alan,
Did you ever find out anything about
We still receive this error as well.
-Original Message-
From: Calvin Ward [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 2:41 PM
To: CF-Talk
Subject: Re: [Macromedia][SQLServer JDBC Driver] No more data available to
read
I'm resending this in case anyone might have some
start up reliably that way.
-nathan strutz
-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 12:22 PM
To: CF-Talk
Subject: RE: [Macromedia][SQLServer JDBC Driver] No more data available to
read
We still receive this error as well
wouldn't start up reliably that way.
-nathan strutz
-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 12:22 PM
To: CF-Talk
Subject: RE: [Macromedia][SQLServer JDBC Driver] No more data available to
read
We still receive this error as well
Hi Guys,
Here I am getting following error unexpectedly.
Error Executing Database Query.
[Macromedia][Oracle JDBC Driver]No more data available to read.
Pls let me know if you have any great suggestion to resolve this error.
We are using 6.1 MX version.
Thanks
Ramesh
[Todays
I keep getting the error ... [Macromedia][SQLServer JDBC Driver]No more
data available to read.
Anyone got any ideas, seems from the Macromedia forums I am not alone :(
Paul Johnson
~|
Archives: http://www.houseoffusion.com
.
[Macromedia][SQLServer JDBC Driver]No more data available to read.
I know that this was a problem pre updater 3 with the Oracle driver with
blobs, but this is not my case.
I'm running CFMX 6.1 SQL 2000 Updater 2, IIS 5, Windows 2000 Server
I know that this was a problem with the Oracle db drivers on CFMX pre
Updater 3, but I get this error on CFMX6.1 SQL Server I can't recreate it,
they where in my email this morning from last night.
Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]No more
data available to read
Since upgrading to 6.1 we've started getting these errors from the SQLserver
JDBC driver. We've had the errors on selects and on updates, on different
tables, the apparent common factor being that 'text' columns are used in
those tables. They don't happen that often, but are happening in critical
30 matches
Mail list logo