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 PeterWagemans

Summary

Unable to get Blobs from DB with JDBC

Product

FileMaker Server

Version

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.

Expected result

a non null blob object

Actual result

null

Exact text of any error message(s) that appear

none.

Workaround

none

Outcomes