openjpa-dev mailing list archives

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

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

Fay Wang commented on OPENJPA-1577:
-----------------------------------

Yes, it is possible to not to disable query cache. We will explore this possibility.

> 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