Eclipse Community Forums: EMF » [CDO]How to query the current data through the SQL statement in audit mode?

Home » Modeling » EMF » [CDO]How to query the current data through the SQL statement in audit mode?

[CDO]How to query the current data through the SQL statement in audit mode? [message #534761]

Thu, 20 May 2010 05:15

Eclipse User

Hi, Eike
In audit mode, cdo_revised field record the revised time. So user can
query the current data by "select * from XXX where cdo_revised=0". Right?
But when a CDOObject's container was deleted, the CDOObject's cdo_revised
field wasn't modified. That means user may get some deleted object.

Re: [CDO]How to query the current data through the SQL statement in audit mode? [message #534767 is a reply to message #534761]

Thu, 20 May 2010 05:37

Eclipse User

Hi,

Am 20.05.2010 11:15, schrieb lu.xingxiao:
> Hi, Eike
> In audit mode, cdo_revised field record the revised time. So user
> can query the current data by "select * from XXX where cdo_revised=0".
> Right? But when a CDOObject's container was deleted, the CDOObject's
> cdo_revised field wasn't modified. That means user may get some
> deleted object.
Did you try that or is that a hypothesis?

As far as I know, the deletion of the container of an object should lead
to the object's deletion as well.
If this is not the case, can you provide us with a minimal example which
demonstrates the behavior?

Cheers,
Stefan

Re: [CDO]How to query the current data through the SQL statement in audit mode? [message #534786 is a reply to message #534767]

Thu, 20 May 2010 06:49

Eclipse User

I'm so sorry for my mistake. It is my software problem. It works fine in the
CDO environment.
Thank you, Stefan.

Re: [CDO]How to query the current data through the SQL statement in audit mode? [message #535096 is a reply to message #534767]

Fri, 21 May 2010 05:01

Eclipse User

I have solved the problem above. But I have another problem. How can I get
the same type of data in a resource by SQL statement? Because if CDOObject
have container, its cdo_resource will be zero. So I can't use "SELECT * FROM
XXX WHERE cdo_resource=X AND cdo_revised=0".

Re: [CDO]How to query the current data through the SQL statement in audit mode? [message #535097 is a reply to message #535096]

Fri, 21 May 2010 05:21

Eclipse User

Am 21.05.2010 11:01, schrieb lu.xingxiao:
> I have solved the problem above. But I have another problem. How can I
> get the same type of data in a resource by SQL statement? Because if
> CDOObject have container, its cdo_resource will be zero. So I can't
> use "SELECT * FROM XXX WHERE cdo_resource=X AND cdo_revised=0".
I'm not 100% sure if I understood the question correctly but it's
generally not possible to answer the following *deterministically* :

Is object B *indirectly* contained by object A?

Since CDOResources are "normal" EObjects you can substitute your
resource for object A. In other words, only *directly* contained objects
maintain a dedicated pointer to their container object/resource. Doing
so for all indirectly contained objects as well would cause huge effort
to update this information in case of moves.

Cheers
/Eike

----
http://thegordian.blogspot.com
http://twitter.com/eikestepper

Re: [CDO]How to query the current data through the SQL statement in audit mode? [message #535109 is a reply to message #535097]

Fri, 21 May 2010 06:10

Eclipse User

Hi, Eike
Following is a simple example. repo1 is a CDOResource. Object B is contained
by object A. In this case, how can I get all of object B in the repo1 by SQL
statement?

/repo1
|
---A
|
---B

Re: [CDO]How to query the current data through the SQL statement in audit mode? [message #535147 is a reply to message #535109]

Fri, 21 May 2010 08:18

Eclipse User

Am 21.05.2010 12:10, schrieb lu.xingxiao:
> Hi, Eike
> Following is a simple example. repo1 is a CDOResource. Object B is
> contained by object A. In this case, how can I get all of object B in
> the repo1 by SQL statement?
>
>
> /repo1
> |
> ---A
> |
> ---B
As I said, I don't think there exists a closed SQL query that is able to
give you that result because it involves traveling up the containment
hierarchy until you hit a resource. And the length of this path is not
known in advance for any given B.

Cheers
/Eike

----
http://thegordian.blogspot.com
http://twitter.com/eikestepper

Previous Topic:	Copy EObject from one list to another
Next Topic:	How to indicate the location of .ecore meta-model in the model ?

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 18 17:57:43 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter