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',