Now THAT Is an Error Message

I just got this error message:

17 >= 17

I’m not kidding. That was the message. When I find out more, I’ll post the details.

Edited 2 Minutes Later: I turned on Robust Exception Info, and the error went away, so it must have been a fluke… but still - it was pretty funny.

Edited 1 Minute Later: It’s back now. This time I see more information. It is happening inside a query. Here is part of the stack trace:

java.lang.ArrayIndexOutOfBoundsException: 17 >= 17
at java.util.Vector.elementAt(Unknown Source)
at macromedia.jdbc.sqlserver.tds.TDSRequest.getColumn(Unknown Source)

Last Edit: I think I figured it out. The query in question was a select * from foo where id = X, where X used a query param. The use of queryparam caused CF to store the … I think “prepared statement” is the right word. The table in question was modified though. I went to the CF Admin, selected the DSN, and set the Max Pooled Statements to 0, which fixed the problem. Although normally you wouldn’t do that on a production server.

Raymond Camden's Picture

About Raymond Camden

Raymond is a developer advocate. He focuses on JavaScript, serverless and enterprise cat demos. If you like this article, please consider visiting my Amazon Wishlist or donating via PayPal to show your support. You can even buy me a coffee!

Lafayette, LA