Java Development Tools

Hi,

I've been working with EJB and Rest Services and now I have this situation.

I'm trying to present an image saved on my DB as a blob, but when I test my service I get no results.

My entity as the following code for the blob, self generated

private byte[] thememo;

    public byte[] getThememo() {
        return thememo;
    }

    public void setThememo(byte[] thememo) {
        this.thememo = thememo;
    }

and this are the queries, both to return the same, that I've added

@NamedQuery(name = "Memos.findPhoto", query = "select o.thememo from Memos o where o.sourceid = :recid and o.memotyp = 101"),
@NamedQuery(name = "Memos.getPhoto", query = "select 'image/jpeg', o.thememo from Memos o where o.sourceid = :recid and o.memotyp = 101")

when looking for something that would explain me on how to accomplish what I want I found a link indicating to add this 'image/jpeg', before the column that as the blob

and when I add those queries as functions to my SessionBean through facade this are the results I get

    /** <code>select o.thememo from Memos o where o.sourceid = :recid and o.memotyp = 101</code> */
    @TransactionAttribute(TransactionAttributeType.NOT_SUPPORTED)
    public List<Byte> getMemosFindPhoto(String recid) {
        return em.createNamedQuery("Memos.findPhoto", Memos.class).setParameter("recid", recid).getResultList();
    }

    /** <code>select 'image/jpeg', o.thememo from Memos o where o.sourceid = :recid and o.memotyp = 101</code> */
    @TransactionAttribute(TransactionAttributeType.NOT_SUPPORTED)
    public List<Object[]> getMemosGetPhoto(String recid) {
        return em.createNamedQuery("Memos.getPhoto", Memos.class).setParameter("recid", recid).getResultList();
    }

The first gives me a List of Bytes and the other a List of Object Array, and the only thing I want to return is the blob as image.

Both returns in my SessionBean are giving errors, 'Incompatible types' but this was generated.

Without those functions, when I try to add the service to my JAXB schema it won't allow it.

What am I doing wrong or what am I missing?

I'm using JDev 12.1.3.0

Thanks

and when I add 'image/jpeg', 'image/jpeg','image/jpeg',