A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
How to use CreateNativeQuery to query single value from SQL database value?
Joined: Apr 06, 2011
Apr 06, 2011 06:12:55
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.
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link:
subject: How to use CreateNativeQuery to query single value from SQL database value?
my result holding null values
issue to pass the dynamic value in query
using string as column name in select query?
How to delete the row from the Database by using while loop in servlet
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015