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.