Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6836

syscs_import_data_lobs_from_extfile can not read data past 2GB

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Store
    • Labels:
      None
    • Urgency:
      Normal

      Description

      syscs_util.syscs_import_data_lobs_from_extfile() imports data from .csv file.
      For binary data, in csv is expected a reference, where should be data read from.
      The reference is in form:
      <filename>.<offset>.<length>

      The offset and length are implemented as int.
      Hence, it is not possible to read binary data which are stored after 2GB.
      The stack trace is like:

      Caused by: java.lang.NumberFormatException: For input string: "2147563021"
      at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
      at java.lang.Integer.parseInt(Integer.java:495)
      at java.lang.Integer.parseInt(Integer.java:527)
      at org.apache.derby.impl.load.ImportReadData.initExternalLobFile(Unknown Source)
      at org.apache.derby.impl.load.ImportReadData.getBlobColumnFromExtFile(Unknown Source)
      at org.apache.derby.impl.load.ImportAbstract.getBlob(Unknown Source)
      at org.apache.derby.iapi.types.SQLBlob.setValueFromResultSet(Unknown Source)
      at org.apache.derby.impl.sql.execute.VTIResultSet.populateFromResultSet(Unknown Source)
      at org.apache.derby.impl.sql.execute.VTIResultSet.getNextRowCore(Unknown Source)
      at org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(Unknown Source)
      at org.apache.derby.impl.sql.execute.NormalizeResultSet.getNextRowCore(Unknown Source)
      at org.apache.derby.impl.sql.execute.NoPutResultSetImpl.getNextRowFromRowSource(Unknown Source)
      at org.apache.derby.impl.store.access.heap.HeapController.load(Unknown Source)
      at org.apache.derby.impl.store.access.heap.Heap.load(Unknown Source)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              martin stanik martin stanik
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: