[ https://jira.duraspace.org/browse/DS-705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=19176#action_19176 ]
Stuart Lewis commented on DS-705: --------------------------------- Hi Danilo, This JIRA issue was reviewed in our weekly development meeting yesterday (see below). Are you able to provide us with some further information about the reason for this change, and any implications it might have? Thanks, Stuart [20:16] <kshepherd> https://jira.duraspace.org/browse/DS-705 - Returning CLOBs fields data from ORACLE [20:16] * kshepherd reminds himself to get onto that JIRA bot again [20:17] <stuartlewis> Anyone know the reason for this? To get around a TEXT field length limitation for metadata? [20:17] <mhwood> I'm not sure what 705 is supposed to do for us. [20:17] <kshepherd> I can't test oracle. +0 until i see a full patch with explanation [20:17] <richardrodgers> I'd like a bit more context for this [20:17] <stuartlewis> 0 [20:17] <mhwood> 0 [20:18] <stuartlewis> Ok - maybe we pass on this one, and we'll put a comment in JIRA asking the submitter for more details? > Returning CLOBs fields data from ORACLE > --------------------------------------- > > Key: DS-705 > URL: https://jira.duraspace.org/browse/DS-705 > Project: DSpace > Issue Type: Bug > Components: DSpace API, JSPUI > Reporter: Danilo Azevedo > Priority: Critical > > // Support CLOBs in place of TEXT columns in Oracle > row.setColumn(name, results.getString(i)); is always returning NULL > possible fix: > try { > java.sql.Clob clob = results.getClob(i); > java.io.Writer writer = new java.io.StringWriter(); > char[] buffer = new char[4000]; > Reader reader = new BufferedReader(new > java.io.InputStreamReader(clob.getAsciiStream())); > int n; > while ((n = reader.read(buffer)) != -1) { > writer.write(buffer, 0, n); > } > row.setColumn(name, writer.toString()); > } catch (Exception ioE) { > row.setColumn(name, results.getString(i)); > } -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.duraspace.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira ------------------------------------------------------------------------------ What You Don't Know About Data Connectivity CAN Hurt You This paper provides an overview of data connectivity, details its effect on application quality, and explores various alternative solutions. http://p.sf.net/sfu/progress-d2d _______________________________________________ Dspace-devel mailing list Dspace-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-devel