Monday, October 29, 2007

No more data available to read / 4096

Yes, ColdFusion MX 6.1 is old, but some of our customers are still running it, and we're here to support them. A particular large select query against a SQL Server 2000 database was erroring out with either "No more data available to read" or "4096" errors. The stack trace indicated that the 4096 error was in fact a "java.lang.ArrayIndexOutOfBoundsException: 4096" error.

We upgraded the client's database drivers to version 3.3, restarted CFMX, and the error went away. My Googling didn't turn up any solutions, so I figured I'd blog it and hopefully save someone else a few minutes of headache!

1 comments:

Peter Pham said...

I use Coldfusion 8 but still receive this error "No more data available to read". It is kept sending every day at a specific time in day. My query is conecting to an Oracle server. Still there is no solution for this.