@NamedNativeQuery and choosing the correct resultClass

[Tom Kowalski]

@NamedNativeQueries({
    @NamedNativeQuery(
        name = "nativeSQL",
        query = "SELECT * FROM Actors",
        resultClass = db.Actor.class),
    @NamedNativeQuery(
        name = "nativeSQL2",
        query = "SELECT COUNT(*) FROM Actors",
        resultClass = XXXXX) // <--------------- problem
})

Probably this is simple question, but I just can't find the answer. What should be in the place of XXXX in this query? I have been trying java.lang.String.class and java.lang.Long.class but it doesn't work...

[James Sutherland]

Nothing, just do not include a resultClass. resultClass is only for SQL queries that are used to build Entity objects.

[Tom Kowalski]

Thanks a lot for the answer ! ^^

[xsunil kumar]

Hi,

I want to call one stored procedure using JPA entity manager. In my stored procedure i have some input parameters and some as out put parameters. Please suggest, how to call this.

[James Sutherland]

JPA does not define any specific support for stored procedures or output parameters, native queries only directly support SQL returning a ResultSet.

Depending on what JPA provider and database you are using, there are some way to execute stored procedures.

See,
http://en.wikibooks.org/wiki/Java_Persistence/Advanced_Topics#Stored_Procedures

[Zaztz Zuraidah]

Tom Stachlewski wrote:Thanks a lot for the answer ! ^^

I don't get this. I am having the same problem.

How do you get the integer result then?

int count = theDao.findByNamedQuery("findCount",queryParams);