AnsweredAssumed Answered

Unable to get Blobs from DB with JDBC

Question asked by OnnoTijdgat on Jul 13, 2010
Latest reply on Mar 12, 2013 by disabled_PeterWagemans


Unable to get Blobs from DB with JDBC


FileMaker Server


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:

Steps to reproduce the problem

See also: Noone seems to be able to get it working.

Expected result

a non null blob object

Actual result


Exact text of any error message(s) that appear