使用 Worklight 适配器从 derby 检索存储为 CLOB 的 base64 图像 [英] Retrieve base64 image stored as a CLOB from derby with Worklight adapter
问题描述
我正在尝试通过 Worklight SQL 适配器检索在 Derby DB 中存储为 CLOB 的图像.我想做一些类似于这里写的东西:https://www.ibm.com/developerworks/community/blogs/dhuyvett/entry/jsonstore_revisited_in_worklight_v6_part_1_the_adapter?lang=en除了引用的文章作者使用的是 DB2.有谁知道我如何在德比做到这一点?目前,当我去检索执行 SQL 选择的图像时,返回的字符串是
I am trying to retrieve an image stored as a CLOB in a Derby DB via a Worklight SQL adapter. I would like to do something similar to what was written up here: https://www.ibm.com/developerworks/community/blogs/dhuyvett/entry/jsonstore_revisited_in_worklight_v6_part_1_the_adapter?lang=en except for the referenced article the author is using DB2. Does anyone know how I can do this in Derby? Currently when I go to retrieve the image doing a SQL Select, the string returned is
图像":org.apache.derby.impl.jdbc.EmbedClob@2d236"
"IMAGE": "org.apache.derby.impl.jdbc.EmbedClob@2d236"
我也会考虑使用 mysql 作为替代方案.感谢您的任何建议.
I would also consider mysql as an alternative. Thanks for any suggestions.
JT
推荐答案
org.apache.derby.impl.jdbc.EmbedClob 是一个 java.sql.Clob,所以如果你在 var 中有 CLOB,你应该可以获取数据:
org.apache.derby.impl.jdbc.EmbedClob is a java.sql.Clob, so if you have the CLOB in a var, you should be able to get the data with:
var dataAsString = theClob.getSubString(1, theClob.length()); // Assumes all CLOBS are < 2G
这篇关于使用 Worklight 适配器从 derby 检索存储为 CLOB 的 base64 图像的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!