sqlexception - JDBC Invalid column index exception -


for sql query

select m.txrefno,m.processdate  f.processid=? , (m.countrycode in (?) or m.countrycode null) , (m.txrefno=?)

i have passed string as

stmt.setstring(3, entry.getvalue().tostring()); stmt.setstring(2, entry.getvalue().tostring()); stmt.setstring(1, entry.getvalue().tostring());

but showing invalid column index exception.


Comments

Post a Comment

Popular posts from this blog

Regex find and replace between <div class="customclass"> and </div> tag -

i cant find anywhere working regex expression find , replace text between div tags so there html want select between <div class="info"> , </div> tag , replace other texts <div class="extrauserinfo"> <p>hello world! sample text</p> <javascript>.......blah blah blah etc etc </div> and replace with my custom text codes <tags> asdasd asdasdasdasdasd</tags> so <div class="extrauserinfo"> custom text codes <tags> asdasd asdasdasdasdasd</tags> </div> here refiddle code there , can see want replace whole bunch of codes between , tag http://refiddle.com/1h6j hope mean :) if there's no nesting, plain match non-greedy (lazy) (?s)<div class="extrauserinfo">.*?</div> .*? matches amount of character (as few possible) meet </div> used s modifier making dot match newlines too. edit : here javas...
Read more

jpa - Passing entitymanager from reflection method -

we using struts2, ejb jpa. @persistencecontext private entitymanager entitymanager; // here getting entitymanager reflection method m = c.getdeclaredmethod(methodname, params); //here params accept class<?> now want pass entitymanager using reflection. how pass entitymanager in getdeclaredmethod ? billy, reply. now fixed issue using transactionscopedentitymanager. we using struts2 + ejb + jpa 1.0 (cmt). have many action classes , form values persist in db. created ejb every 1 action. planing 1 ejb action classes. go reflection. using getdeclaredmethod, can pass method name , params. here params accept classes. need pass our form object , entitymanager. used entitymanager type, changed transactionscopedentitymanager.
Read more