syntax « HQL « JPA Q&A

1. Been Doing My Nut!!! HQL Syntax Problem forum.hibernate.org

Hi All, Been trying to figure this for a few days now, I must be missing something on the config side of things. Im using netbeans to create a simple login form which looks at a MySQL table Users. I followed the tutorial on the netbeans website to create the Hibernate config file, reverse engineer, pojos and mapping files, etc. Im ...

2. HQL Syntax Reference forum.hibernate.org

3. HQL formal syntax? forum.hibernate.org

I get an error from the following HQL query string: "from creditor c in join c.outstandingBalances b where b.creditorBalanceID.accountNumber = :tan" The error is: net.sf.hibernate.QueryException: in expected: c [ ...query string...] I invoke query as: list = session.createQuery(qstring).setInteger("tan", 2).list(); Why would it expect an 'in' clause? More generally, where can I find formal syntax for HQL? Rob

4. HQL: Incorrect syntax near forum.hibernate.org

Newbie Joined: Mon May 03, 2004 11:49 am Posts: 3 Hi, I'm having a problem with an hql query . I'm using a Sybase database, and I'm trying to do an hql query to the database . First, the query has about 10 nestested 'AND' & 'OR' criterias, this query work ok, but when I tried the query with about 300 ...

5. HQL - Syntax/ How to question forum.hibernate.org

Hibernate version: Hibernate 2.1.6 Im new to Hibernate and I am having trouble comming up with with an HQL statement that would tell me the following. In my db I have a table that has a list of users, a table that has a list of user groups, and a join table that stores which users are members of which user ...

6. FYI - syntax error using HQL for certain package names forum.hibernate.org

Hi All, I did a search around the documentation but did not find this posted. If it is, and I missed it, do point out the URL so I can read up on possible solutions. Im using Spring with Hibernate to design a software application. My application uses a package names that begins with in.gov.xxx.xxxx. The "in" in the package name ...