You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Vermeulen (JIRA)" <ji...@apache.org> on 2012/08/16 11:43:37 UTC

[jira] [Created] (OPENJPA-2251) EXISTS with subquery from superclass generates SQL with syntax error

Vermeulen created OPENJPA-2251:
----------------------------------

             Summary: EXISTS with subquery from superclass generates SQL with syntax error
                 Key: OPENJPA-2251
                 URL: https://issues.apache.org/jira/browse/OPENJPA-2251
             Project: OpenJPA
          Issue Type: Bug
    Affects Versions: 2.2.0
            Reporter: Vermeulen



I have an abstract entity Booking with @Inheritance(strategy = InheritanceType.TABLE_PER_CLASS).
It has a ManyToOne relation with Event.

The following JPQL query generates SQL with a syntax error:

SELECT z FROM Event z WHERE EXISTS (
   SELECT booking.id FROM Booking booking 
   WHERE booking.event = z AND booking.remarks = :REMARKS
)

org.apache.openjpa.lib.jdbc.ReportingSQLException: Incorrect syntax near the keyword 'FROM'. {prepstmnt 17234903 
SELECT t0.id, ...(many more columns)..., t0.USERCREATED_ID 
FROM booking_Event t0 LEFT OUTER JOIN booking_OccasionType t1 ON t0.OCCASIONTYPE_ID = t1.id WHERE (EXISTS (SELECT  FROM  WHERE ( AND )))} [code=156, state=S0001]

When I replace Booking with the name of a concrete subclass the query executes fine.
When I execute only the subquery as a normal query it executes fine:
   SELECT booking.id FROM Booking booking 
   WHERE booking.event.id = :eventId AND booking.remarks = :REMARKS
   
When I replace the parameter :REMARKS with a Collection-valued parameter like so "booking.remarks IN :REMARKS", I get a weird
ClassCastException:

Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to [Ljava.lang.Object;
	at org.apache.openjpa.jdbc.kernel.exps.InExpression.orContains(InExpression.java:178)
	at org.apache.openjpa.jdbc.kernel.exps.InExpression.appendTo(InExpression.java:122),
....

Again when I replace Booking with the name of a concrete subclass the query executes fine.

I think this may be related to OPENJPA-681 and OPENJPA-658 which have already been resolved, but perhaps the problem still exists when querying on a superclass.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Commented] (OPENJPA-2251) EXISTS with subquery from superclass generates SQL with syntax error

Posted by "Vermeulen (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/OPENJPA-2251?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13435859#comment-13435859 ] 

Vermeulen commented on OPENJPA-2251:
------------------------------------

I just noticed that OPENJPA-658 is not resolved yet. Perhaps this is another manifestation of that issue.
                
> EXISTS with subquery from superclass generates SQL with syntax error
> --------------------------------------------------------------------
>
>                 Key: OPENJPA-2251
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-2251
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 2.2.0
>            Reporter: Vermeulen
>
> I have an abstract entity Booking with @Inheritance(strategy = InheritanceType.TABLE_PER_CLASS).
> It has a ManyToOne relation with Event.
> The following JPQL query generates SQL with a syntax error:
> SELECT z FROM Event z WHERE EXISTS (
>    SELECT booking.id FROM Booking booking 
>    WHERE booking.event = z AND booking.remarks = :REMARKS
> )
> org.apache.openjpa.lib.jdbc.ReportingSQLException: Incorrect syntax near the keyword 'FROM'. {prepstmnt 17234903 
> SELECT t0.id, ...(many more columns)..., t0.USERCREATED_ID 
> FROM booking_Event t0 LEFT OUTER JOIN booking_OccasionType t1 ON t0.OCCASIONTYPE_ID = t1.id WHERE (EXISTS (SELECT  FROM  WHERE ( AND )))} [code=156, state=S0001]
> When I replace Booking with the name of a concrete subclass the query executes fine.
> When I execute only the subquery as a normal query it executes fine:
>    SELECT booking.id FROM Booking booking 
>    WHERE booking.event.id = :eventId AND booking.remarks = :REMARKS
>    
> When I replace the parameter :REMARKS with a Collection-valued parameter like so "booking.remarks IN :REMARKS", I get a weird
> ClassCastException:
> Caused by: java.lang.ClassCastException: java.lang.String cannot be cast to [Ljava.lang.Object;
> 	at org.apache.openjpa.jdbc.kernel.exps.InExpression.orContains(InExpression.java:178)
> 	at org.apache.openjpa.jdbc.kernel.exps.InExpression.appendTo(InExpression.java:122),
> ....
> Again when I replace Booking with the name of a concrete subclass the query executes fine.
> I think this may be related to OPENJPA-681 and OPENJPA-658 which have already been resolved, but perhaps the problem still exists when querying on a superclass.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira