Dear All, Just discovered this by accident. I am not sure if this is a known problem or not. In Fedora 3.3 If a label ends in a \ (blackslash) the ingest of an object fails with an SQL error.
Ingesting this example: <?xml version="1.0" encoding="UTF-8"?> <foxml:digitalObject xmlns:foxml="info:fedora/fedora-system:def/foxml#" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"; VERSION="1.1" PID="changeme:9688" xsi:schemaLocation="info:fedora/fedora-system:def/foxml# http://www.fedora.info/definitions/1/0/foxml1-1.xsd";> <foxml:objectProperties> <foxml:property NAME="info:fedora/fedora-system:def/model#state" VALUE="Active" /> <foxml:property NAME="info:fedora/fedora-system:def/model#label" VALUE="Something ending in a slash \" /> </foxml:objectProperties> <foxml:datastream ID="DC" STATE="A" CONTROL_GROUP="X" VERSIONABLE="true"> <foxml:datastreamVersion ID="DC.0" LABEL="DC" MIMETYPE="text/xml;charset=utf-8"> <foxml:xmlContent><oai_dc:dc xmlns:oai_dc="http://www.openarchives.org/OAI/2.0/oai_dc/"; xmlns:dc="http://purl.org/dc/elements/1.1/";> <dc:title xml:lang="en">DC Title</dc:title> <dc:type>http://purl.org/vocab/frbr/core#Expression</dc:type><dc:identifier>changeme:9688</dc:identifier></oai_dc:dc></foxml:xmlContent> </foxml:datastreamVersion> </foxml:datastream> </foxml:digitalObject> I get the following error: Object ingest failed due to: Error (500): <pre>javax.ws.rs.WebApplicationException: fedora.server.errors.StorageDeviceException: Unexpected error from SQL database while registering object: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Something ending in a slash \')' at line 1 at fedora.server.rest.BaseRestResource.handleException(BaseRestResource.java:162) at fedora.server.rest.FedoraObjectResource.createObject(FedoraObjectResource... Is this known about? Has it been fixed in a more recent version? Thanks a lot, Regards, Nicholas W. ------------------------------------------------------------------------------ Sell apps to millions through the Intel(R) Atom(Tm) Developer Program Be part of this innovative community and reach millions of netbook users worldwide. Take advantage of special opportunities to increase revenue and speed time-to-market. Join now, and jumpstart your future. http://p.sf.net/sfu/intel-atom-d2d _______________________________________________ Fedora-commons-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/fedora-commons-users
