JDBC Problems: “String Index Out of Range” Error

This afternoon I’ve been checking out some JDBC drivers from one of our database vendors, and once I finally got them working in ColdFusion MX, I kept getting a “String index out of range” error, even on very simple queries. After playing around with the query for a bit, I realized it had something to do with whitespace and/or carriage returns within the query string itself. I’ve notified our DBA team to file a bug with the vendor, but it was something that took some specific Googling to figure out.

This is mostly just a post to file away in the archives– hopefully it will help someone in the future with JDBC problems.

This entry was posted in Languages, Tips, Hacks, & Tricks and tagged , , , , , , . Bookmark the permalink.

3 Responses to "JDBC Problems: “String Index Out of Range” Error"

Leave a reply