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.
3 Responses
Jake
17|Mar|2004 1Wouldn’t it only be useful if you named the vendor in question? I suppose other JDBC driver might have the same problem, but it is a vendor-specific bug, no?
Brandon Harper
17|Mar|2004 2Nope, it’s actually a generic error.. I found out information about it via Postgres and DataDirect JDBC Drivers which previously had the same problems.
Kirk Mower
28|Mar|2004 3I have been having problems with big queries that are locking up ColdFusion (Cfusion). You mentioned that connection pooling should be turned off, but I am not sure what you mean. If you could expand a bit on that one, thanks.
Leave a reply