You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@openjpa.apache.org by "Jianfeng Mao (JIRA)" <ji...@apache.org> on 2009/02/04 20:17:59 UTC

[jira] Created: (OPENJPA-898) hints don't work for NamedNativeQuery

hints don't work for NamedNativeQuery
-------------------------------------

                 Key: OPENJPA-898
                 URL: https://issues.apache.org/jira/browse/OPENJPA-898
             Project: OpenJPA
          Issue Type: Bug
    Affects Versions: 1.2.0
            Reporter: Jianfeng Mao


Hints defined for a named native query such as the one below don't get loaded, however, if changed it to @NamedQuery, the hints get loaded.
 
          @NamedNativeQuery(name="GetMemberInfo",
		query="CALL MEMBERSUB",
		hints= {
			@QueryHint(name="openjpa.hint.u2sub.numberofpara", value="2"),
			@QueryHint(name="openjpa.hint.u2sub.output.para", value ="2")
			}
		)

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


[jira] Assigned: (OPENJPA-898) hints don't work for NamedNativeQuery

Posted by "Pinaki Poddar (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pinaki Poddar reassigned OPENJPA-898:
-------------------------------------

    Assignee: Pinaki Poddar

> hints don't work for NamedNativeQuery
> -------------------------------------
>
>                 Key: OPENJPA-898
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-898
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 1.2.0
>            Reporter: Jianfeng Mao
>            Assignee: Pinaki Poddar
>
> Hints defined for a named native query such as the one below don't get loaded, however, if changed it to @NamedQuery, the hints get loaded.
>  
>           @NamedNativeQuery(name="GetMemberInfo",
> 		query="CALL MEMBERSUB",
> 		hints= {
> 			@QueryHint(name="openjpa.hint.u2sub.numberofpara", value="2"),
> 			@QueryHint(name="openjpa.hint.u2sub.output.para", value ="2")
> 			}
> 		)

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


[jira] Updated: (OPENJPA-898) hints don't work for NamedNativeQuery

Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Donald Woods updated OPENJPA-898:
---------------------------------

    Attachment: OPENJPA-898-branches10x.patch

patch for 1.0.x

> hints don't work for NamedNativeQuery
> -------------------------------------
>
>                 Key: OPENJPA-898
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-898
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 1.2.0
>            Reporter: Jianfeng Mao
>            Assignee: Michael Dick
>             Fix For: 2.0.0-M1, 2.0.0
>
>         Attachments: OPENJPA-898-branches10x.patch, OPENJPA-898-branches12x.patch, OPENJPA-898-branches13x.patch
>
>
> Hints defined for a named native query such as the one below don't get loaded, however, if changed it to @NamedQuery, the hints get loaded.
>  
>           @NamedNativeQuery(name="GetMemberInfo",
> 		query="CALL MEMBERSUB",
> 		hints= {
> 			@QueryHint(name="openjpa.hint.u2sub.numberofpara", value="2"),
> 			@QueryHint(name="openjpa.hint.u2sub.output.para", value ="2")
> 			}
> 		)

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


[jira] Resolved: (OPENJPA-898) hints don't work for NamedNativeQuery

Posted by "Michael Dick (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Michael Dick resolved OPENJPA-898.
----------------------------------

       Resolution: Fixed
    Fix Version/s:     (was: 2.0.0-M1)
                   1.3.0

Some of the users of the 1.2.x and 1.0.x are conservative about changes, especially without a testcase. For now we'll resolve this issue in the released branches only. 

> hints don't work for NamedNativeQuery
> -------------------------------------
>
>                 Key: OPENJPA-898
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-898
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 1.2.0
>            Reporter: Jianfeng Mao
>            Assignee: Michael Dick
>             Fix For: 1.3.0, 2.0.0
>
>         Attachments: OPENJPA-898-branches10x.patch, OPENJPA-898-branches12x.patch, OPENJPA-898-branches13x.patch
>
>
> Hints defined for a named native query such as the one below don't get loaded, however, if changed it to @NamedQuery, the hints get loaded.
>  
>           @NamedNativeQuery(name="GetMemberInfo",
> 		query="CALL MEMBERSUB",
> 		hints= {
> 			@QueryHint(name="openjpa.hint.u2sub.numberofpara", value="2"),
> 			@QueryHint(name="openjpa.hint.u2sub.output.para", value ="2")
> 			}
> 		)

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


[jira] Reopened: (OPENJPA-898) hints don't work for NamedNativeQuery

Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Donald Woods reopened OPENJPA-898:
----------------------------------

      Assignee: Michael Dick  (was: Pinaki Poddar)

Mike, please consider for the 1.2.x branch.

> hints don't work for NamedNativeQuery
> -------------------------------------
>
>                 Key: OPENJPA-898
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-898
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 1.2.0
>            Reporter: Jianfeng Mao
>            Assignee: Michael Dick
>             Fix For: 2.0.0-M1, 2.0.0
>
>
> Hints defined for a named native query such as the one below don't get loaded, however, if changed it to @NamedQuery, the hints get loaded.
>  
>           @NamedNativeQuery(name="GetMemberInfo",
> 		query="CALL MEMBERSUB",
> 		hints= {
> 			@QueryHint(name="openjpa.hint.u2sub.numberofpara", value="2"),
> 			@QueryHint(name="openjpa.hint.u2sub.output.para", value ="2")
> 			}
> 		)

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


[jira] Updated: (OPENJPA-898) hints don't work for NamedNativeQuery

Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Donald Woods updated OPENJPA-898:
---------------------------------

    Fix Version/s: 2.0.0
                   1.3.0
                   1.2.1

adding target Fix Versions

> hints don't work for NamedNativeQuery
> -------------------------------------
>
>                 Key: OPENJPA-898
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-898
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 1.2.0
>            Reporter: Jianfeng Mao
>            Assignee: Pinaki Poddar
>             Fix For: 1.2.1, 1.3.0, 2.0.0
>
>
> Hints defined for a named native query such as the one below don't get loaded, however, if changed it to @NamedQuery, the hints get loaded.
>  
>           @NamedNativeQuery(name="GetMemberInfo",
> 		query="CALL MEMBERSUB",
> 		hints= {
> 			@QueryHint(name="openjpa.hint.u2sub.numberofpara", value="2"),
> 			@QueryHint(name="openjpa.hint.u2sub.output.para", value ="2")
> 			}
> 		)

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


[jira] Updated: (OPENJPA-898) hints don't work for NamedNativeQuery

Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Donald Woods updated OPENJPA-898:
---------------------------------

    Attachment: OPENJPA-898-branches13x.patch

patch for 1.3.x

> hints don't work for NamedNativeQuery
> -------------------------------------
>
>                 Key: OPENJPA-898
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-898
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 1.2.0
>            Reporter: Jianfeng Mao
>            Assignee: Michael Dick
>             Fix For: 2.0.0-M1, 2.0.0
>
>         Attachments: OPENJPA-898-branches10x.patch, OPENJPA-898-branches12x.patch, OPENJPA-898-branches13x.patch
>
>
> Hints defined for a named native query such as the one below don't get loaded, however, if changed it to @NamedQuery, the hints get loaded.
>  
>           @NamedNativeQuery(name="GetMemberInfo",
> 		query="CALL MEMBERSUB",
> 		hints= {
> 			@QueryHint(name="openjpa.hint.u2sub.numberofpara", value="2"),
> 			@QueryHint(name="openjpa.hint.u2sub.output.para", value ="2")
> 			}
> 		)

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


[jira] Work started: (OPENJPA-898) hints don't work for NamedNativeQuery

Posted by "Pinaki Poddar (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Work on OPENJPA-898 started by Pinaki Poddar.

> hints don't work for NamedNativeQuery
> -------------------------------------
>
>                 Key: OPENJPA-898
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-898
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 1.2.0
>            Reporter: Jianfeng Mao
>            Assignee: Pinaki Poddar
>
> Hints defined for a named native query such as the one below don't get loaded, however, if changed it to @NamedQuery, the hints get loaded.
>  
>           @NamedNativeQuery(name="GetMemberInfo",
> 		query="CALL MEMBERSUB",
> 		hints= {
> 			@QueryHint(name="openjpa.hint.u2sub.numberofpara", value="2"),
> 			@QueryHint(name="openjpa.hint.u2sub.output.para", value ="2")
> 			}
> 		)

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


[jira] Commented: (OPENJPA-898) hints don't work for NamedNativeQuery

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

Pinaki Poddar commented on OPENJPA-898:
---------------------------------------

Can you run the test with latest change and confirm if the hints are avaialble with NamedNativeQuery

> hints don't work for NamedNativeQuery
> -------------------------------------
>
>                 Key: OPENJPA-898
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-898
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 1.2.0
>            Reporter: Jianfeng Mao
>
> Hints defined for a named native query such as the one below don't get loaded, however, if changed it to @NamedQuery, the hints get loaded.
>  
>           @NamedNativeQuery(name="GetMemberInfo",
> 		query="CALL MEMBERSUB",
> 		hints= {
> 			@QueryHint(name="openjpa.hint.u2sub.numberofpara", value="2"),
> 			@QueryHint(name="openjpa.hint.u2sub.output.para", value ="2")
> 			}
> 		)

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


Re: [jira] Resolved: (OPENJPA-898) hints don't work for NamedNativeQuery

Posted by Donald Woods <dw...@apache.org>.
Any reason why we are not including this fix in the 1.2 and 1.3 branches?


-Donald


Pinaki Poddar (JIRA) wrote:
>      [ https://issues.apache.org/jira/browse/OPENJPA-898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
> 
> Pinaki Poddar resolved OPENJPA-898.
> -----------------------------------
> 
>        Resolution: Fixed
>     Fix Version/s:     (was: 1.2.1)
>                        (was: 1.3.0)
>                    2.0.0-M1
> 
>> hints don't work for NamedNativeQuery
>> -------------------------------------
>>
>>                 Key: OPENJPA-898
>>                 URL: https://issues.apache.org/jira/browse/OPENJPA-898
>>             Project: OpenJPA
>>          Issue Type: Bug
>>    Affects Versions: 1.2.0
>>            Reporter: Jianfeng Mao
>>            Assignee: Pinaki Poddar
>>             Fix For: 2.0.0-M1, 2.0.0
>>
>>
>> Hints defined for a named native query such as the one below don't get loaded, however, if changed it to @NamedQuery, the hints get loaded.
>>  
>>           @NamedNativeQuery(name="GetMemberInfo",
>> 		query="CALL MEMBERSUB",
>> 		hints= {
>> 			@QueryHint(name="openjpa.hint.u2sub.numberofpara", value="2"),
>> 			@QueryHint(name="openjpa.hint.u2sub.output.para", value ="2")
>> 			}
>> 		)
> 

[jira] Resolved: (OPENJPA-898) hints don't work for NamedNativeQuery

Posted by "Pinaki Poddar (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pinaki Poddar resolved OPENJPA-898.
-----------------------------------

       Resolution: Fixed
    Fix Version/s:     (was: 1.2.1)
                       (was: 1.3.0)
                   2.0.0-M1

> hints don't work for NamedNativeQuery
> -------------------------------------
>
>                 Key: OPENJPA-898
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-898
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 1.2.0
>            Reporter: Jianfeng Mao
>            Assignee: Pinaki Poddar
>             Fix For: 2.0.0-M1, 2.0.0
>
>
> Hints defined for a named native query such as the one below don't get loaded, however, if changed it to @NamedQuery, the hints get loaded.
>  
>           @NamedNativeQuery(name="GetMemberInfo",
> 		query="CALL MEMBERSUB",
> 		hints= {
> 			@QueryHint(name="openjpa.hint.u2sub.numberofpara", value="2"),
> 			@QueryHint(name="openjpa.hint.u2sub.output.para", value ="2")
> 			}
> 		)

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


[jira] Updated: (OPENJPA-898) hints don't work for NamedNativeQuery

Posted by "Donald Woods (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/OPENJPA-898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Donald Woods updated OPENJPA-898:
---------------------------------

    Attachment: OPENJPA-898-branches12x.patch

Two line addition to trunk back ported to 1.2.x for easier patching.

> hints don't work for NamedNativeQuery
> -------------------------------------
>
>                 Key: OPENJPA-898
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-898
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 1.2.0
>            Reporter: Jianfeng Mao
>            Assignee: Michael Dick
>             Fix For: 2.0.0-M1, 2.0.0
>
>         Attachments: OPENJPA-898-branches12x.patch
>
>
> Hints defined for a named native query such as the one below don't get loaded, however, if changed it to @NamedQuery, the hints get loaded.
>  
>           @NamedNativeQuery(name="GetMemberInfo",
> 		query="CALL MEMBERSUB",
> 		hints= {
> 			@QueryHint(name="openjpa.hint.u2sub.numberofpara", value="2"),
> 			@QueryHint(name="openjpa.hint.u2sub.output.para", value ="2")
> 			}
> 		)

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