[Dspace-tech] handles Pointing to the Same Resource
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 |2 | 938 674 | 10321/674 |2 | 938 675 | 10321/675 |2 | 938 676 | 10321/676 |2 | 938 677 | 10321/677 |2 | 938 678 | 10321/678 |2 | 938 679 | 10321/679 |2 | 938 (7 rows) Is it safe to delete the extra entries? In the item's dc.description.provenance I see that there is one submission followed by seven approvals before the item is made available (usually I see one submission, two approvals, and one made available), so that probably accounts for the extra handles. Should I be worried? What would I do if I were worried? Sean -- -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911iu=/4140/ostg.clktrk___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
Re: [Dspace-tech] handles Pointing to the Same Resource
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 handles do not point to the item, of course. It should have no effects outside the affected item. Regards, ~~helix84 Compulsory reading: DSpace Mailing List Etiquette https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911iu=/4140/ostg.clktrk ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
Re: [Dspace-tech] handles Pointing to the Same Resource
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 have any other incidences of this. Also, this was submitted over a year ago, so that would have been a different version of DSpace, Tomcat, etc. I'm hoping the problem cannot be reproduced! 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 handles do not point to the item, of course. It should have no effects outside the affected item. Thanks, Ivan; I'll go ahead and delete the extra rows. Sean -- -- Learn the latest--Visual Studio 2012, SharePoint 2013, SQL 2012, more! Discover the easy way to master current and previous Microsoft technologies and advance your career. Get an incredible 1,500+ hours of step-by-step tutorial videos with LearnDevNow. Subscribe today and save! http://pubads.g.doubleclick.net/gampad/clk?id=58040911iu=/4140/ostg.clktrk___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
[Dspace-tech] handles
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 Support Memorial University of Newfoundland This electronic communication is governed by the terms and conditions at http://www.mun.ca/cc/policies/electronic_communications_disclaimer_2012.php -- Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester Wave(TM): Endpoint Security, Q1 2013 and remains a good choice in the endpoint security space. For insight on selecting the right partner to tackle endpoint security challenges, access the full report. http://p.sf.net/sfu/symantec-dev2dev___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
Re: [Dspace-tech] handles
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 collection) as c ON h.resource_id = c.collection_id ); COMMUNITY SELECT h.handle, c.name FROM ( (SELECT resource_id, handle FROM handle WHERE resource_type_id=3) as h JOIN (SELECT community_id, name FROM community) as c ON h.resource_id = c.community_id ); Lighton Phiri http://lightonphiri.org On 12 March 2013 18:45, Drover, Matt mattdro...@mun.ca wrote: 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 Support Memorial University of Newfoundland This electronic communication is governed by the terms and conditions at http://www.mun.ca/cc/policies/electronic_communications_disclaimer_2012.php -- Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester Wave(TM): Endpoint Security, Q1 2013 and remains a good choice in the endpoint security space. For insight on selecting the right partner to tackle endpoint security challenges, access the full report. http://p.sf.net/sfu/symantec-dev2dev ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester Wave(TM): Endpoint Security, Q1 2013 and remains a good choice in the endpoint security space. For insight on selecting the right partner to tackle endpoint security challenges, access the full report. http://p.sf.net/sfu/symantec-dev2dev ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
Re: [Dspace-tech] handles
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] https://github.com/DSpace/DSpace/blob/master/dspace-api/src/main/java/org/dspace/core/Constants.java#L29 Lighton Phiri http://lightonphiri.org On 12 March 2013 19:40, Lighton Phiri lighton.ph...@gmail.com wrote: 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 collection) as c ON h.resource_id = c.collection_id ); COMMUNITY SELECT h.handle, c.name FROM ( (SELECT resource_id, handle FROM handle WHERE resource_type_id=3) as h JOIN (SELECT community_id, name FROM community) as c ON h.resource_id = c.community_id ); Lighton Phiri http://lightonphiri.org On 12 March 2013 18:45, Drover, Matt mattdro...@mun.ca wrote: 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 Support Memorial University of Newfoundland This electronic communication is governed by the terms and conditions at http://www.mun.ca/cc/policies/electronic_communications_disclaimer_2012.php -- Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester Wave(TM): Endpoint Security, Q1 2013 and remains a good choice in the endpoint security space. For insight on selecting the right partner to tackle endpoint security challenges, access the full report. http://p.sf.net/sfu/symantec-dev2dev ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette -- Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester Wave(TM): Endpoint Security, Q1 2013 and remains a good choice in the endpoint security space. For insight on selecting the right partner to tackle endpoint security challenges, access the full report. http://p.sf.net/sfu/symantec-dev2dev ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
Re: [Dspace-tech] handles
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 RESOURCE_ID is the ID of the object in question. So, SELECT HANDLE,RESOURCE_ID FROM HANDLE WHERE RESOURCE_TYPE_ID=4 would get you the matrix of handle to community IDs, similarly, SELECT HANDLE,RESOURCE_ID FROM HANDLE WHERE RESOURCE_TYPE_ID=3 would get you the matrix of handle to collection Ids, and so on. [1] https://wiki.duraspace.org/display/DSDOC3x/Functional+Overview [2] https://wiki.duraspace.org/display/DSDOC3x/Business+Logic+Layer#BusinessLog icLayer-Constants -- HARDY POTTINGER pottinge...@umsystem.edu University of Missouri Library Systems http://lso.umsystem.edu/~pottingerhj/ https://MOspace.umsystem.edu/ No matter how far down the wrong road you've gone, turn back. --Turkish proverb On 3/12/13 11:45 AM, Drover, Matt mattdro...@mun.ca wrote: 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 Support Memorial University of Newfoundland This electronic communication is governed by the terms and conditions at http://www.mun.ca/cc/policies/electronic_communications_disclaimer_2012.ph p -- Symantec Endpoint Protection 12 positioned as A LEADER in The Forrester Wave(TM): Endpoint Security, Q1 2013 and remains a good choice in the endpoint security space. For insight on selecting the right partner to tackle endpoint security challenges, access the full report. http://p.sf.net/sfu/symantec-dev2dev ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
[Dspace-tech] Handles are not generated for items (but are for collections)
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 there is no handle. I would expect to see the default 123456789/# but it does not exist. So it looks like the problem is related to something that generates the handle for an item. I am able to create collections and they do receive handles. Background: We have set-up a test server with 1.5.2 and postgres. I did not set up the server, someone else set it up for me (did the linux, postgres, and DSpace install). Unfortunately I know DSpace basics and they know linux and postgres. Request: Can someone give some hints about what might be wrong? Richard -- Download Intel#174; Parallel Studio Eval Try the new software tools for yourself. Speed compiling, find bugs proactively, and fine-tune applications for parallel performance. See why Intel Parallel Studio got high marks during beta. http://p.sf.net/sfu/intel-sw-dev___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Handles vs PURLs
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 that Handles have to be registered with CNRI but when it someone is issued a prefix in what case would another prefix be needed. I really apologize if this is a stupid question. Any links or advise would be great. -- J -- SF.Net email is Sponsored by MIX09, March 18-20, 2009 in Las Vegas, Nevada. The future of the web can't happen without you. Join us at MIX09 to help pave the way to the Next Web now. Learn more and register at http://ad.doubleclick.net/clk;208669438;13503038;i?http://2009.visitmix.com/ ___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Handles and URLS in 1.5
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 Subject: sec:U Handles and URLS in 1.5 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. Is there alternate method for fixing the URLS within a local network. Thanks Hamish IMPORTANT: This email remains the property of the Australian Defence Organisation and is subject to the jurisdiction of section 70 of the CRIMES ACT 1914. If you have received this email in error, you are requested to contact the sender and delete the email. - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
[Dspace-tech] Handles and URLS in 1.5
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. Is there alternate method for fixing the URLS within a local network. Thanks Hamish IMPORTANT: This email remains the property of the Australian Defence Organisation and is subject to the jurisdiction of section 70 of the CRIMES ACT 1914. If you have received this email in error, you are requested to contact the sender and delete the email. - Check out the new SourceForge.net Marketplace. It's the best place to buy or sell services for just about anything Open Source. http://sourceforge.net/services/buy/index.php___ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
