Eclipse Community Forums: EMF » [CDO] SQL Select for Update / Delete

Help

Home

Home » Modeling » EMF » [CDO] SQL Select for Update / Delete([CDO] SQL Select for Update / Delete)

Show: Today's Messages :: Show Polls :: Message Navigator

[CDO] SQL Select for Update / Delete [message #549354]

Mon, 26 July 2010 14:01

Missing name Missing name

Messages: 12
Registered: July 2010

Junior Member

Hi,

I am to trying to implement the following use case using CDO 3.0 Derby DB backend:

1. Open CDO Session, start a CDO transaction
2. Select a set of EMF objects using CDO SQL Query API
3. Modify and/or delete some of the selected EMF Objects
4. commit CDO transaction and close session.

While I try to implement the usecase, I get ObjectNotFoundException while iterating through the selected EMF Object list. I use the following API calls as described in

http://wiki.eclipse.org/Query_DB_Store_by_using_SQL

CDOQuery cdoQuery = transaction.createQuery("sql", "SELECT CDO_ID FROM CUSTOMER");
final List<Product1> products = cdoQuery.getResult(Product1.class);

I have the following questions regarding the correct approach to implement the above usecase:

a. Are there any code samples that illustrate the implementation of a similar usecase? All the unit test cases that I see in CVS illustrate the case of adding obejcts to CDO resource and removing from it, but there is no example for "select for update/modify" type scenario.

b. I notice that the EMF objects displayed in the CDO Session EMF editor is usually lesser than the entries obtained through a SQL select query on the EMF table. My suspicion is, deleted EMF objects are just marked as deleted in the DB rather than actually purged from the DB. For example, for every deleted EMF Object I see two entries in the DB: One with CDO_ID=3 and CDO_VERSION=1 and another with same CDO_ID=3 but CDO_VERSION=-2. Can you please confirm if this hypothesis is correct?

c. I see the following "non-functional" columns in Derby DB for the table representing the EMF object:
CDO_ID, CDO_VERSION,CDO_CLASS, CDO_CREATED, CDO_REVISED, CDO_RESOURCE,CDO_CONTAINER, CDO_FEATURE and TRACEID.
As per the release notes for CDO 3.0 in http://www.eclipse.org/cdo/documentation/relnotes_30/index.p hp#SQL_is_now_supported_as_a_query_language,
in order to use SQL query feature:

"Note that might need to consider version and/or branch information to prevent duplicate results from being returned."

My question is, do I need to append additional constraints to the SQL query on the non-functional CDO columns inorder to select the correct EMF objects for the given CDO Session, Transaction and Resource.

Thanks,
Venkat

[Updated on: Mon, 26 July 2010 14:34]

Report message to a moderator

Re: [CDO] SQL Select for Update / Delete [message #549415 is a reply to message #549354]

Mon, 26 July 2010 15:13

Eike Stepper

Messages: 6682
Registered: July 2009

Senior Member

This is a multi-part message in MIME format.
--------------080800090109070909030001
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit

Hi Venkat,

Comments below...

Cheers
/Eike

Contact: http://www.esc-net.de Blogger <http://thegordian.blogspot.com>Twitter <http://twitter.com/eikestepper>Linkedin <http://de.linkedin.com/in/eikestepper>Xing <http://www.xing.com/profile/Eike_Stepper>
Article: What exactly is inside that p2 repository? < http://thegordian.blogspot.com/2010/05/what-exactly-is-insid e-that-p2.html>

I'm going to Eclipse Summit Europe 2010 <http://www.eclipsesummit.org/>

Am 26.07.2010 16:01, schrieb Venkat Krishnamoorthy:
> Hi,
>
> I am to trying to implement the following use case using CDO 3.0 Derby DB backend:
If you have no particular requirement to use Derby you should also give H2 a try.

>
> 1. Open CDO Session, start a CDO transaction
> 2. Select a set of EMF objects using CDO SQL Query API
> 3. Modify and/or delete some of the selected EMF Objects
> 4. commit CDO transaction and close session.
>
> While I try to implement the usecase, I get ObjectNotFoundException while iterating through the selected EMF Object list. I use the following API calls as described in
> http://wiki.eclipse.org/Query_DB_Store_by_using_SQL
Is your repository configured for auditing or branching?

If yes, your query would have to be prepared not to duplicate results or return IDs of detached objects.

>
>
> CDOQuery cdoQuery = transaction.createQuery("sql", "SELECT CDO_ID FROM CUSTOMER");
> final List<Product1> products = cdoQuery.getResult(Product1.class);
>
>
> I have the following questions regarding the correct approach to implement the above usecase:
>
> a. Are there any code samples that illustrate the implementation of a similar usecase? All the unit test cases that I see in CVS illustrate the case of adding obejcts to CDO resource and removing from it, but there is no example for "select for update/modify" type scenario.
How does a simple "select" differ from "select for update/modify" in your opinion? Are you implying some sort of locking for the latter?

Unfortunately I know of no examples, yet, but I think they would be helpful for the auditing/branching scenarios.

>
> b. I notice that the EMF objects that I see in CDO Session EMF editor is usually than the entries I get when I do a SQL select query off the EMF table. My suspicion is, deleted EMF objects are just marked as delete in the DB rather than actually purged from the DB. Can you please confirm if this hypothesis is correct?
AFAIK this hypothesis is correct (only) for the auditing/branching configs. Stefan, can you confirm this and maybe give some infos on how the where clause should look like (ideally in the wiki)?

>
> c. I notice some "non-functional" columns in Derby DB for the table representing the EMF object:
> CDO_ID, CDO_VERSION,CDO_CLASS, CDO_CREATED, CDO_REVISED, CDO_RESOURCE,CDO_CONTAINER, CDO_FEATURE and TRACEID.
TRACEID must come from your model, right?

> As per the release notes for CDO 3.0 in http://www.eclipse.org/cdo/documentation/relnotes_30/index.p hp#SQL_is_now_supported_as_a_query_language,
> in order to use SQL query feature:
>
> "Note that might need to consider version and/or branch information to prevent duplicate results from being returned."
Yes, that's what I meant above.

>
> My question is, do I need to append additional constraints to the SQL query on the non-functional CDO columns inorder to select the correct EMF objects for the given CDO Session, Transaction and Resource.
Assuming you have configured your repo for auditing and you're yusing a transaction (not an audit view) locally for the query I think that the WHERE clause should start with "CDO_REVISED=0 AND CDO_VERSION>0 AND ".

We are aware that using SQL as a query language is not optimal from a model(er) point of view because you need to know intimate details about the used mapping strategy. I'm thinking about providing a "common query language" that is entirely independent of the used back-end. Unfortunately this seems to be a lot of effort and I'm still seeking for funding of this work. If you're interested I'd suggest that you contact me privately.

--------------080800090109070909030001
Content-Type: multipart/related;
boundary="------------090104080003080703030700"

--------------090104080003080703030700
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Venkat, 
 
Comments below...
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
 
 

<div dir="ltr">
<div>Cheers 
/Eike 
 
</div>
<div style="padding: 5px 0pt; font-family: arial,sans-serif;
font-size: 13.3px;">Contact: <a
href="http://www.esc-net.de">http://www.esc-net.de</a>
<a href="http://thegordian.blogspot.com" style="padding: 0pt
2px; color: blue; font-size: 10pt;" _service=""><img
src="cid:part1.01020705.08090401@esc-net.de" alt="Blogger"
style="vertical-align: middle; padding-bottom: 5px;"
border="0" height="16" width="16"></a><a
href="http://twitter.com/eikestepper" style="padding: 0pt
2px; color: blue; font-size: 10pt;" _service=""><img
src="cid:part2.09090504.00090009@esc-net.de" alt="Twitter"
style="vertical-align: middle; padding-bottom: 5px;"
border="0" height="16" width="16"></a><a
href="http://de.linkedin.com/in/eikestepper" style="padding:
0pt 2px; color: blue; font-size: 10pt;" _service=""><img
src="cid:part3.03070007.08070802@esc-net.de"
alt="Linkedin" style="vertical-align: middle;
padding-bottom: 5px;" border="0" height="16" width="16"></a><a
href="http://www.xing.com/profile/Eike_Stepper"
style="padding: 0pt 2px; color: blue; font-size: 10pt;"
_service=""><img
src="cid:part4.09020103.02040303@esc-net.de" alt="Xing"
style="vertical-align: middle; padding-bottom: 5px;"
border="0" height="16" width="16"></a></div>
<div style="color: gray; font-size: 13.3px; padding-bottom:
5px;">Article: <a
href=" http://thegordian.blogspot.com/2010/05/what-exactly-is-insid e-that-p2.html"
undefined="">What exactly is inside that p2 repository?</a></div>
<div> 
<a href="http://www.eclipsesummit.org/"><img
src="cid:part5.08080406.05060808@esc-net.de" alt="I'm
going to Eclipse Summit Europe 2010" border="0"
height="100" width="130"></a>
 
 
</div>
</div>
 
 
Am 26.07.2010 16:01, schrieb Venkat Krishnamoorthy:
<blockquote cite="mid:i2k4g5$o0o$1@build.eclipse.org" type="cite">Hi,
 
 
I am to trying to implement the following use case using CDO 3.0
Derby DB backend:
 
</blockquote>
If you have no particular requirement to use Derby you should also
give H2 a try. 
 
<blockquote cite="mid:i2k4g5$o0o$1@build.eclipse.org" type="cite">
 
1. Open CDO Session, start a CDO transaction
 
2. Select a set of EMF objects using CDO SQL Query API
 
3. Modify and/or delete some of the selected EMF Objects
 
4. commit CDO transaction and close session.
 
 
While I try to implement the usecase, I get
ObjectNotFoundException while iterating through the selected EMF
Object list. I use the following API calls as described in 
<a class="moz-txt-link-freetext" href="http://wiki.eclipse.org/Query_DB_Store_by_using_SQL">http://wiki.eclipse.org/Query_DB_Store_by_using_SQL</a>
 
</blockquote>
Is your repository configured for auditing or branching? 
 
If yes, your query would have to be prepared not to duplicate
results or return IDs of detached objects. 
 
<blockquote cite="mid:i2k4g5$o0o$1@build.eclipse.org" type="cite">
 
 
CDOQuery cdoQuery = transaction.createQuery("sql", "SELECT CDO_ID
FROM CUSTOMER");
 
final List<Product1> products =
cdoQuery.getResult(Product1.class);
 
 
 
I have the following questions regarding the correct approach to
implement the above usecase:
 
 
a. Are there any code samples that illustrate the implementation
of a similar usecase? All the unit test cases that I see in CVS
illustrate the case of adding obejcts to CDO resource and removing
from it, but there is no example for "select for update/modify"
type scenario.
 
</blockquote>
How does a simple "select" differ from "select for update/modify" in
your opinion? Are you implying some sort of locking for the latter? 
 
Unfortunately I know of no examples, yet, but I think they would be
helpful for the auditing/branching scenarios. 
 
<blockquote cite="mid:i2k4g5$o0o$1@build.eclipse.org" type="cite">
 
b. I notice that the EMF objects that I see in CDO Session EMF
editor is usually than the entries I get when I do a SQL select
query off the EMF table. My suspicion is, deleted EMF objects are
just marked as delete in the DB rather than actually purged from
the DB. Can you please confirm if this hypothesis is correct?
 
</blockquote>
AFAIK this hypothesis is correct (only) for the auditing/branching
configs. Stefan, can you confirm this and maybe give some infos on
how the where clause should look like (ideally in the wiki)? 
 
<blockquote cite="mid:i2k4g5$o0o$1@build.eclipse.org" type="cite">
 
c. I notice some "non-functional" columns in Derby DB for the
table representing the EMF object:
 
CDO_ID, CDO_VERSION,CDO_CLASS, CDO_CREATED, CDO_REVISED,
CDO_RESOURCE,CDO_CONTAINER, CDO_FEATURE and TRACEID. </blockquote>
TRACEID must come from your model, right? 
 
<blockquote cite="mid:i2k4g5$o0o$1@build.eclipse.org" type="cite">As
per the release notes for CDO 3.0 in
<a class="moz-txt-link-freetext" href=" http://www.eclipse.org/cdo/documentation/relnotes_30/index.p hp#SQL_is_now_supported_as_a_query_language"> http://www.eclipse.org/cdo/documentation/relnotes_30/index.p hp#SQL_is_now_supported_as_a_query_language</a>, 
in order to use SQL query feature:
 
 
"Note that might need to consider version and/or branch
information to prevent duplicate results from being returned."
 
</blockquote>
Yes, that's what I meant above. 
 
<blockquote cite="mid:i2k4g5$o0o$1@build.eclipse.org" type="cite">
 
My question is, do I need to append additional constraints to the
SQL query on the non-functional CDO columns inorder to select the
correct EMF objects for the given CDO Session, Transaction and
Resource.
 
</blockquote>
Assuming you have configured your repo for auditing and you're
yusing a transaction (not an audit view) locally for the query I
think that the WHERE clause should start with "CDO_REVISED=0 AND
CDO_VERSION>0 AND ". 
 
We are aware that using SQL as a query language is not optimal from
a model(er) point of view because you need to know intimate details
about the used mapping strategy. I'm thinking about providing a
"common query language" that is entirely independent of the used
back-end. Unfortunately this seems to be a lot of effort and I'm
still seeking for funding of this work. If you're interested I'd
suggest that you contact me privately. 
 
 
</body>
</html>

--------------090104080003080703030700
Content-Type: image/png;
name="blogger.png"
Content-Transfer-Encoding: base64
Content-ID: <part1.01020705.08090401@esc-net.de>
Content-Disposition: inline;
filename="blogger.png"

iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAMAAAAoLQ9TAAAABGdBTUEAAK/I NwWK6QAAABl0
RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAADkUExURf9xEv9m AP////9lAP+Q
SP9kAP9jAP9fAP9nAf9vD//x5/9hAP/iz/9iAP9eAP/s4P9vEP9yEv9qAP9q B/+LRP+we/90
I/+RSP/z6/+jZv/y6P+8kP/59f5yE//awf/Ttv9hAf9nAv/17v+4if9sC/9o BP+bWP/r3v/k
0v+wfP+QRv/o2f9gAP+OQ/93HP/l0/+0gv/Rsv/9/P/j0P+pcP+0hf/dx//D m//+/v+td/9o
AP+NQv/Yvf+zgv/x6P/q2/9xG//p2f9pAP/s3//8+fxxE//ex/+AK/9oCP/j 0f/Uuv///4Xw
StcAAABMdFJOU/////////////////////////////////////////////// ////////////
/////////////////////////////////////////wCejeTMAAAAsklEQVR4 2kSP1w6DMBAE
7cMGQg0hvffee++d//+f2IaIeTlppNXtIo88UAjxEIlhjCUG5lwJQuwoulqh FuUGcWGSiTF7
bt40EEoXBKtyIPQS5PffFqyHlhCS2obTK5kDmJ8lXxgA0zsPXer0L3zSUVmI D9ip3SC+hKwQ
2CxCtXYYL25gu1S8bf4jib5fTM+MNE079jom/+KwJUojwnAVifcQ46jM4M23 BHmkEK53iPcT
YACE/Q4KzoVQVwAAAABJRU5ErkJggg==
--------------090104080003080703030700
Content-Type: image/png;
name="twitter.png"
Content-Transfer-Encoding: base64
Content-ID: <part2.09090504.00090009@esc-net.de>
Content-Disposition: inline;
filename="twitter.png"

iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABmJLR0QA/wD/ AP+gvaeTAAAA
CXBIWXMAAABIAAAASABGyWs+AAAACXZwQWcAAAAQAAAAEABcxq3DAAABxUlE QVQ4y4WTMW4U
QRBFX3X3zoy8FgZphTCYAEg4gAPEYbgBJEgEXIALkHMfAjIwItnAAfLK2JYB r3dmuj7BzI5m
2WBLqqzq//q/fxt9NTmrzo7MCIhgRpWSsaMSgEta5czcjYtWTKPxfALZXTEE 2wmAxLXD11VL
BZy2MAuJB/iuA3oAoJb4lUUCVkAGTM5t06gjATMjBiPFaFsADvx1MTFoBd/q zHkMeLcLgCEe
JqjbrCJ1IAkghGDz20Z/XEzMMMTnZTsSYANMAl7fq7YlZOBaUCCk4WowwyRA mBmL7CxcmwDu
rh+rzKU71YhQ/dnr8VbiaRF4MgmbAAZkxJU7lRk3Wby5W3FcJlbSICAjZjFS jJ42rSXWgoWL
fYPfLvaCMTVxJ0XoJTmQ/stF6GPABDhzcepi7uJ74yQDuXcDErjjGhkwNvHx xCjMOMkCg3eX
S85zyVEMtGt24GWVxvsM5yi3+nBV8/7iBmJv0gaZQMZhNL4cHXBYdDkY7HQL vD0oebVfQuud
a8FGHSAaP1vnpMmbHgDEECwafLq/x8fZlGfJKCVKiapvXLyoEsdl3JYwBMpd uW1YEjlz4aMh
AY+iURiU/Vf/B6EE4kjfs5YLAAAAAElFTkSuQmCC
--------------090104080003080703030700
Content-Type: image/png;
name="linkedin.png"
Content-Transfer-Encoding: base64
Content-ID: <part3.03070007.08070802@esc-net.de>
Content-Disposition: inline;
filename="linkedin.png"

iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABmJLR0QA/wD/ AP+gvaeTAAAA
CXBIWXMAAABIAAAASABGyWs+AAAACXZwQWcAAAAQAAAAEABcxq3DAAACGklE QVQ4y6WTO2sU
URTHf3dmdp0kTnZJzErSrPjKYqNY2GljodhoLRLB1sLCD2DrZxAsfCAE/AaC grY+SBQSFTSC
xizGzZ3MTiYz92UxY5KNYuOBP+eew/3/73lwxfWHT9yjuR8YL0CwyxygAAPo Cqr0ntFcvjBB
cH++x8WzJzm8v/EnWVdks0PEgNWO95/XePD4HZ4ADk6MAhD6Hs26/08yBjwr ODrZBK0JADyv
LP7GsX2Evse9xR5Lsvgr+XfsO7ctoKwj9AWh7wEQIFCF+3sFGjCmgiJwQFwY Yge3X3cZrwXM
r2SDg9tJ1rokaw1alRXI3NAO61w60AAHTkE7qtNu1PjSUywsb3L60AgjNcHz hZgXb39WApoA
C3FqsIGjMxYC8OZbxlQU0GmFTLdCznWireV0pobYSDKevuzilMZDg0wN/cxu XdrMLVqX53TT
cu3OJ87cmmdlrQBgemoYKTMwqhSI+4Z0QMBhjANgcTnj1UdJHGd8Xc0AmBit Ecu0moGGODH0
h7cF8tyidSmgjSWWG6AUWpkypw1xLwXA4z8tQINcN/T3moEWtLZbr0mZQV5s 55RFJuU8RHR1
1iWtIzQ8nxOtIVCw9D2lWbM06w4ZZ8wtrEJRcLw9TDMUyKRg7kOPSHQR0ZVZ lyRjMDkOOVAU
FfLS57viHRaJLsHM+THuPtuDUgLTW2U0X672t47rrw82vOu/z9w8xS+MkDzV Boy6+QAAAABJ
RU5ErkJggg==
--------------090104080003080703030700
Content-Type: image/png;
name="xing.png"
Content-Transfer-Encoding: base64
Content-ID: <part4.09020103.02040303@esc-net.de>
Content-Disposition: inline;
filename="xing.png"

iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAIAAACQkWg2AAAACXBIWXMAAAsT AAALEwEAmpwY
AAABsklEQVR42mP8//8/AymAEb+G1x9333hU9fffZy52ZTONrQQ0/P7z7sLd hJfvN7Mw80mL
ROkqTodqAIKvv379+fuXhZmZh50dpv7f49dLLt1LYWD4ryRZCETsrJIIDYdu 3y5fu16AizPE
0CTFzgoo8fPXoxPX/T9/v8DHbWCito6LXRHFDw/evnXpm3D39Ws1Eck9xVmy wqLP3/SevlXC
ysKtLtuoJFmMxdObL17ymzqN8S9LnZddua/VrUcWD149FRNwNFFby8oiiEXD itNnImfN5WTi
nBhu7Gvw5OLdiv+MQnqKU6WEI7AE6+vPnx17+68+fmGrJL0wRe/rl/jbL94r isfqKs1kZuJE
1/Dt16/27TtatmzjYeZcnuZpqnDi3J16FmZxYDhKCAViibiVp8+Ur1v39N0H X12DFRkJ33/u
O3LVk+E/i5xYqq7iNCwaXn769PLTZ0ZGBnFePjE+3j9/3155kPvk9XIudgV9 5XnCfI6Ek8a7
T4dO3vD4+++HlHC4kepywhr+/P0ITEIPXk5jZxXTVpgE1EY48X36euHs7fBv P+8CVespzYGH
FSOpyRsAAuDh4a3m5z0AAAAASUVORK5CYII=
--------------090104080003080703030700
Content-Type: image/gif;
name="130x100_going.gif"
Content-Transfer-Encoding: base64
Content-ID: <part5.08080406.05060808@esc-net.de>
Content-Disposition: inline;
filename="130x100_going.gif"

R0lGODlhggBkANU/AAI6m5unzAFEnevmBBdYp26MwSdhrezv9ShbpkdJl8zT 5iosTk5RczdZ
pUxws4+Vujlhq296sauxNTZpsY6cUjtLl0pBjWmLbMzM3yVUngxDnzQ/j1B0 fjRTnm1skRRN
oxsaNCVKlb3I30JPnEY+iQVRojY+ZzhskyVDhEdbok5DlIh+smNfLmNYlS5l r1dSmztQhUZa
iV1eg93b6MTJIx5eq0xMfdvh7UJAaGtipL24E7W50CtOm4CAWP///////yH5 BAEAAD8ALAAA
AACCAGQAAAb/wJ9wOLwVPoCkcslsOp/QqHRKrX4KN6J2K1RkqmCpZqwJm8/h jIi7PUDQ6DJ5
Dq/bmZADWzgrA/x/UXODhGR/hYViSoB3jRozbApJiJSVlpeGTH6DjZ1KCm2T mKOkcyGnIaVj
nncCSXpESKqzlai2qKSscAKGH0QBh7QaJ7QoY6c8PB3Lyzy4l7pVAtPTnAFD wmMfIRIcGbMo
yB0NDSnm5B3OqBvsKO7vZa7RT9TUiEIPwZcZ32QcNANocPhA8EOGDgUTEtQW okKFcSkcSJQI
oVyKFi1e2MBhomPHBSBNoJiXZBqAevYQAbj2BZNBChcyfCBDYYCEhBk4SOCn MCGy/xHmHEQY
SjTCihw5ZGzEwdEjyKcLRupCibJQQQ0ZfuirlKHmAAoyCV44EbPgBYASTvQs GEJZuRwRCjyY
S3eFBxkyGCz1aAIq1JN1qAq2mrCMVlIcAqpdWzADwIGMt/EoJ3TFgwA7Mgd4 YBevXqZ8/UJF
QZWJ4NODCSlcJQnRWg6wIUc+wSHGBVQ920IUelnEDAUiNtu9+7npR9FPSaNe vnxQ5FXAtEWe
Tp0tboK6G0iUu2PGjRsYhHsgvtcp8uTM01eVPn1VAQDTM1yoTr/2LbfbA/i+ MWOHePKgmSca
COipl54G9M3kHnyMcUABDWMluBZZNFDAgTrZQSAUZhhgIP/CDnMNl1d5CzCA wQN+MeABDk9p
YCBq7FU3hivvRfaPTYtJWBABCHh1AQHbNFQBUA6sEABm/oU4nmckMuDDDgSC BEIAPqwQpXIv
olQCggm6aFKNjBEggQQU6PgBAWimecGYCKBpEA9DRmTZkSGuEMGSxTVV4pNR giTDAwyAEKWX
WQpQQglrpQlkYfUAAOZaCJxAAAeL0qdompKeICma/ByUQg4rWBZqqEvaYINe fTnlJJRQCeoq
SFgKsBBqiH5Qq0JpIoBAWASh5CiDCV0qLJCX7jjssQRkUIACBxwwwwPjRXvX nzM0i8EKfYG0
ap8gyLBDoAQSWMARWBwgggOETkP/wAM3HHDDDg4Ei6YDOzQ7QwFh+foesgTU UAMC/+oqsMAG
FGzwwQgb7MKuOzz5QL1V2iDDkjJg4MMBmR3ggwcLdLRtSAs8sHGfC8zgQ7si iOCDDxEgqI3K
IAZwgw8phNBpBg64O1fDO6SiLwCXBmwABAW7YLQLEySt9NITTOT00xNBQGUE KHQkg7s2xDCx
t09mawK0JtgAgwdPdmzq1xt3zBQOJgcAgzseNPv2KQWw/A4KEcSAQjI8pGBu B++ITHW6jmpw
7AkU/Ovv4jXwi6y/FvJ4QABVm0CCCVQysABTDLi7QJSvgoQDn6Cv4IMMrgqq wA1vvzM1CrbW
TXU4yPCQ/wGaEdB8dwgYh9NoAYan6a8BZ9nEAdJMJw318hNFIEFAFNQdHmYf muyBCTHEYPoO
apsqtqljlx22DWhzPD7bB8BgAgxv1/2ACafk7kMAeb/NfgXJNHwknSIrEA6h hRuWCwBCAQP8
K2EF0xXjFsgpfiRmADFwwMk6NIMKzgADgQIJ2R5AshTx6SkgMB3qwgWCas2t BAKAgA8eEI5D
OWBmK1NABDqFpoYpQAEdSllw3AFA4ClqcYi7wAWOlrwiLk0iSatIBy5AAQvl DkVhe4FGPIID
GOQuAN2LgffEJgPx4YB8IvMACEzQFBPS7gO5WwHtTjG2h63MAW3Jnw/0BgNU vP/DZ18KHpoW
V7AaHO2PyDOiIJXmggw0wAcK6IgNMNICr5mgczMISYCa8rGPhJFk3pkbQajk AdrtKgTvyN0O
9sYP2aGgjqdwxyl6qMd+MQ5hgIylLGdpAH407H02QIoHVsAAvqjMSk8ZT8f2 xKqniBCT6TNG
CSaASFV+wAEICBLe5kfKDKjwBnoLga0yQAzC+XCPw1MYEQfJPAcoDYnMSIEC EEk9jcngfAww
2Yl2MDNscaSL3FNb+Qj0kXW+Sz8XS4EqQ9AwETygAFQ6QAzWl4wQyI9+EaDS A2ZEjQCCc4EG
4AACN3qwBdbgBAb8VwZ4AAOZrcxZKPILDgKgsZOhKEr/bOMg6DwwA3C5CgMY a+kOBHoKWyGA
pSfdKfs6ALBkOUBlJw2AQG1V0W969KNr4gBIOUrVj+pkLLsaKSjDhpGNIIef fRGUX0InpdQJ
SgTpg0H2BmqrEhAgBGrNHvtg0IEMFPWtIcheDFrXwqYa7qk1KJ5AqErYEzxv ABfQFT94sIGO
kMAGL2gBiwZk1rF20KwgQAFa+YqbQ7mVH2wcqgIbxylQ3lGbv9MAYGtgABpU iLCwvUBAALYr
OG2ABLhFClIme57eWjZ1H2CWJgviWUXdTGCLS9NaDpXa1ZKFLLAl7FikioBk OKQCG6iABVow
qkb69rtldRXsMPO2tnr2UD9c/62izsteFNJItatlbXSjW9vr4u+6CRjVCmwA 3u+alSAZgKs2
2+tW4ak3TQT2bB7jK1+DXUCjsIVuAg/SDL51gAM96IEMXjCqFfX3PGYNQZoC LOLbsdfAB0ZT
gpn7XgYbDHGuHcvBXDDjNVXoBBS2q8AyEAOAAGQAGx5VDnj74fAKCgX8UJRB bHLii/IxpKRV
8YpRWDgGD88FPqKxg7VcMNl+ZRm6Mphia9KDEciAAjKwAIdDNWTwivVzZkVB VqOMJpigl0zp
TfGUD1VlF3d5TBDO6INgomXDwgSBAnteDGxrARXYoImhyjALQMKCHuCgBxKY NAsk0AM4g4AF
k+6Bhf8QgOECqokDJahBTSBEKVfqecrvdfVqCwZSF0zVAIYNSKA1heuN6qom OojBBixAbBnY
BFTPowBInvfjAehgANDWgaue3ezD2gRNJ2DyCX5cIRQDFsFT7rOVG4wwCoyJ y7DVVQcOSwEb
OMTYElDBC2pCgRzY4Hk6WAALoD3pZ4v1eRJYIrQ5gABoNy7bEjgUwoUV3/Wu OIDjJvfBQDoB
dKdbVz2AtgRiUAF4q8ACGa93Dp7Hgk/bRFDPxsEGRqBoUiO2YAAx4MJLgPAC e9ujDk+wRcc9
355/MgbJ7rhNiJ3xHsj7eTIggbEpcNtnx2AZzyNqYiAc849emwA1t7mTnwr/ bgJDnOc9py/f
YmATHsD7tmRWgQqQrgIPfCUBLIcg1Acg9QFodIADkPnVaz4sBnedvV+3ctij WxtdJYYCZne2
DTI+gB4kIAFIT4DbKTCk541gHM9rQEa/YgC8610CBw/I4xr+dz5/U9azHjxH O4CWwy563dAO
SOMrD+QKTH5IAFlGAwDSABccvvNVR7i/EOBjChzL76W36Naf2kfVI2wZDmoi VvkRgwzLoPoy
GJIMylwB7EP/AkQl9fFsbaEuX8CAxOMAEJvY6uOTngDnVb4rUf9K5yPsIAhI mMCSwYz++9//
AxNLCUNnjOM4y8dA4CZ/gmd/BoN/vlZdRPV/zEAO/xTYAATTeYCEQARYgAaI fGgifwcYTgxo
AAhAVFRVggODABW4ghaYfxg4S0aDMHSGeo5jZWmiAacXgvXnfCVIWAuDAFw2 MBQIAUQIg7Qk
g0HDWv7SgX6Hg63kZ/bXg1RFY0BohLJUcVZ4NAMYZeGUXKNXf4zjhHkGWAwo hbBUNEaTf7M0
SFiYhRbXR1xIbkv4hXJYA2I4hh4VhS6IQBm4hmzohjHIURhlMHPofjt4hzeX h6q3hxwVgzDI
hoR0hRkoiDsIhzOYiP6CiJg4iPPFiAkDiJAYiYC0NH8UdloIZYa4OJqog09G Xz6YhaEoioHE
NKXYc6cIZTPoUasIdrDlAP8B4ACN+Ijk9IuxSIuB+IYvKE63iIC6mIOsKIIb RSUGUDcFwIew
KEjUWIy06AC3CEtWSIjxtYrPKHEII43MNAHBeIXauI4TcEPd6I3faInN2Ep7 RH/DF2YcJY0G
oAAFc0NUYgTNUgCxBFQqUwBNg1TnMgHZSCUsdQAGOQENYy4+wDRUsjJGA1Q3 AIzK+EfGiG7z
mIqKg1yeeDD6aDDrdCQnUwAHoACAVDcBMAFUYpBoJRHmopA+YJBUIgIqqQAw eZNHNZFM444u
IDIyeQCfyJEd6ZGq6IyJmIIiyYgl2Y/8SI0uIJRHQyVJk43zkzRYuZA+YE43 1I482ZPJE5ZV
yY//03iT1mg0yVOLJAgwdsiUaAKXCuSUdqkrUbmPU3mTZwlIWGmTBrmVZOmV SROWYUmWQcmT
fZmW1biWs5g0bqlA4sgpPHKXlvlTPpCCN8SYetmSPmBQM1OUQlGThCmWPXkk GlOWByARRDkB
aDWFSAmZk6griHg7yXJcl2mXVKKZCoAA1NiZR0OEERmTB7kyCUmYEBCWDrBO CtAwyfMAGiOQ
GKmRb3mBaMiWEwABSQQBp4gATngz4BmeuTmedkmE5gkBBeAAEFAv2UmERaSd 53meBaAhwCFI
50kwl3mdLmCe7VmEP/id4Rmg/ECeBKor8QkBaOVSB7qgC7qcxjmf8Lk0/+fZ guRZMNzJoOZJ
m8AjoBwKngWagiyIoSI6oiQ6oRRKoCUKAQDaoQKqWOTJgjCaojI6o+TwoQhA ouSwoizKoiDq
iwVADpsBoxU4o0ToAOOinkNIpBQIZimIUNAEog0gojkKPKewo50iPyvjAxLY AC5JDogkpEma
og0QAS11kyEqpg3ADDomMDEpME86pAs6pQBwC20xUrZzp3cqSkSxpV3aAQUQ AWAqpPHJgioT
AejpADFaoujQf0tqpBDAD18aqCuIg3N6H3xzqXxzRf6nkivzAH46P8uASMtw khfzAOQAnZ1K
DmRaqiy4TjtQgV0ak+j5mRqTGRejnsk5P6WqMf8BAKQs0wHrtDLjIKlySqdx hKmZyk700wES
5JB/2gGa2gGiCqwXk1ApcEjO+qMNEJAzc62welLaGqs3mQJ18yQacwMqo1Tq dDJIBVRpOjXM
ejIRMIGSSqnGiqyXmjs3cEOeKlH9F63Tuk4p0AENM6/naqpcejHMYqYryKlm Kq4/Wjc7tU5G
Oj/mILCauk7LAK/SqgCMWq/vYazHiqzRurE3+a+g2rGjqqUdAK8pgJFjqqy/ iA4VmAI2lLC9
GpM4u67karHrCq2gqrEt+6sq+39gaq8ie6z2dUVL6wMzEBQVwLRFu04R4DcH MLARABQao7UH
kLUOkAIjELZhm7VA8Zn/I5A7BhWdOyuwLnmxWpqxLMuxtzqw/he2FmEOKWCv a4QK9tW3WLoy
EVABDbMyARC18+MQiBS269RSDxC2WTo/YYuqgCu2iruSGpO1frMyJlO1bcu2 PrtOZxu0cUu0
wTqv/Ue5qEupKMAOrJtdDuG69nW2RZECDpECQ1G7EZADDjEUI1ABGJsDYmu7 uUu5wgu8qBtR
R+IAwRsBElG1QMG8tlsA5lAAOWAOvGu7DhC1ZCsUtLu7gRu7qEu5lNq65MsO fXu+6Ju+1wW6
4du+7vu+8Bu2eDu/YIu61xW+6Ru/41u+5au+/tu3Ysu7YTsk8VvABhy+eHvA A6y+77u//Eu+
/9hlvv9rX49XwRZ8wY8XtnCnwO0rwJTrwe9ru8Zrv//bvg78wA+cvo/LMhjc wi7cwhpsweFL
pszStWGbA86ykgFMtWK7ApYbAO2bAOmbweF7wijcv337eE5LFC/wwk78xE/c xI9nLoorAiPw
ApMTthxWJSOQAFgcAAmQOxHgxBUAxQmgAcBwxKyLW2yMW8T2xhaQAD6AARds MUpMxwlgMVOT
AKg6OY+HthqDAVJckYL8wjMgAl68Qo/XHRVsOivweKaTA1MMxmbsxACwAwDA xrfFDm3cyZ5M
AnB8MpvxAHFsx3KMxxZzAwGAFE67AirzAGG8Mt0xPwnAkAzpwoITy/9jXMs+ 0MhV8nhUUsEd
UsmWfAMacFufnMxtbAFsTGwX0yEBQGwWE8dznAAWYDEvQGxU8sgvUM1XlAA5 UM0W0yHVjMHQ
+ci6DMy9DMm/zMvCjMfEjMEVoAE/4AAooMz43MnOjAFwfM0+oGZzLM3/rM0s 83FzrAJXpHbi
PD90onYW/AAzIMmP182wnACMzM7oHMkqkAB+XMlqt9GPt9Eb4AA/IAKZnM8o vc/9bDGuHND+
/MZo+wIMaQExzZAqQCU7oHY58NFqZzoPMBQ7rQIe4sWT89GOrHZfrALhHAE8 3dRO/dQqAABr
8AMdgMwojc8WsMKkLDJO69LT/MaD67TZnDv/LTUDLyBvFrMyGNDUFanWOp3D a23UVWLUB4BT
AQDVeO3UG9AAQyAJV+3JzAzKxFYUEdACxAYXNJ0Dhx0B/dwCuQvT8wMXTQ0X TJ3XTX0Uli1v
mJ3Zlg0AoDAEVPPXydzPpF3apg3HT9RonL3arN3aTo03W9AAVi3a+nzatm3a L1DYcOzavN3b
T70BKcAFWnrPtL3Mt33cyK3avr3crL0B0roHDgAAs+3GgU3dyX3dt83c2r3a GwAAJL0HQrAD
ZWDV2F3e173d6I3XGzAGOwDeWvAAPJAEq6vG9F3f9n3f+J3frWsMAMADD+De bHAAP02sBF7g
Bn7gCH7gEQCd7h0EADs=
--------------090104080003080703030700--

--------------080800090109070909030001--

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper

Report message to a moderator

Re: [CDO] SQL Select for Update / Delete [message #549468 is a reply to message #549415]

Mon, 26 July 2010 17:43

Missing name Missing name

Messages: 12
Registered: July 2010

Junior Member

Hi Eike,

Thanks for the prompt response.

Yes, auditing is in fact enabled for the repo. I didn't realize it earlier. Now I am trying to turn off auditing by setting:

<property name="supportingAudits" value="false"/>

However, I get the following error when I try to start the server:

java.lang.IllegalStateException: AuditSupport of MappingStrategy and Store does not match. Please check configuration.

The following is my complete CDO Server configuration:

<cdoServer>
 
	<!--acceptor type="http"/ -->
 
	<acceptor type="tcp" listenAddr="0.0.0.0" port="2036">
		<!-- negotiator type="challenge" description="/temp/users.db"/ -->
	</acceptor>
 
	<repository name="repo1">
		<property name="overrideUUID" value="1ff5d226-b1f0-40fb-aba2-0c31b38c764f"/>
		<property name="supportingAudits" value=false/>
		<property name="verifyingRevisions" value="false"/>
		<property name="currentLRUCapacity" value="10000"/>
		<property name="revisedLRUCapacity" value="100"/>
 
		<store type="db">
			<mappingStrategy type="horizontal">
				<property name="qualifiedNames" value="false"/>
				<property name="toManyReferences" value="ONE_TABLE_PER_REFERENCE"/>
				<property name="toOneReferences" value="LIKE_ATTRIBUTES"/>
			</mappingStrategy>
 
			<!-- Old setting <jdbcDelegate type="statement" />

			     is now replaced by preparedStatement: --> 
			<jdbcDelegate type="preparedStatement" > 			
			    <!-- to explicitly force prepared statement caching (e.g., if statement pooling is not supported 
			         by the JDBC driver, use
			   <property name="cacheStatements" value="enabled" />
 
			         Else, the implicit default is:
			   <property name="cacheStatements" value="guess" />
			         Which guesses the correct setting based on the JDBC driver's metadata.
			         Also supported is the third setting "disabled".
			   -->
			</jdbcDelegate>
			
			<!--
			<dbAdapter name="h2"/>
			<dataSource class="org.h2.jdbcx.JdbcDataSource"
				uRL="jdbc:h2:_database/cdodb1"/>
				-->
				
			<dbAdapter name="derby-embedded"/>
			<dataSource class="org.apache.derby.jdbc.EmbeddedDataSource"
				databaseName="/temp/cdodb1"
				createDatabase="create"/>
 
			<!--
			<dbAdapter name="hsqldb"/>

			<dataSource class="org.eclipse.net4j.db.hsqldb.HSQLDBDataSource" 
				database="jdbc:hsqldb:mem:cdodb1"
				user="sa"/>
                        -->
 
			<!--
			<dbAdapter name="mysql"/>

			<dataSource class="com.mysql.jdbc.jdbc2.optional.MysqlDataSource" 
				url="jdbc:mysql://localhost/cdodb1"
				user="sa"/>
                        -->
 
			<!--
			<dbAdapter name="postgresql"/>

			<dataSource class="org.postgresql.ds.PGSimpleDataSource"
				url="jdbc:postgresql://localhost:5432/cdo"
				databaseName="cdo"
				user="cdo"
				password="cdo"/>
                        -->
		</store>
	</repository>
 
</cdoServer>

Thanks,
Venkat

[Updated on: Mon, 26 July 2010 17:44]

Report message to a moderator

Re: [CDO] SQL Select for Update / Delete [message #549470 is a reply to message #549468]

Mon, 26 July 2010 17:47

Eike Stepper

Messages: 6682
Registered: July 2009

Senior Member

Am 26.07.2010 19:43, schrieb Venkat Krishnamoorthy:
> Hi Eike,
>
> Thanks for the prompt response.
> yes, auditing is in fact enabled for the repo. I didn't realize it earlier. Now I am trying to turn off auditing by setting
>
> <property name="supportingAudits" value="true"/>
I'm sure you're really meaning "false" ;-)

>
>
> However, I get the following error when I try to start the server:
>
>
> java.lang.IllegalStateException: AuditSupport of MappingStrategy and Store does not match. Please check configuration.
>
>
> The following is my complete CDO Server configuration:
>
>
> <cdoServer>
>
> 
>
> <acceptor type="tcp" listenAddr="0.0.0.0" port="2036">
> 
> </acceptor>
>
> <repository name="repo1">
> <property name="overrideUUID" value="1ff5d226-b1f0-40fb-aba2-0c31b38c764f"/>
> <property name="supportingAudits" value=false/>
> <property name="verifyingRevisions" value="false"/>
> <property name="currentLRUCapacity" value="10000"/>
> <property name="revisedLRUCapacity" value="100"/>
>
> <store type="db">
> <mappingStrategy type="horizontal">
Please use "horizontalNonAudit".

> <property name="qualifiedNames" value="false"/>
> <property name="toManyReferences" value="ONE_TABLE_PER_REFERENCE"/>
> <property name="toOneReferences" value="LIKE_ATTRIBUTES"/>
> </mappingStrategy>
>
>  <jdbcDelegate type="preparedStatement" >
> 
> </jdbcDelegate>
>
> 
>
> <dbAdapter name="derby-embedded"/>
> <dataSource class="org.apache.derby.jdbc.EmbeddedDataSource"
> databaseName="/temp/cdodb1"
> createDatabase="create"/>
>
> 
>
> 
>
> 
> </store>
> </repository>
>
> </cdoServer>
>
>
> Thanks,
> Venkat

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper

Report message to a moderator

Re: [CDO] SQL Select for Update / Delete [message #549472 is a reply to message #549470]

Mon, 26 July 2010 17:59

Missing name Missing name

Messages: 12
Registered: July 2010

Junior Member

Hi Eike,

Thanks again.

yes I meant "false" and I have corrected the post.

I tried the condition you specified:

CDO_REVISED=0 AND CDO_VERSION>0

but that returns me zero results. Did you really mean:

CDO_REVISED!=0 AND CDO_VERSION>0

For example the following are my entries in the DB:

CDO_ID CDO_VERSION CDO_CLASS CDO_CREATED   CDO_REVISED   CDO_RESOURCE CDO_CONTAINER CDO_FEATURE TRADEID 
 ------ ----------- --------- ------------- ------------- ------------ ------------- ----------- -------
      3           1       508 1280166722540 1280166723164            2             0           0   12345
      3          -2       508 1280166723165             0            0             0           0       0

Thanks,
Venkat

Report message to a moderator

Re: [CDO] SQL Select for Update / Delete [message #549475 is a reply to message #549470]

Mon, 26 July 2010 18:17

Missing name Missing name

Messages: 12
Registered: July 2010

Junior Member

Hi Eike,

Another issue: I set the mappingStrategy to "horizontalNonAudit" and the property "supportingAudits" is set to "false." Now the server starts up fine, but I still see entries for deleted emf objects in the DB. Earlier I used to see two entries per EMF object after delete operation, now I see only one per EMF object after the delete operation:

 CDO_ID CDO_VERSION CDO_CLASS CDO_CREATED   CDO_REVISED CDO_RESOURCE CDO_CONTAINER CDO_FEATURE TRADEID 
 ------ ----------- --------- ------------- ----------- ------------ ------------- ----------- ------- 
      3          -2       508 1280167430708           0            2             0           0   12345 
      4          -2       508 1280167430848           0            2             0           0   12345 
      5          -2       508 1280167771237           0            2             0           0   12345 
      6          -2       508 1280167771612           0            2             0           0   12345 
      7          -2       508 1280167830112           0            2             0           0   12345 
      8          -2       508 1280167920470           0            2             0           0   12345 
      9          -2       508 1280167928767           0            2             0           0   12345

What is the config setting for completely purging the objects from DB after delete operation? Please let me know.

Thanks,
Venkat

Report message to a moderator

Re: [CDO] SQL Select for Update / Delete [message #549539 is a reply to message #549472]

Tue, 27 July 2010 06:29

Eike Stepper

Messages: 6682
Registered: July 2009

Senior Member

Am 26.07.2010 19:59, schrieb Venkat Krishnamoorthy:
> Hi Eike,
>
> Thanks again.
> yes I meant "false" and I have corrected the post.
>
> I tried the condition you specified:
>
>
> CDO_REVISED=0 AND CDO_VERSION>0
Yes, that should be correct.

>
>
> but that returns me zero results. Did you really mean:
>
> CDO_REVISED!=0 AND CDO_VERSION>0
No ;-)

>
> For example the following are my entries in the DB:
>
>
> CDO_ID CDO_VERSION CDO_CLASS CDO_CREATED CDO_REVISED CDO_RESOURCE CDO_CONTAINER CDO_FEATURE TRADEID ------ ----------- --------- ------------- ------------- ------------ ------------- ----------- -------
> 3 1 508 1280166722540 1280166723164 2 0 0 12345
> 3 -2 508 1280166723165 0 0 0 0 0
Object 3 is clearly deleted: For v1 the revised timestamp is set and v-2 is a marker for a DetachedCDORevision (a DBStore implementation detail).

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper

Report message to a moderator

Re: [CDO] SQL Select for Update / Delete [message #549540 is a reply to message #549475]

Tue, 27 July 2010 06:37

Eike Stepper

Messages: 6682
Registered: July 2009

Senior Member

This is a multi-part message in MIME format.
--------------000908030902080508080500
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: quoted-printable

Hi Venkat,

This is a known issue that is tracked in:

312670: Delete objects completely from the database in non-branching=
mode
https://bugs.eclipse.org/bugs/show_bug.cgi?id=3D312670

Cheers
/Eike

Contact: http://www.esc-net.de Blogger <http://thegordian.blogspot.com>Tw=
itter <http://twitter.com/eikestepper>Linkedin <http://de.linkedin.com/in=
/eikestepper>Xing <http://www.xing.com/profile/Eike_Stepper>
Article: What exactly is inside that p2 repository? <http://thegordian.bl=
ogspot.com/2010/05/what-exactly-is-inside-that-p2.html>

I'm going to Eclipse Summit Europe 2010 <http://www.eclipsesummit.org/>

Am 26.07.2010 20:17, schrieb Venkat Krishnamoorthy:
> Hi Eike,
>
> Another issue: I set the mappingStrategy to "horizontalNonAudit" and th=
e property "supportingAudits" is set to "false." Now the server starts up=
fine, but I still see entries for deleted emf objects in the DB. Earlier=
I used to see two entries per EMF object after delete operation, now I s=
ee only one per EMF object after the delete operation:
>
>
> CDO_ID CDO_VERSION CDO_CLASS CDO_CREATED CDO_REVISED CDO_RESOURCE CDO=
_CONTAINER CDO_FEATURE TRADEID ------ ----------- --------- -------------=
----------- ------------ ------------- ----------- ------- 3 =
-2 508 1280167430708 0 2 0 =
0 12345 4 -2 508 1280167430848 0 =
2 0 0 12345 5 -2 508=
1280167771237 0 2 0 0 12345=
6 -2 508 1280167771612 0 2 =
0 0 12345 7 -2 508 1280167830112 =
0 2 0 0 12345 8 =
-2 508 1280167920470 0 2 0 =
0 12345 9 -2 508 1280167928767 0 =
2 0 0 12345
>
>
> What is the config setting for completely purging the objects from DB a=
fter delete operation? Please let me know.
>
> Thanks,
> Venkat

--------------000908030902080508080500
Content-Type: multipart/related;
boundary="------------070009080204070707010204"

--------------070009080204070707010204
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
<meta content="text/html; charset=UTF-8" http-equiv="Content-Type">
Hi Venkat, 
 
This is a known issue that is tracked in: 
 
 312670: Delete objects completely from the database in
non-branching mode 
 <a class="moz-txt-link-freetext" href="https://bugs.eclipse.org/bugs/show_bug.cgi?id=312670">https://bugs.eclipse.org/bugs/show_bug.cgi?id=312670</a> 
 
Cheers 

<div dir="ltr">
<div>
/Eike 
 
</div>
<div style="padding: 5px 0pt; font-family: arial,sans-serif;
font-size: 13.3px;">Contact: <a
href="http://www.esc-net.de">http://www.esc-net.de</a>
<a href="http://thegordian.blogspot.com" style="padding: 0pt
2px; color: blue; font-size: 10pt;" _service=""><img
src="cid:part1.04010203.04050008@esc-net.de" alt="Blogger"
style="vertical-align: middle; padding-bottom: 5px;"
border="0" height="16" width="16"></a><a
href="http://twitter.com/eikestepper" style="padding: 0pt
2px; color: blue; font-size: 10pt;" _service=""><img
src="cid:part2.06050903.06030507@esc-net.de" alt="Twitter"
style="vertical-align: middle; padding-bottom: 5px;"
border="0" height="16" width="16"></a><a
href="http://de.linkedin.com/in/eikestepper" style="padding:
0pt 2px; color: blue; font-size: 10pt;" _service=""><img
src="cid:part3.04050302.07030900@esc-net.de"
alt="Linkedin" style="vertical-align: middle;
padding-bottom: 5px;" border="0" height="16" width="16"></a><a
href="http://www.xing.com/profile/Eike_Stepper"
style="padding: 0pt 2px; color: blue; font-size: 10pt;"
_service=""><img
src="cid:part4.04030103.03010403@esc-net.de" alt="Xing"
style="vertical-align: middle; padding-bottom: 5px;"
border="0" height="16" width="16"></a></div>
<div style="color: gray; font-size: 13.3px; padding-bottom:
5px;">Article: <a
href=" http://thegordian.blogspot.com/2010/05/what-exactly-is-insid e-that-p2.html"
undefined="">What exactly is inside that p2 repository?</a></div>
<div> 
<a href="http://www.eclipsesummit.org/"><img
src="cid:part5.03050207.04030409@esc-net.de" alt="I'm
going to Eclipse Summit Europe 2010" border="0"
height="100" width="130"></a>
 
 
</div>
</div>
 
 
Am 26.07.2010 20:17, schrieb Venkat Krishnamoorthy:
<blockquote cite="mid:i2kjgm$40l$1@build.eclipse.org" type="cite">Hi
Eike,
 
 
Another issue: I set the mappingStrategy to "horizontalNonAudit"
and the property "supportingAudits" is set to "false." Now the
server starts up fine, but I still see entries for deleted emf
objects in the DB. Earlier I used to see two entries per EMF
object after delete operation, now I see only one per EMF object
after the delete operation:
 
 
 
CDO_ID CDO_VERSION CDO_CLASS CDO_CREATED CDO_REVISED
CDO_RESOURCE CDO_CONTAINER CDO_FEATURE TRADEID ------ -----------
--------- ------------- ----------- ------------ -------------
----------- ------- 3 -2 508
1280167430708 0 2 0 0
12345 4 -2 508 1280167430848
0 2 0 0 12345 5
-2 508 1280167771237 0 2
0 0 12345 6 -2 508
1280167771612 0 2 0 0
12345 7 -2 508 1280167830112
0 2 0 0 12345 8
-2 508 1280167920470 0 2
0 0 12345 9 -2 508
1280167928767 0 2 0 0
12345
 
 
 
What is the config setting for completely purging the objects from
DB after delete operation? Please let me know.
 
 
Thanks,
 
Venkat
 
</blockquote>
</body>
</html>

--------------070009080204070707010204
Content-Type: image/png;
name="blogger.png"
Content-Transfer-Encoding: base64
Content-ID: <part1.04010203.04050008@esc-net.de>
Content-Disposition: inline;
filename="blogger.png"

iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAMAAAAoLQ9TAAAABGdBTUEAAK/I NwWK6QAAABl0
RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAADkUExURf9xEv9m AP////9lAP+Q
SP9kAP9jAP9fAP9nAf9vD//x5/9hAP/iz/9iAP9eAP/s4P9vEP9yEv9qAP9q B/+LRP+we/90
I/+RSP/z6/+jZv/y6P+8kP/59f5yE//awf/Ttv9hAf9nAv/17v+4if9sC/9o BP+bWP/r3v/k
0v+wfP+QRv/o2f9gAP+OQ/93HP/l0/+0gv/Rsv/9/P/j0P+pcP+0hf/dx//D m//+/v+td/9o
AP+NQv/Yvf+zgv/x6P/q2/9xG//p2f9pAP/s3//8+fxxE//ex/+AK/9oCP/j 0f/Uuv///4Xw
StcAAABMdFJOU/////////////////////////////////////////////// ////////////
/////////////////////////////////////////wCejeTMAAAAsklEQVR4 2kSP1w6DMBAE
7cMGQg0hvffee++d//+f2IaIeTlppNXtIo88UAjxEIlhjCUG5lwJQuwoulqh FuUGcWGSiTF7
bt40EEoXBKtyIPQS5PffFqyHlhCS2obTK5kDmJ8lXxgA0zsPXer0L3zSUVmI D9ip3SC+hKwQ
2CxCtXYYL25gu1S8bf4jib5fTM+MNE079jom/+KwJUojwnAVifcQ46jM4M23 BHmkEK53iPcT
YACE/Q4KzoVQVwAAAABJRU5ErkJggg==
--------------070009080204070707010204
Content-Type: image/png;
name="twitter.png"
Content-Transfer-Encoding: base64
Content-ID: <part2.06050903.06030507@esc-net.de>
Content-Disposition: inline;
filename="twitter.png"

iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABmJLR0QA/wD/ AP+gvaeTAAAA
CXBIWXMAAABIAAAASABGyWs+AAAACXZwQWcAAAAQAAAAEABcxq3DAAABxUlE QVQ4y4WTMW4U
QRBFX3X3zoy8FgZphTCYAEg4gAPEYbgBJEgEXIALkHMfAjIwItnAAfLK2JYB r3dmuj7BzI5m
2WBLqqzq//q/fxt9NTmrzo7MCIhgRpWSsaMSgEta5czcjYtWTKPxfALZXTEE 2wmAxLXD11VL
BZy2MAuJB/iuA3oAoJb4lUUCVkAGTM5t06gjATMjBiPFaFsADvx1MTFoBd/q zHkMeLcLgCEe
JqjbrCJ1IAkghGDz20Z/XEzMMMTnZTsSYANMAl7fq7YlZOBaUCCk4WowwyRA mBmL7CxcmwDu
rh+rzKU71YhQ/dnr8VbiaRF4MgmbAAZkxJU7lRk3Wby5W3FcJlbSICAjZjFS jJ42rSXWgoWL
fYPfLvaCMTVxJ0XoJTmQ/stF6GPABDhzcepi7uJ74yQDuXcDErjjGhkwNvHx xCjMOMkCg3eX
S85zyVEMtGt24GWVxvsM5yi3+nBV8/7iBmJv0gaZQMZhNL4cHXBYdDkY7HQL vD0oebVfQuud
a8FGHSAaP1vnpMmbHgDEECwafLq/x8fZlGfJKCVKiapvXLyoEsdl3JYwBMpd uW1YEjlz4aMh
AY+iURiU/Vf/B6EE4kjfs5YLAAAAAElFTkSuQmCC
--------------070009080204070707010204
Content-Type: image/png;
name="linkedin.png"
Content-Transfer-Encoding: base64
Content-ID: <part3.04050302.07030900@esc-net.de>
Content-Disposition: inline;
filename="linkedin.png"

iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABmJLR0QA/wD/ AP+gvaeTAAAA
CXBIWXMAAABIAAAASABGyWs+AAAACXZwQWcAAAAQAAAAEABcxq3DAAACGklE QVQ4y6WTO2sU
URTHf3dmdp0kTnZJzErSrPjKYqNY2GljodhoLRLB1sLCD2DrZxAsfCAE/AaC grY+SBQSFTSC
xizGzZ3MTiYz92UxY5KNYuOBP+eew/3/73lwxfWHT9yjuR8YL0CwyxygAAPo Cqr0ntFcvjBB
cH++x8WzJzm8v/EnWVdks0PEgNWO95/XePD4HZ4ADk6MAhD6Hs26/08yBjwr ODrZBK0JADyv
LP7GsX2Evse9xR5Lsvgr+XfsO7ctoKwj9AWh7wEQIFCF+3sFGjCmgiJwQFwY Yge3X3cZrwXM
r2SDg9tJ1rokaw1alRXI3NAO61w60AAHTkE7qtNu1PjSUywsb3L60AgjNcHz hZgXb39WApoA
C3FqsIGjMxYC8OZbxlQU0GmFTLdCznWireV0pobYSDKevuzilMZDg0wN/cxu XdrMLVqX53TT
cu3OJ87cmmdlrQBgemoYKTMwqhSI+4Z0QMBhjANgcTnj1UdJHGd8Xc0AmBit Ecu0moGGODH0
h7cF8tyidSmgjSWWG6AUWpkypw1xLwXA4z8tQINcN/T3moEWtLZbr0mZQV5s 55RFJuU8RHR1
1iWtIzQ8nxOtIVCw9D2lWbM06w4ZZ8wtrEJRcLw9TDMUyKRg7kOPSHQR0ZVZ lyRjMDkOOVAU
FfLS57viHRaJLsHM+THuPtuDUgLTW2U0X672t47rrw82vOu/z9w8xS+MkDzV Boy6+QAAAABJ
RU5ErkJggg==
--------------070009080204070707010204
Content-Type: image/png;
name="xing.png"
Content-Transfer-Encoding: base64
Content-ID: <part4.04030103.03010403@esc-net.de>
Content-Disposition: inline;
filename="xing.png"

iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAIAAACQkWg2AAAACXBIWXMAAAsT AAALEwEAmpwY
AAABsklEQVR42mP8//8/AymAEb+G1x9333hU9fffZy52ZTONrQQ0/P7z7sLd hJfvN7Mw80mL
ROkqTodqAIKvv379+fuXhZmZh50dpv7f49dLLt1LYWD4ryRZCETsrJIIDYdu 3y5fu16AizPE
0CTFzgoo8fPXoxPX/T9/v8DHbWCito6LXRHFDw/evnXpm3D39Ws1Eck9xVmy wqLP3/SevlXC
ysKtLtuoJFmMxdObL17ymzqN8S9LnZddua/VrUcWD149FRNwNFFby8oiiEXD itNnImfN5WTi
nBhu7Gvw5OLdiv+MQnqKU6WEI7AE6+vPnx17+68+fmGrJL0wRe/rl/jbL94r isfqKs1kZuJE
1/Dt16/27TtatmzjYeZcnuZpqnDi3J16FmZxYDhKCAViibiVp8+Ur1v39N0H X12DFRkJ33/u
O3LVk+E/i5xYqq7iNCwaXn769PLTZ0ZGBnFePjE+3j9/3155kPvk9XIudgV9 5XnCfI6Ek8a7
T4dO3vD4+++HlHC4kepywhr+/P0ITEIPXk5jZxXTVpgE1EY48X36euHs7fBv P+8CVespzYGH
FSOpyRsAAuDh4a3m5z0AAAAASUVORK5CYII=
--------------070009080204070707010204
Content-Type: image/gif;
name="130x100_going.gif"
Content-Transfer-Encoding: base64
Content-ID: <part5.03050207.04030409@esc-net.de>
Content-Disposition: inline;
filename="130x100_going.gif"

R0lGODlhggBkANU/AAI6m5unzAFEnevmBBdYp26MwSdhrezv9ShbpkdJl8zT 5iosTk5RczdZ
pUxws4+Vujlhq296sauxNTZpsY6cUjtLl0pBjWmLbMzM3yVUngxDnzQ/j1B0 fjRTnm1skRRN
oxsaNCVKlb3I30JPnEY+iQVRojY+ZzhskyVDhEdbok5DlIh+smNfLmNYlS5l r1dSmztQhUZa
iV1eg93b6MTJIx5eq0xMfdvh7UJAaGtipL24E7W50CtOm4CAWP///////yH5 BAEAAD8ALAAA
AACCAGQAAAb/wJ9wOLwVPoCkcslsOp/QqHRKrX4KN6J2K1RkqmCpZqwJm8/h jIi7PUDQ6DJ5
Dq/bmZADWzgrA/x/UXODhGR/hYViSoB3jRozbApJiJSVlpeGTH6DjZ1KCm2T mKOkcyGnIaVj
nncCSXpESKqzlai2qKSscAKGH0QBh7QaJ7QoY6c8PB3Lyzy4l7pVAtPTnAFD wmMfIRIcGbMo
yB0NDSnm5B3OqBvsKO7vZa7RT9TUiEIPwZcZ32QcNANocPhA8EOGDgUTEtQW okKFcSkcSJQI
oVyKFi1e2MBhomPHBSBNoJiXZBqAevYQAbj2BZNBChcyfCBDYYCEhBk4SOCn MCGy/xHmHEQY
SjTCihw5ZGzEwdEjyKcLRupCibJQQQ0ZfuirlKHmAAoyCV44EbPgBYASTvQs GEJZuRwRCjyY
S3eFBxkyGCz1aAIq1JN1qAq2mrCMVlIcAqpdWzADwIGMt/EoJ3TFgwA7Mgd4 YBevXqZ8/UJF
QZWJ4NODCSlcJQnRWg6wIUc+wSHGBVQ920IUelnEDAUiNtu9+7npR9FPSaNe vnxQ5FXAtEWe
Tp0tboK6G0iUu2PGjRsYhHsgvtcp8uTM01eVPn1VAQDTM1yoTr/2LbfbA/i+ MWOHePKgmSca
COipl54G9M3kHnyMcUABDWMluBZZNFDAgTrZQSAUZhhgIP/CDnMNl1d5CzCA wQN+MeABDk9p
YCBq7FU3hivvRfaPTYtJWBABCHh1AQHbNFQBUA6sEABm/oU4nmckMuDDDgSC BEIAPqwQpXIv
olQCggm6aFKNjBEggQQU6PgBAWimecGYCKBpEA9DRmTZkSGuEMGSxTVV4pNR giTDAwyAEKWX
WQpQQglrpQlkYfUAAOZaCJxAAAeL0qdompKeICma/ByUQg4rWBZqqEvaYINe fTnlJJRQCeoq
SFgKsBBqiH5Qq0JpIoBAWASh5CiDCV0qLJCX7jjssQRkUIACBxwwwwPjRXvX nzM0i8EKfYG0
ap8gyLBDoAQSWMARWBwgggOETkP/wAM3HHDDDg4Ei6YDOzQ7QwFh+foesgTU UAMC/+oqsMAG
FGzwwQgb7MKuOzz5QL1V2iDDkjJg4MMBmR3ggwcLdLRtSAs8sHGfC8zgQ7si iOCDDxEgqI3K
IAZwgw8phNBpBg64O1fDO6SiLwCXBmwABAW7YLQLEySt9NITTOT00xNBQGUE KHQkg7s2xDCx
t09mawK0JtgAgwdPdmzq1xt3zBQOJgcAgzseNPv2KQWw/A4KEcSAQjI8pGBu B++ITHW6jmpw
7AkU/Ovv4jXwi6y/FvJ4QABVm0CCCVQysABTDLi7QJSvgoQDn6Cv4IMMrgqq wA1vvzM1CrbW
TXU4yPCQ/wGaEdB8dwgYh9NoAYan6a8BZ9nEAdJMJw318hNFIEFAFNQdHmYf muyBCTHEYPoO
apsqtqljlx22DWhzPD7bB8BgAgxv1/2ACafk7kMAeb/NfgXJNHwknSIrEA6h hRuWCwBCAQP8
K2EF0xXjFsgpfiRmADFwwMk6NIMKzgADgQIJ2R5AshTx6SkgMB3qwgWCas2t BAKAgA8eEI5D
OWBmK1NABDqFpoYpQAEdSllw3AFA4ClqcYi7wAWOlrwiLk0iSatIBy5AAQvl DkVhe4FGPIID
GOQuAN2LgffEJgPx4YB8IvMACEzQFBPS7gO5WwHtTjG2h63MAW3Jnw/0BgNU vP/DZ18KHpoW
V7AaHO2PyDOiIJXmggw0wAcK6IgNMNICr5mgczMISYCa8rGPhJFk3pkbQajk AdrtKgTvyN0O
9sYP2aGgjqdwxyl6qMd+MQ5hgIylLGdpAH407H02QIoHVsAAvqjMSk8ZT8f2 xKqniBCT6TNG
CSaASFV+wAEICBLe5kfKDKjwBnoLga0yQAzC+XCPw1MYEQfJPAcoDYnMSIEC EEk9jcngfAww
2Yl2MDNscaSL3FNb+Qj0kXW+Sz8XS4EqQ9AwETygAFQ6QAzWl4wQyI9+EaDS A2ZEjQCCc4EG
4AACN3qwBdbgBAb8VwZ4AAOZrcxZKPILDgKgsZOhKEr/bOMg6DwwA3C5CgMY a+kOBHoKWyGA
pSfdKfs6ALBkOUBlJw2AQG1V0W969KNr4gBIOUrVj+pkLLsaKSjDhpGNIIef fRGUX0InpdQJ
SgTpg0H2BmqrEhAgBGrNHvtg0IEMFPWtIcheDFrXwqYa7qk1KJ5AqErYEzxv ABfQFT94sIGO
kMAGL2gBiwZk1rF20KwgQAFa+YqbQ7mVH2wcqgIbxylQ3lGbv9MAYGtgABpU iLCwvUBAALYr
OG2ABLhFClIme57eWjZ1H2CWJgviWUXdTGCLS9NaDpXa1ZKFLLAl7FikioBk OKQCG6iABVow
qkb69rtldRXsMPO2tnr2UD9c/62izsteFNJItatlbXSjW9vr4u+6CRjVCmwA 3u+alSAZgKs2
2+tW4ak3TQT2bB7jK1+DXUCjsIVuAg/SDL51gAM96IEMXjCqFfX3PGYNQZoC LOLbsdfAB0ZT
gpn7XgYbDHGuHcvBXDDjNVXoBBS2q8AyEAOAAGQAGx5VDnj74fAKCgX8UJRB bHLii/IxpKRV
8YpRWDgGD88FPqKxg7VcMNl+ZRm6Mphia9KDEciAAjKwAIdDNWTwivVzZkVB VqOMJpigl0zp
TfGUD1VlF3d5TBDO6INgomXDwgSBAnteDGxrARXYoImhyjALQMKCHuCgBxKY NAsk0AM4g4AF
k+6Bhf8QgOECqokDJahBTSBEKVfqecrvdfVqCwZSF0zVAIYNSKA1heuN6qom OojBBixAbBnY
BFTPowBInvfjAehgANDWgaue3ezD2gRNJ2DyCX5cIRQDFsFT7rOVG4wwCoyJ y7DVVQcOSwEb
OMTYElDBC2pCgRzY4Hk6WAALoD3pZ4v1eRJYIrQ5gABoNy7bEjgUwoUV3/Wu OIDjJvfBQDoB
dKdbVz2AtgRiUAF4q8ACGa93Dp7Hgk/bRFDPxsEGRqBoUiO2YAAx4MJLgPAC e9ujDk+wRcc9
355/MgbJ7rhNiJ3xHsj7eTIggbEpcNtnx2AZzyNqYiAc849emwA1t7mTnwr/ bgJDnOc9py/f
YmATHsD7tmRWgQqQrgIPfCUBLIcg1Acg9QFodIADkPnVaz4sBnedvV+3ctij WxtdJYYCZne2
DTI+gB4kIAFIT4DbKTCk541gHM9rQEa/YgC8610CBw/I4xr+dz5/U9azHjxH O4CWwy563dAO
SOMrD+QKTH5IAFlGAwDSABccvvNVR7i/EOBjChzL76W36Naf2kfVI2wZDmoi VvkRgwzLoPoy
GJIMylwB7EP/AkQl9fFsbaEuX8CAxOMAEJvY6uOTngDnVb4rUf9K5yPsIAhI mMCSwYz++9//
AxNLCUNnjOM4y8dA4CZ/gmd/BoN/vlZdRPV/zEAO/xTYAATTeYCEQARYgAaI fGgifwcYTgxo
AAhAVFRVggODABW4ghaYfxg4S0aDMHSGeo5jZWmiAacXgvXnfCVIWAuDAFw2 MBQIAUQIg7Qk
g0HDWv7SgX6Hg63kZ/bXg1RFY0BohLJUcVZ4NAMYZeGUXKNXf4zjhHkGWAwo hbBUNEaTf7M0
SFiYhRbXR1xIbkv4hXJYA2I4hh4VhS6IQBm4hmzohjHIURhlMHPofjt4hzeX h6q3hxwVgzDI
hoR0hRkoiDsIhzOYiP6CiJg4iPPFiAkDiJAYiYC0NH8UdloIZYa4OJqog09G Xz6YhaEoioHE
NKXYc6cIZTPoUasIdrDlAP8B4ACN+Ijk9IuxSIuB+IYvKE63iIC6mIOsKIIb RSUGUDcFwIew
KEjUWIy06AC3CEtWSIjxtYrPKHEII43MNAHBeIXauI4TcEPd6I3faInN2Ep7 RH/DF2YcJY0G
oAAFc0NUYgTNUgCxBFQqUwBNg1TnMgHZSCUsdQAGOQENYy4+wDRUsjJGA1Q3 AIzK+EfGiG7z
mIqKg1yeeDD6aDDrdCQnUwAHoACAVDcBMAFUYpBoJRHmopA+YJBUIgIqqQAw eZNHNZFM444u
IDIyeQCfyJEd6ZGq6IyJmIIiyYgl2Y/8SI0uIJRHQyVJk43zkzRYuZA+YE43 1I482ZPJE5ZV
yY//03iT1mg0yVOLJAgwdsiUaAKXCuSUdqkrUbmPU3mTZwlIWGmTBrmVZOmV SROWYUmWQcmT
fZmW1biWs5g0bqlA4sgpPHKXlvlTPpCCN8SYetmSPmBQM1OUQlGThCmWPXkk GlOWByARRDkB
aDWFSAmZk6griHg7yXJcl2mXVKKZCoAA1NiZR0OEERmTB7kyCUmYEBCWDrBO CtAwyfMAGiOQ
GKmRb3mBaMiWEwABSQQBp4gATngz4BmeuTmedkmE5gkBBeAAEFAv2UmERaSd 53meBaAhwCFI
50kwl3mdLmCe7VmEP/id4Rmg/ECeBKor8QkBaOVSB7qgC7qcxjmf8Lk0/+fZ guRZMNzJoOZJ
m8AjoBwKngWagiyIoSI6oiQ6oRRKoCUKAQDaoQKqWOTJgjCaojI6o+TwoQhA ouSwoizKoiDq
iwVADpsBoxU4o0ToAOOinkNIpBQIZimIUNAEog0gojkKPKewo50iPyvjAxLY AC5JDogkpEma
og0QAS11kyEqpg3ADDomMDEpME86pAs6pQBwC20xUrZzp3cqSkSxpV3aAQUQ AWAqpPHJgioT
AejpADFaoujQf0tqpBDAD18aqCuIg3N6H3xzqXxzRf6nkivzAH46P8uASMtw khfzAOQAnZ1K
DmRaqiy4TjtQgV0ak+j5mRqTGRejnsk5P6WqMf8BAKQs0wHrtDLjIKlySqdx hKmZyk700wES
5JB/2gGa2gGiCqwXk1ApcEjO+qMNEJAzc62welLaGqs3mQJ18yQacwMqo1Tq dDJIBVRpOjXM
ejIRMIGSSqnGiqyXmjs3cEOeKlH9F63Tuk4p0AENM6/naqpcejHMYqYryKlm Kq4/Wjc7tU5G
Oj/mILCauk7LAK/SqgCMWq/vYazHiqzRurE3+a+g2rGjqqUdAK8pgJFjqqy/ iA4VmAI2lLC9
GpM4u67karHrCq2gqrEt+6sq+39gaq8ie6z2dUVL6wMzEBQVwLRFu04R4DcH MLARABQao7UH
kLUOkAIjELZhm7VA8Zn/I5A7BhWdOyuwLnmxWpqxLMuxtzqw/he2FmEOKWCv a4QK9tW3WLoy
EVABDbMyARC18+MQiBS269RSDxC2WTo/YYuqgCu2iruSGpO1frMyJlO1bcu2 PrtOZxu0cUu0
wTqv/Ue5qEupKMAOrJtdDuG69nW2RZECDpECQ1G7EZADDjEUI1ABGJsDYmu7 uUu5wgu8qBtR
R+IAwRsBElG1QMG8tlsA5lAAOWAOvGu7DhC1ZCsUtLu7gRu7qEu5lNq65MsO fXu+6Ju+1wW6
4du+7vu+8Bu2eDu/YIu61xW+6Ru/41u+5au+/tu3Ysu7YTsk8VvABhy+eHvA A6y+77u//Eu+
/9hlvv9rX49XwRZ8wY8XtnCnwO0rwJTrwe9ru8Zrv//bvg78wA+cvo/LMhjc wi7cwhpsweFL
pszStWGbA86ykgFMtWK7ApYbAO2bAOmbweF7wijcv337eE5LFC/wwk78xE/c xI9nLoorAiPw
ApMTthxWJSOQAFgcAAmQOxHgxBUAxQmgAcBwxKyLW2yMW8T2xhaQAD6AARds MUpMxwlgMVOT
AKg6OY+HthqDAVJckYL8wjMgAl68Qo/XHRVsOivweKaTA1MMxmbsxACwAwDA xrfFDm3cyZ5M
AnB8MpvxAHFsx3KMxxZzAwGAFE67AirzAGG8Mt0xPwnAkAzpwoITy/9jXMs+ 0MhV8nhUUsEd
UsmWfAMacFufnMxtbAFsTGwX0yEBQGwWE8dznAAWYDEvQGxU8sgvUM1XlAA5 UM0W0yHVjMHQ
+ci6DMy9DMm/zMvCjMfEjMEVoAE/4AAooMz43MnOjAFwfM0+oGZzLM3/rM0s 83FzrAJXpHbi
PD90onYW/AAzIMmP182wnACMzM7oHMkqkAB+XMlqt9GPt9Eb4AA/IAKZnM8o vc/9bDGuHND+
/MZo+wIMaQExzZAqQCU7oHY58NFqZzoPMBQ7rQIe4sWT89GOrHZfrALhHAE8 3dRO/dQqAABr
8AMdgMwojc8WsMKkLDJO69LT/MaD67TZnDv/LTUDLyBvFrMyGNDUFanWOp3D a23UVWLUB4BT
AQDVeO3UG9AAQyAJV+3JzAzKxFYUEdACxAYXNJ0Dhx0B/dwCuQvT8wMXTQ0X TJ3XTX0Uli1v
mJ3Zlg0AoDAEVPPXydzPpF3apg3HT9RonL3arN3aTo03W9AAVi3a+nzatm3a L1DYcOzavN3b
T70BKcAFWnrPtL3Mt33cyK3avr3crL0B0roHDgAAs+3GgU3dyX3dt83c2r3a GwAAJL0HQrAD
ZWDV2F3e173d6I3XGzAGOwDeWvAAPJAEq6vG9F3f9n3f+J3frWsMAMADD+De bHAAP02sBF7g
Bn7gCH7gEQCd7h0EADs=
--------------070009080204070707010204--

--------------000908030902080508080500--

Cheers
/Eike

----
http://www.esc-net.de
http://thegordian.blogspot.com
http://twitter.com/eikestepper

Report message to a moderator

Re: [CDO] SQL Select for Update / Delete [message #549590 is a reply to message #549415]

Tue, 27 July 2010 10:06

Stefan Winkler

Messages: 307
Registered: July 2009
Location: Germany

Senior Member

Venkat, Eike,

comments below.
>>
>> I am to trying to implement the following use case using CDO 3.0
>> Derby DB backend:
> If you have no particular requirement to use Derby you should also
> give H2 a try.
Eike is right. H2 is much more performant than Derby.

>> b. I notice that the EMF objects that I see in CDO Session EMF editor
>> is usually than the entries I get when I do a SQL select query off
>> the EMF table. My suspicion is, deleted EMF objects are just marked
>> as delete in the DB rather than actually purged from the DB. Can you
>> please confirm if this hypothesis is correct?
>
> AFAIK this hypothesis is correct (only) for the auditing/branching
> configs. Stefan, can you confirm this and maybe give some infos on how
> the where clause should look like (ideally in the wiki)?

As you already found out, the non-audit mode also marks deleted objects.

>
>>
>> My question is, do I need to append additional constraints to the SQL
>> query on the non-functional CDO columns inorder to select the correct
>> EMF objects for the given CDO Session, Transaction and Resource.
> Assuming you have configured your repo for auditing and you're yusing
> a transaction (not an audit view) locally for the query I think that
> the WHERE clause should start with "CDO_REVISED=0 AND CDO_VERSION>0 AND ".
>
> We are aware that using SQL as a query language is not optimal from a
> model(er) point of view because you need to know intimate details
> about the used mapping strategy. I'm thinking about providing a
> "common query language" that is entirely independent of the used
> back-end. Unfortunately this seems to be a lot of effort and I'm still
> seeking for funding of this work. If you're interested I'd suggest
> that you contact me privately.

I might add that depending on your application, you should think about
if queries are needed for what you want to achieve.
There's always the way to navigate the model on the basis of a resource.
For example, the initial query you tried (select cdo_id from customer)
without a specific where clause would usually not make sense. Instead
you should think about putting all customers into a single resource and
access that resource.
Querying makes more sense if your application needs a quick way of
"select cdo_id from customer where name = "Miller" - because this could
not be achieved by model navigation).

Cheers,
Stefan

Report message to a moderator