Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (athena.apache.org: domain of kwsutter@gmail.com designates
 209.85.217.21 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version
         :content-type:references;
        b=WRBRYa90gtJe4CggIYfgbFCkO80fTkuy6LMovOFSmb6YXP3Uz8qWGmFQu4nIkpqco7
         boVOa6RUqO4bzIbu6IZis1NqAuYwqzCbDlZit/fvTDjQVUXovl7aF51J++UOZxf0H7iC
         CC+VXatuU4CNW26gN7c3u9ZcSE6LCEMkJG7Xc=
Message-ID: <89c0c52c0809301411v48d620e6o8b986cbef3bfb58@mail.gmail.com>
Date: Tue, 30 Sep 2008 16:11:58 -0500
From: "Kevin Sutter" <kwsutter@gmail.com>
To: users@openjpa.apache.org
Subject: Re: UPDATE is called when only SELECT is expected
In-Reply-To: <20080930215012.13b6ad76.sergej@beworx.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_14777_1186347.1222809118567"
References: <20080930215012.13b6ad76.sergej@beworx.com>

------=_Part_14777_1186347.1222809118567
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I believe this issue is already being discussed on this forum:

http://n2.nabble.com/Non-dirty-entity-version-field-update-SUPER-URGENT!!!-td1120307.html#a1129303

Please join that discussion with any additional insights.

Thanks,
Kevin

On Tue, Sep 30, 2008 at 2:50 PM, Sergej Shafarenka <sergej@beworx.com>wrote:

> Hey Guys!
>
> I use OpenJPA in tandem with SpringFramework. I wrote a simple application
> which reads some data from MySQL database and faced very weird problem:
> openjpa executes an "update" statement when only "select" query is used and
> no object modifications are done.
>
> // My service's method looks like this one
> @Transactional(readOnly=true)
> public void test(String user) {
>        Query query = m_entityManager.createQuery("select u from User u");
>        List<User> users = (List<User>) query.getResultList();
>        for (User u : users) {
>                if (u.getLoginName().equals(user)) {
>                        System.out.println("Bingo!");
>                }
>        }
> }
>
> // User class is very simple
> @Entity
> @Table(name="user")
> public class User implements Serializable {
>        @Id
>        @Column(name="user_id")
>        private int m_id;
>
>        @Column(name="user_login_name")
>        private String m_loginName;
>
>        // getters and setters are omitted as not essential for problem
> understanding
> }
>
> // and openjpa's log-output looks like the one below
> openjpa.jdbc.SQL - <t 6533862, conn 16102116> executing prepstmnt 16900472
> SELECT t0.user_id, t0.user_login_name from t0
> openjpa.jdbc.SQL - <t 6533862, conn 16102116> [0 ms] spent
> // and this is the problem :(((
> openjpa.jdbc.SQL - <t 6533862, conn 16102116> executing prepstmnt 25980092
> UPDATE user SET user_login_name = ? WHERE user_id = ? [params=(String) test,
> (int) 1]
> openjpa.jdbc.SQL - <t 6533862, conn 16102116> [0 ms] spent
>
>
> It is already three days I spent on fixing the problem with no success :(
> Would someone help me please. I am even ready to switch off automatic update
> functionality if there were such possibility.
>
> Thanks and best regards,
> Sergej
>

------=_Part_14777_1186347.1222809118567--