检索存储从德比CLOB与工作灯适配器的base64形象 [英] Retrieve base64 image stored as a CLOB from derby with Worklight adapter

问题描述

我想检索存储作为通过工作灯SQL适配器在德比DB一个CLOB的图像。我想这样做类似于在这里写了一句：
<一href=\"https://www.ibm.com/developerworks/community/blogs/dhuyvett/entry/jsonstore_revisited_in_worklight_v6_part_1_the_adapter?lang=en\" rel=\"nofollow\">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中的，所以如果你有一个变种的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

这篇关于检索存储从德比CLOB与工作灯适配器的base64形象的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！