openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Patrick Linskey (JIRA)" <>
Subject [jira] Updated: (OPENJPA-101) enhance JPQL Constructor Expressions implementation
Date Sun, 27 Apr 2008 23:16:55 GMT


Patrick Linskey updated OPENJPA-101:

    Fix Version/s:     (was: 1.1.0)

Sounds like a cool enhancement. I think that it would be nice to implement with both literals
and parameters. However, I think it's out of scope of 1.1.0.

> enhance JPQL Constructor Expressions implementation
> ---------------------------------------------------
>                 Key: OPENJPA-101
>                 URL:
>             Project: OpenJPA
>          Issue Type: Improvement
>          Components: query
>            Reporter: wanyna
>             Fix For: 1.2.0
> There are two tables A and B, I need to execute sql like
> "insert into A select ... from B".
> I use JPQL Constructor Expressions,
> select new A(...) from B, got A list then persist.
> But some fields of A depends on program context, not direct from B, so SELECT NEW clause
should look like these :
> select new A(B.column1, 'xxx') from B, or
> select new A(null, B.column2) from B, or
> select new A(variable, B.column2) from B.
> Unfortunately, OpenJPA doesn't support this.
> I have to get the result object[] list and constuct A in my code now. 
> If JPQL Constructor Expressions become more powerful, my code  will be more simple then.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message