[Dspace-devel] [DuraSpace JIRA] (DS-1536) having a DOT in handle prefix causes identifier.uri to be cut off when being created

[Mark H. Wood (DuraSpace JIRA)]

Title: Message Title

Mark H. Wood commented on an issue   Re: having a DOT in handle prefix causes identifier.uri to be cut off when being created For "find the affected items," Oracle 10g doesn't like the above, but this is accepted: SELECT handle, text_value, 'http://hdl.handle.net/'||handle AS fixed FROM metadatavalue, metadatafieldregistry, handle WHERE to_char(text_value) = 'http://hdl.handle.net/123456789' AND metadatafieldregistry.metadata_field_id = metadatavalue.metadata_field_id AND metadatafieldregistry.element = 'identifier' AND metadatafieldregistry.qualifier = 'uri' AND handle.resource_type_id = 2 AND handle.resource_id = metadatavalue.item_id; (The reasons: text_value is a CLOB and must be converted to CHAR for use in WHERE; text_value is a CLOB and apparently cannot be aliased. Fortunately the alias was not used.) Add Comment   DSpace / DS-1536 having a DOT in handle prefix causes identifier.uri to be cut off when being created This message was sent by Atlassian JIRA (v6.1.7#6163-sha1:94d557d)

------------------------------------------------------------------------------
Android apps run on BlackBerry 10
Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
Now with support for Jelly Bean, Bluetooth, Mapview and more.
Get your Android app in front of a whole new audience.  Start now.
http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
_______________________________________________
Dspace-devel mailing list
Dspace-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-devel