ansaurus

Question

Help I have problem with select query in JPA

Answer 1

+1 A:

You probably should say what the error is exactly.

However, assuming that you have an entity Magazine then the query should be:

 select m from Magazine m

If you want all magazines.

Vincent Ramdhanie 2008-11-29 12:44:57

Answer 2

+1 A:

For this to work, you need an entity defined as such:

@Entity
@Table(name = "magazines")
public class Magazine {
  /*
   * Some more attributes
   */

  @Column(name = "name_magazine")
  private String name;

  /*
   * Constructors, getters and setters
   */
}

Additionally you need a persistence.xml file pointing to your entity. If all of that is in place, this query should work and give you a list of all magazines.

from Magazine m

The query you specified is a projection of that, and with the entity I showed above it should be

select m.name from Magazine m

Hope this helps. :)

Guðmundur Bjarni 2008-11-29 12:57:12

Answer 3

+2 A:

The answer is right there in the call stack for your exception:

Error compiling the query [Select m.Jenis_Motor from motor m]. Unknown abstract schema type [motor].

It's not a problem with your magazine query, but another malformed query - probably a named query defined somewhere else.

Dan Vinton 2008-11-29 17:51:55

Exactly right. +1

toolkit 2008-11-29 23:05:46

ansaurus

tags:

views:

answers:

Help I have problem with select query in JPA

related questions