We noticed that seven handles pointed to the same item. I looked at the
handle table and found this:
dspace= SELECT * FROM handle WHERE resource_id = 938;
handle_id | handle | resource_type_id | resource_id
---+---+--+-
673 | 10321/673 |
Hi Sean,
the fact that this was possible indicates an error in our workflow and
needs to be fixed. Please, create a Jira issue with steps to reproduce
the problem.
There should be no problem if you delete all but one of the rows from
the handle table. The only implication will be that the other
On 3 September 2013 14:02, helix84 heli...@centrum.sk wrote:
the fact that this was possible indicates an error in our workflow and
needs to be fixed. Please, create a Jira issue with steps to reproduce
the problem.
I haven't seen this problem before, and the handle table doesn't seem to
How do I get the handle for communities and collections, providing I
have the community_id or collection_id ? I'm not seeing a table or field
that links the two in the database.
Thanks.
Matthew Drover
Programmer Consultant
Immersive Technology
Distance Education, Learning and Teaching
You need to join handle table with the collection and/or community
tables. Just include a WHERE clause in either one of the queries
below..
COLLECTION
SELECT
h.handle,
c.name
FROM
(
(SELECT resource_id, handle FROM handle WHERE resource_type_id=3) as h JOIN
(SELECT collection_id, name FROM
A slight change in the 'community' query --resource_type_id for
communities is 4 [1]
SELECT
h.handle,
c.name
FROM
(
(SELECT resource_id, handle FROM handle WHERE resource_type_id=4) as h JOIN
(SELECT community_id, name FROM community) as c ON
h.resource_id = c.community_id
);
[1]
Hi, Matt, while the schema diagram found in the documentation implies that
there's a field in each table for handle[1], the handle table actually
holds all the data you seek. The column RESOURCE_TYPE_ID indicates what
sort of thing the handle points to (2=item, 3=collection, 4=community [2])
and
Hello,
Problem:
When we submit items to a collection, nothing appears when we click on
submissions and often we get an error: java.lang.NullPointerException.
When I go into the Items function and search for something by just
putting in a 1 or 2 or 3 I do see the items we have submitted, but
I am trying to locate some information online as ti which would be the
best direction to take. We are looking into building a fairly large
repository and are in the testing stages. I have read a little about
Handles and was curious if Handles are the best approach or if PURLs
are. I know
Hi
Didnt receive any feedback on this one reposting it as it is a show
stopper to us.
Additionally is there a way to setup Handles locally?
Thanks
Hamish
From: Brett, Hamish
Sent: Friday, 6 June 2008 4:43 PM
To: dspace-tech@lists.sourceforge.net
Hi
We are using DSpace on the corproate Intranet and therefore do not use
the handle system. Before version 1.5 I edited HandleManger.java so that
URLS did not come back in handle form and therefore were usable. Now
with 1.5 the code seems to have changed and HandleManager.java does not
exist.
11 matches
Mail list logo
