java - NPE with Current Thread Context Class Loader getResourceAsStream(file) -

-

i trying excel file resource folder. method works fine:

public jobordergenerator(list<shoporder> shoporder) throws invalidformatexception, ioexception {          inputstream = thread.currentthread().getcontextclassloader().getresourceasstream("shop-order.xlsx");          createjoborder(shoporder);      }

which calls

void createjoborder(list<shoporder> shoporder) throws invalidformatexception, ioexception{           (shoporder shoporder1 : shoporder) {             system.out.println("inside createjoborder "+shoporder1.getpo_number());             writetospecificcell(2, 1, sheetnumber, shoporder1.getpo_number()); //po number             writetospecificcell(7, 3, sheetnumber, shoporder1.getpo_number()); //part number             localdate date = shoporder1.getpo_due_date();             string datetostring = date.tostring();             writetospecificcell(1, 2, sheetnumber, datetostring); //due_date             writetospecificcell(7, 5, sheetnumber, integer.tostring(shoporder1.getpart_quantity())); //quantity             //writetospecificcell(1,2,sheetnumber, shoporder.get); //material             writetospecificcell(8, 3, sheetnumber, shoporder1.getpart_decription()); //part description             //writetospecificcell(1,2,sheetnumber, shoporder.getcustomer()); //customer             writetospecificcell(10, 1, sheetnumber, shoporder1.getmachine_number()); //machine              sheetnumber++;          }      }

this culprit below. can see used println statements figure out going on, , see in console is:

inside writetospecificcell before try statement 1 0 111

right after java.lang.nullpointerexception:

therefore there going on excel file. cannot figure out what. since retrieved like:

inputstream = thread.currentthread().getcontextclassloader().getresourceasstream("shop-order.xlsx");

it should know location of file. since in resource file , not on class path (so in jar file) need file above way right?

if matters using intellji ultimate, still learning ins , outs, heavy eclipse user.

class path

-----------update 1-----------------

inputstream = thread.currentthread().getcontextclassloader().getresourceasstream("/resources/shop-order.xlsx");

still getting same error...

--------update 2--------------------

try{             classloader classloader = getclass().getclassloader();              inputstream = this.getclass().getresourceasstream("/resources/shop-order.xlsx");              if (inputstream == null){                  system.out.println("inputstream null....");             }

just confirm did:

inputstream = this.getclass().getresourceasstream("/resources/shop-order .xlsx");

just confirm there not space in shop-order.xlsx...

it confirmed inputstream null, because in console printing:

inputstream null...

from println statement

the method throwing null exception here...

 void writetospecificcell(int rownumber, int cellnumber, int sheetnumber, string value) throws invalidformatexception, ioexception {          system.out.println("inside writetospecificcell method before try statement");          try {             system.out.println("inside writetospecificcell method inside try statement");             xssfworkbook workbook = new xssfworkbook(inputstream);              xssfsheet sheet = workbook.getsheetat(sheetnumber);              xssfrow row = sheet.getrow(rownumber);             xssfcell cell = row.createcell(cellnumber);              if (cell == null) {                 cell = row.createcell(cellnumber);             }             cell.setcelltype(cell.cell_type_string);             cell.setcellvalue(value);             system.out.println("inside writetospecificcell method after try statement");             workbook.close();          } catch (ioexception e) {              system.out.println("error in writetospecificcell method " + e);          }catch(nullpointerexception ex){         system.out.println("null in writetospecificcell method");     }     }

it seems me have space before extension of file. can see if correct? :p


Comments

Post a Comment

Popular posts from this blog

python - How to create jsonb index using GIN on SQLAlchemy? -

-
here's current code creating index jsonb. index("mytable_data_idx_id_key", mytable.data['id'].astext, postgresql_using='gin') but got error. sqlalchemy.exc.programmingerror: (psycopg2.programmingerror) data type text has no default operator class access method "gin" hint: must specify operator class index or define default operator class data type. [sql: "create index event_data_idx_id_key on event using gin ((data ->> 'id'))"] is there way create index on sqlalchemy? the postgresql specific sqlalchemy docs @ http://docs.sqlalchemy.org/en/latest/dialects/postgresql.html#operator-classes mention postgresql_ops dictionary provide "operator class" used postgresql, , provide example illustrating use: index('my_index', my_table.c.id, my_table.c.data, postgresql_ops={ 'data': 'text_pattern_ops', ...
Read more

PHP DOM loadHTML() method unusual warning -

-
i had following code works fine on localhost: $document = new domdocument(); $document->loadhtml($p_result); $form = $document->getelementsbytagname('form')->item(0); // code continues using $form variable after same code updated on outside server, loadhtml() failed , issued warning. warning: domdocument::loadhtml() expects parameter 1 valid path, string given in path/name/to/script.php returned null instead of object code pretty gets fatal error. note contents of $p_result absolutely same on outside server , on localhost. but why displays kind of warning , why not work? doesn't loadhtml() expects argument 1 string in first place? why method expects parameter 1 valid path ? just make clear i'm not calling loadhtmlfile() , i'm calling loadhtml() . thanks. you're affected one of php bugs . issue present in php 5.6.8 , 5.6.9. have affected php version on server, , bug-free version on localhost. the bug forbids null ...
Read more

c# - TransactionScope not rolling back although no complete() is called -

-
i'm using transactionscope rollback transaction fail bool errorreported = false; action<importerrorlog> newerrorcallback = e => { errorreported = true; errorcallback(e); }; using (var transaction = new transactionscope()) { foreach (importtaskdefinition task in taskdefinition) { loader.load(streamfile, newerrorcallback, task.destinationtable, processingtaskid); } if (!errorreported) transaction.complete(); } i'm sure there no transactionscope started ahead or after code. i'm using entity framework insert in db. regardless state of errorreported transaction never rolled in case of error. what missing ? transactionscope sets transaction.current . that's does. wants transacted must @ property. i believe ef each time connection opened reason. probably, connection open when scope installed. open connection inside of scope or enlist manually. ef has nasty "design decision": default opens ...
Read more