santosh

Thanks for the reply Andre. In the code I am expecting only one record from the file i.e last record. My question here is why CsvJdbc is giving heap space error for only getting one record. I think it is loading the entire file into the memory after that applying the query, If increasing the memory may solve the problem for this file. If your dealing with any another file larger than this may give again out of heap space problem.

I am getting below error. Exception in thread "main" java.lang.OutOfMemoryError: Java heap space at java.util.Arrays.copyOf(Arrays.java:3332) at java.lang.AbstractStringBuilder.ensureCapacityInternal(AbstractStringBuilder.java:124) at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:649) at java.lang.StringBuilder.append(StringBuilder.java:202) at org.relique.jdbc.csv.CsvRawReader.parseCsvLine(Unknown Source) at org.relique.jdbc.csv.CsvRawReader.parseLine(Unknown Source) at org.relique.jdbc.csv.CsvRawReader.next(Unknown...

I am getting below error. Exception in thread "main" java.lang.OutOfMemoryError: Java heap space at java.util.Arrays.copyOf(Arrays.java:3332) at java.lang.AbstractStringBuilder.ensureCapacityInternal(AbstractStringBuilder.java:124) at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:649) at java.lang.StringBuilder.append(StringBuilder.java:202) at org.relique.jdbc.csv.CsvRawReader.parseCsvLine(Unknown Source) at org.relique.jdbc.csv.CsvRawReader.parseLine(Unknown Source) at org.relique.jdbc.csv.CsvRawReader.next(Unknown...

I am getting below error. Exception in thread "main" java.lang.OutOfMemoryError: Java heap space at java.util.Arrays.copyOf(Arrays.java:3332) at java.lang.AbstractStringBuilder.ensureCapacityInternal(AbstractStringBuilder.java:124) at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:649) at java.lang.StringBuilder.append(StringBuilder.java:202) at org.relique.jdbc.csv.CsvRawReader.parseCsvLine(Unknown Source) at org.relique.jdbc.csv.CsvRawReader.parseLine(Unknown Source) at org.relique.jdbc.csv.CsvRawReader.next(Unknown...

I am getting below error. Exception in thread "main" java.lang.OutOfMemoryError: Java heap space at java.util.Arrays.copyOf(Arrays.java:3332) at java.lang.AbstractStringBuilder.ensureCapacityInternal(AbstractStringBuilder.java:124) at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:649) at java.lang.StringBuilder.append(StringBuilder.java:202) at org.relique.jdbc.csv.CsvRawReader.parseCsvLine(Unknown Source) at org.relique.jdbc.csv.CsvRawReader.parseLine(Unknown Source) at org.relique.jdbc.csv.CsvRawReader.next(Unknown...

I am getting below error. Exception in thread "main" java.lang.OutOfMemoryError: Java heap space at java.util.Arrays.copyOf(Arrays.java:3332) at java.lang.AbstractStringBuilder.ensureCapacityInternal(AbstractStringBuilder.java:124) at java.lang.AbstractStringBuilder.append(AbstractStringBuilder.java:649) at java.lang.StringBuilder.append(StringBuilder.java:202) at org.relique.jdbc.csv.CsvRawReader.parseCsvLine(Unknown Source) at org.relique.jdbc.csv.CsvRawReader.parseLine(Unknown Source) at org.relique.jdbc.csv.CsvRawReader.next(Unknown...