Re: [Dspace-tech] handles Pointing to the Same Resource
On 3 September 2013 14:02, helix84 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=58040911&iu=/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=58040911&iu=/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
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 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" 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
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 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 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
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 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 and URLS in 1.5
On Thu, Jun 12, 2008 at 07:32:28AM +, Brett, Hamish wrote: > Didnt receive any feedback on this one reposting it as it is a show > stopper to us. HandleManager does exist in 1.5. It's gone from trunk, but it's in 1.5: http://fisheye3.atlassian.com/browse/dspace/tags/dspace-1_5/dspace-api/src/main/java/org/dspace/handle/HandleManager.java > Additionally is there a way to setup Handles locally? I'm not sure what you mean by this, could you be more specific? cheers, Jim > 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. > > > > Content-Description: ATT1.txt > - > 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 Content-Description: ATT2.txt > ___ > DSpace-tech mailing list > DSpace-tech@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/dspace-tech -- James Rutherford | Hewlett-Packard Limited registered Office: Research Engineer | Cain Road, HP Labs | Bracknell, Bristol, UK | Berks +44 117 312 7066 | RG12 1HN. [EMAIL PROTECTED] | Registered No: 690597 England The contents of this message and any attachments to it are confidential and may be legally privileged. If you have received this message in error, you should delete it from your system immediately and advise the sender. To any recipient of this message within HP, unless otherwise stated you should consider this message and attachments as "HP CONFIDENTIAL". - 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