Thank you for your post.
Page 31 of the ODBC/JDBC guide shows how to map FileMaker fields to JDBC data types:
For a Container field, use java.sql.Types.BLOB
Thank you for your reply,
Even if i get Container fields as a Blob also it is returning NULL only.
String query2="SELECT \"Contractor\".\"Logo\" as mylogo,CAST(\"Logo\" AS VARCHAR(100)) as refence FROM \"Contractor\"";
ps = con.prepareStatement(query);
rs = ps.executeQuery();
byte buffer = new byte[BUFFER_SIZE];
Like that i try to print the Byte Stream what i am getting from server. It is returning Null Pointer Exception.
Please help me regarding this.
Is "img" the name of the Container field? Or, is it "Logo"?
Change the query to:
"SELECT GetAs(logo, DEFAULT) FROM contractor"
(assuming "logo" is the container field)
getBlob() requires the Container field's name or index as parameter (should be "logo" here or index "1" or any alias if specified in the query).