Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: pass (athena.apache.org: local policy)
From: Bram de Kruijff <Bram.deKruijff@gxwebmanager.com>
To: "users@jackrabbit.apache.org" <users@jackrabbit.apache.org>
Date: Fri, 10 Oct 2008 23:05:56 +0200
Subject: Removing a corrupt reference value?
Thread-Topic: Removing a corrupt reference value?
Thread-Index: AckrG/ziNQuQ2s0MRnmm3jLgJko5kQ==
Message-ID: <7A5837CEF4D4834E97721F3BCC46D7F718865C0D5E@darth-malak.gx.local>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: multipart/alternative;
	boundary="_000_7A5837CEF4D4834E97721F3BCC46D7F718865C0D5Edarthmalakgxl_"
MIME-Version: 1.0

--_000_7A5837CEF4D4834E97721F3BCC46D7F718865C0D5Edarthmalakgxl_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi list,


Does anyone know how to (force) remove a reference property value to a node=
 that no longer exists? I am using JackRabbit 1.3.3. I do not know how to r=
eproduce it or how I got there in the first place. Right now I just need to=
 fix it.


My idea was simple. Find any (in my case multiple) property of type referen=
ce, check the uuids that no longer exist, exclude them and reassign the san=
itized value array (code below). This approach seems to works until I hit s=
ave where I get a ReferentialIntegrityException on the very UUID that I am =
trying to remove. It seems JR checks the references even when I just want t=
o delete them.


Any thoughts/tips/workaround?


Thanks,

Bram


Stacktrace:


javax.jcr.ReferentialIntegrityException: Target node 7ad67c91-fb52-481d-a3b=
=3D

3-f3708a390228 of REFERENCE property does not exist at org.apache.jackrabbi=
t.core.state.SharedItemStateManager.checkReferential=3D

Integrity(SharedItemStateManager.java:1497)

at org.apache.jackrabbit.core.state.SharedItemStateManager$Update.begin(Sha=
=3D

redItemStateManager.java:594)

at org.apache.jackrabbit.core.state.SharedItemStateManager.beginUpdate(Shar=
=3D

edItemStateManager.java:904)

at org.apache.jackrabbit.core.state.SharedItemStateManager.update(SharedIte=
=3D

mStateManager.java:934)

at org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemS=
=3D

tateManager.java:326)

at org.apache.jackrabbit.core.state.XAItemStateManager.update(XAItemStateMa=
=3D

nager.java:313)

at org.apache.jackrabbit.core.state.LocalItemStateManager.update(LocalItemS=
=3D

tateManager.java:302)

at org.apache.jackrabbit.core.state.SessionItemStateManager.update(SessionI=
=3D

temStateManager.java:306)

at org.apache.jackrabbit.core.ItemImpl.save(ItemImpl.java:1400)

at org.apache.jackrabbit.core.SessionImpl.save(SessionImpl.java:849)


Snippet:


    // Check for corrupted references

    Value[] values =3D3D p.getValues();

    List<Value> corruptedValues =3D3D new ArrayList<Value>();

    for (Value v : values) {

        try {

            session.getNodeByUUID(v.getString());

        } catch (ItemNotFoundException e) {

            // Yep, we got one

            corruptedValues.add(v);

            LOG.log(Level.WARNING, "Corrupted reference found for node "

                    + n.getUUID().toString() + " property " + p.getName()

                    + " and value " + v.getString());

        }

    }

    if (corruptedValues.size() > 0) {


        // Exclude corrupted references

        List<Value> newValues =3D3D new ArrayList<Value>();

        for (Value v : values) {

            if (!corruptedValues.contains(v)) {

                newValues.add(v);

            }

        }

        Value[] result =3D3D newValues.toArray(new Value[newValues.size()])=
;


        // Re-Assign and save

        p.setValue(result);

    }


--
Bram de Kruijff
Product Architect

GX
open for business

t: +31(0)24 - 388 82 61
f: +31(0)24 - 388 86 21
e: Bram.deKruijff@gxwebmanager.com<mailto:Bram.deKruijff@gxwebmanager.com>

www.gxwebmanager.com<http://www.gxwebmanager.com>


--_000_7A5837CEF4D4834E97721F3BCC46D7F718865C0D5Edarthmalakgxl_--