Paul Clapham wrote:My guess? It's a "feature" of the JDBC driver. There are some drivers which don't let you read the same column of any type twice, or require you to read them in order.
But it might also be a bug -- do the API docs mention that the method can do that?
This was the current JDBC driver for FileMaker Pro. There is scant documentation other than a few sample calls in a small PDF Reference.
I'm guessing it must be (since I can re-read some columns)... a bug. Plus, I can even re-read the getBytes() column for small image sizes. I didn't do extensive
testing, but it seemed that trying to do a second getBytes() on an image column (or other blob type data, a "Container" in FMP) over, say 200KB, would zero out the bytes read.
I'll just chalk it up to a few hours
invested in the debugger!
Thanks very much for your reply. :)
-mike