RE: HSSF Unable to construct record instance

Sorry it took me a while to get back to this. The failure is at the line
that reads:
wb = new HSSFWorkbook(fs);

In the following debug session, the failure is at line 1543 (Please bear
with me; this is not an RPG question). I would appreciate guidance.

Display Module Source



Program: ACEHSSF_01 Library: DLOVELADY1 Module: HSSFSRVPGM

1539 /free

1540 wwStr = new_String(peFilename);

1541 wwFile = new_FileInputStream(wwStr);

1542 wwPOIFS = new_POIFSFileSystem(wwFile);

1543 wwBook = new_HSSFWorkbookFromPOIFS(wwPOIFS);

1544

1545 closeFile(wwFile);

1546

1547 hssf_freeLocalRef(wwPOIFS);

1548 hssf_freeLocalRef(wwFile);

1549 hssf_freeLocalRef(wwStr);

1550

1551 return wwBook;

1552 /end-free

1553 P E


More...
Debug . . .



F3=End program F6=Add/Clear breakpoint F10=Step F11=Display variable

F12=Resume F17=Watch variable F18=Work with watch F24=More keys

Java exception received when calling Java method.
+

What line of code in loveladyTest is line 21? It's telling you
something
somewhere is null.
--
James R. Perkins
http://twitter.com/the_jamezp


On Mon, Aug 24, 2009 at 08:40, Dennis Lovelady <iseries@xxxxxxxxxxxx>
wrote:

Happy Monday!



I've been using the POI 3.2-FINAL objects for quite a while on a

few

systems, and have now run across a problem for which I find no

solution; I

wonder if I might get some guidance from this list.



I can open, read and digest all the rows and cells on one

particular

spreadsheet on a V5R3 system. But when I move that same

spreadsheet

to a

V5R4 system, I receive the subject message (stack trace below). To

isolate

the cause of this issue, I used a simple JAVA program (source

below)

and

ran
it on the same (failing) system, and received the same failure. I

did

check
all the normal stuff (like ASCII-mode FTP, et cetera), and I find

no

problem. I can FTP that same file back to the V5R3 system, and

process it

without problem. I wonder if this might be the result of some

configurable

parameter within iSeries Java, but am at a loss as to what to

tweak.

One last thing: the V5R4 system is capable of reading other

spreadsheets

I've tried without issue. I don't want to bring this to the POI

community

(yet) due to the suspicion that this is an iSeries-specific or
configuration-specific issue.



Would appreciate any help.



Stack:

org.apache.poi.hssf.record.RecordFormatException: Unable to

construct

record
instance, the following exception occured: null

at java.lang.Throwable.<init>(Throwable.java:195)

at java.lang.Exception.<init>(Exception.java:41)

at

java.lang.RuntimeException.<init>(RuntimeException.java:43)

at

org.apache.poi.hssf.record.RecordFormatException.<init>(RecordFormatExc

eptio

n.java:31)

at

org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.jav

a:237

)

at

org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.ja

va:16

0)

at

org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:163

)

at

org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:130

)

at loveladyTest.main(loveladyTest.java:21)





Java program:



import java.io.IOException;

import java.io.InputStream;

import java.util.Iterator;

import org.apache.poi.poifs.filesystem.POIFSFileSystem;

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.hssf.usermodel.HSSFRow;

/**

* A simple POI example of opening an Excel spreadsheet

* and writing its contents to the command line.

* @author Tony Sintes

*/

public class loveladyTest {

public static void main( String [] args ) {

try {

InputStream input =

loveladyTest.class.getResourceAsStream(
"BreakageMar09Data.xls" );

POIFSFileSystem fs = new POIFSFileSystem( input );

HSSFWorkbook wb = new HSSFWorkbook(fs);

HSSFSheet sheet = wb.getSheetAt(0);



// Iterate over each row in the sheet

Iterator rows = sheet.rowIterator();

while( rows.hasNext() ) {

HSSFRow row = (HSSFRow) rows.next();

System.out.println( "Row #" + row.getRowNum() );



// Iterate over each cell in the row and print out

the

cell's content

Iterator cells = row.cellIterator();

while( cells.hasNext() ) {

HSSFCell cell = (HSSFCell) cells.next();

System.out.println( "Cell #" + cell.getCellNum()

);

switch ( cell.getCellType() ) {

case HSSFCell.CELL_TYPE_NUMERIC:

System.out.println(

cell.getNumericCellValue()

);

break;

case HSSFCell.CELL_TYPE_STRING:

System.out.println(

cell.getStringCellValue() );

break;

default:

System.out.println( "unsuported sell

type"

);

break;

}

}



}



} catch ( IOException ex ) {

ex.printStackTrace();

}

}

}





Regards,

Dennis E. Lovelady
AIM: delovelady MSN: fastcounter@xxxxxxxxxxxx
<http://www.linkedin.com/in/dennislovelady>
www.linkedin.com/in/dennislovelady --
"Smoking kills. If you're killed, you've lost a very important

part

of

your
life."
- actress Brooke Shield



--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)

mailing list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L)

mailing

list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.