openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brian Topping (JIRA)" <>
Subject [jira] [Created] (OPENJPA-2268) SQL Generation with query using IN element
Date Wed, 26 Sep 2012 18:59:08 GMT
Brian Topping created OPENJPA-2268:

             Summary: SQL Generation with query using IN element
                 Key: OPENJPA-2268
             Project: OpenJPA
          Issue Type: Bug
          Components: jdbc, kernel, sql
    Affects Versions: 2.2.0
            Reporter: Brian Topping

Hi all, I've been staring at a problem for the last 12 hours with a JPQL query that appears
to be parsing incorrectly.  There are three tables, a permissions table with a n-n relation
to a role table, in turn with an n-n relation to a users table.  The intent of the query is
to get all permissions for a user by username: {{select p from PersistentPermission p, IN(p.roles)
r, IN(r.users) u where u.username = :name}}.  

No errors are generated, but the SQL emitted to the log has not been parsed or transformed
at all.  (This may be correct, I've been fortunate enough so far not to have to look at the
SQL generated by OpenJPA).  

Debugging into OpenJPA, it appears that the generated query is "select permission p where
username='?'", which obviously will not return anything.  

I'm still debugging this (having gotten down to the level of the jflex code), but it's my
first time going deep on OpenJPA like this so things are going slow.  I'll post updates here,
but if anyone sees this and has ideas of where to look first (no matter how small), it may
be a great help.

Thank you1

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

View raw message