You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "martin stanik (JIRA)" <ji...@apache.org> on 2015/09/22 13:27:04 UTC
[jira] [Created] (DERBY-6836) syscs_import_data_lobs_from_extfile
can not read data past 2GB
martin stanik created DERBY-6836:
------------------------------------
Summary: syscs_import_data_lobs_from_extfile can not read data past 2GB
Key: DERBY-6836
URL: https://issues.apache.org/jira/browse/DERBY-6836
Project: Derby
Issue Type: Bug
Components: Store
Reporter: martin stanik
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)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)