openjpa-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Oliver Ringel (JIRA)" <j...@apache.org>
Subject [jira] Commented: (OPENJPA-1577) Using @Strategy in Queries not working properly
Date Wed, 17 Mar 2010 13:28:27 GMT

    [ https://issues.apache.org/jira/browse/OPENJPA-1577?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12846407#action_12846407
] 

Oliver Ringel commented on OPENJPA-1577:
----------------------------------------

The patch fixed the issue. My queries are working now. Again, thanks for the help.

One questions. Is disabling the query cache the final solution? 
It would be nice if that would not be necessary and I guess that should be possible. 


> Using @Strategy in Queries not working properly
> -----------------------------------------------
>
>                 Key: OPENJPA-1577
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1577
>             Project: OpenJPA
>          Issue Type: Bug
>    Affects Versions: 2.0.0-beta2
>         Environment: Ubuntu 9.10, Maven 2.2.1, Spring 3.0.1
>            Reporter: Oliver Ringel
>            Assignee: Fay Wang
>             Fix For: 2.0.0
>
>         Attachments: OPENJPA-1577-1.patch, OPENJPA-1577.patch, openjpa1577.tar
>
>
> I try to use a field that is annotated with @Strategy in a Query. 
> I expected that everytime the query is executed the toDataStoreValue method of the ValueHandler
is called to prepare the correct values for the SQL query.
> This is only happens once. The next time the Query is executed the ValueHandler is not
called.
> Here is the interesting part of the logging 
> 1st call:
> [DEBUG,Query,main] Executing query: [select s from SimpleEntity s where s.base = :base
and s.name = :name] with parameters: {name=james, base=1}
> toDataStoreValue: 1
> [DEBUG,SQL,main] <t 805562662, conn 2071272094> executing prepstmnt 1531692262
SELECT t0.id, t0.version, t0.base, t0.street, t0.my_name FROM some_objects t0 WHERE (t0.base
= ? AND t0.my_name = ?) [params=(String) base1, (String) james]
> 2nd call: 
> [DEBUG,Query,main] Executing query: [select s from SimpleEntity s where s.base = :base
and s.name = :name] with parameters: {0=2, 1=henry}
> [DEBUG,SQL,main] <t 805562662, conn 2071272094> executing prepstmnt 106030716 SELECT
t0.id, t0.version, t0.base, t0.street, t0.my_name FROM some_objects t0 WHERE (t0.base = ?
AND t0.my_name = ?) [params=(String) 2, (String) henry]
> You can see that the parameter list has changed after the first call. Some kind of transformation
(caching?) prevents calling the ValueHandler again.
> This is only a vague presumption.

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


Mime
View raw message