Hello,

I,am trying to execute a query in a stateless bean, with jboss seam

The query is

List existing = em.createQuery("select username from Users")
    .getResultList();

and I get this error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.users users0_' at line 1

My entity bean is defined as

@Entity
@Name ("users")
@Scope (SESSION)
@Table(name = "users")
public class Users implements java.io.Serializable {
 
 private static final long serialVersionUID = 1881413500711441951L;
 
 private String username;
 private String password;
          .........

What is wrong??
I have configue my app with jboss seam
seam setup
seam new-project

My database is mysql 4.1.21 and if I connect by jdbc all its ok.

thank you

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4053005#4053005

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4053005
_______________________________________________
jboss-user mailing list
jboss-user@(protected)
https://lists.jboss.org/mailman/listinfo/jboss-user