Hi Tom,
Would you mind trying an experiment for us? If you remove the semicolon
from
[dsapce-src]/dspace-api/src/main/java/org/dspace/handle/UpdateHandlePref
ix.java run mvn package, and ant update, does the script
[dspace]/bin/update-hanmdle-prefix then run OK?
I suspect it will fix the problem.
If you could confirm this, we'll get it fixed ready for the next release
of DSpace.
Thanks,
Stuart
From: McGee, Thomas A. [mailto:thomas.mc...@shu.edu]
Sent: 15 December 2008 14:56
To: dspace-tech@lists.sourceforge.net
Subject: [Dspace-tech] HANDLE update issue
Following up on my question of last week on the failed UPDATE queries
for changing handles on an Oracle database, this is what happened.
Stuart Lewis suggested that the failing query was this:
UPDATE metadatavalue SET text_value= (SELECT 'http://hdl.handle.net/' ||
handle FROM handle WHERE handle.resource_id=item_id AND
handle.resource_type_id=2) WHERE text_value LIKE
'http://hdl.handle.net/% <http://hdl.handle.net/%25> ';
When I ran that in the Oracle SQL Developer application, I got an error
something like "no statement at cursor." I simply deleted the semicolon
and ran:
UPDATE metadatavalue SET text_value= (SELECT 'http://hdl.handle.net/' ||
handle FROM handle WHERE handle.resource_id=item_id AND
handle.resource_type_id=2) WHERE text_value LIKE
'http://hdl.handle.net/% <http://hdl.handle.net/%25> '
Which worked. Could that really be all that it is?
_____________________________________
Tom McGee
Senior Digital Media Specialist
Seton Hall University
400 South Orange Ave., South Orange, NJ 07079
973.275.2992
------------------------------------------------------------------------------
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
