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!

Tags: sql-server jdbc coldfusion