If the string really has been serialized as a byte array into a BLOB
column, then I'm not aware of an off-the-shelf solution. I would tackle
this problem by writing a function which does the following:
o Retrieves the java.sql.Blob via PreparedStatement.getBlob()
o Retrieves an InputStream fro
yup, definitely a blob. it looks like the like operator doesnt work for
blobs, or maybe i need a cast or some function to the conversion
On Mon, Sep 30, 2019 at 6:50 PM Rick Hillegas
wrote:
> On 9/30/19 9:18 AM, Alex O'Ree wrote:
>
> I have a use case where i have string data stored in a blob an
On 9/30/19 9:18 AM, Alex O'Ree wrote:
I have a use case where i have string data stored in a blob and i want to
perform a query similar to
select * from table where column1 like '%hello world%'
It doesn't look like this is possible with derby out of the box. Is there a
way to create a function
Alex, I think this may be a solution:
https://db.apache.org/derby/docs/10.14/tools/rtoolsoptlucene.html
On Mon, 30 Sep 2019 at 18:18, Alex O'Ree wrote:
> I have a use case where i have string data stored in a blob and i want to
> perform a query similar to
>
> select * from table where column1 l
I have a use case where i have string data stored in a blob and i want to
perform a query similar to
select * from table where column1 like '%hello world%'
It doesn't look like this is possible with derby out of the box. Is there a
way to create a function that calls a java function or something