Unable to get Blobs from DB with JDBC
FM Server 11 Advanced v1
Operating system version
Mac OS X 10.6.4
Description of the issue
Using FM 11 Server Advanced as a data source in a Java/jsp project. The connection with the database is made thru jdbc.
In principle this works fine. However, I am having trouble retrieving the contents of FM container fields. I should be able to do something like xyz.getBlob(colIdx) to get a Blob object refering to the FM container. xyz is a ResultSet object containing the result of an SQL query.
However this blob object is always null. Inspecting the Resultset shows that indeed the container fields are always null. (Yes, the DB has data of various forms in all container fields). The field type returned is -4, LONGVARBINARY, which is correct.
I tried a simple SELECT *, SELECT GetAs() and i never get any non null data.
Inserting blobs does work.
See also the discussion at: http://forums.filemaker.com/posts/4d1cc9ffd7
Steps to reproduce the problem
See also: http://forums.filemaker.com/posts/4d1cc9ffd7 Noone seems to be able to get it working.
a non null blob object
Exact text of any error message(s) that appear