How to use CreateNativeQuery to query single value from SQL database value?

Greenhorn

Posts: 1

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi all,

using a CRUD and want to access a certain value in the databse. what I tried is:

Query query = em.createNativeQuery("select o from Table o where o.IDfield= '938'");
Table o = (Table)query.getSingleResult();

but this fails.

Any suggestions?

I am not young enough to know everything. - Oscar Wilde This tiny ad thinks it knows more than Oscar:

a bit of art, as a gift, the permaculture playing cards

https://gardener-gift.com