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

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

frame rate - JAVA simple fps animation(how can i work with?) -

can me, how can calculate , show fps in animation? want show simple rect (for example). if have code: private final fps = 30; private final size = 10; private int x = 10; private int y = 0; private string myfps; private void start(){ while(true){ moverect(); paint(); } } private void paint(){ g2.drawrect(x, y, size, size); g2.drawstring(myfps, 10, 10); } private void moverect(){ x++; } here copypaste of old simple java graphics+bufferstrategy gameloop test app. animation loop draws few moving rectangles , fps counter. java -cp ./lib/test.jar gameloop2 "fullscreen=false" "fps=60" "vsync=true" //http://www.javagaming.org/index.php/topic,19971.0.html //http://fivedots.coe.psu.ac.th/~ad/jg/ch1/ch1.pdf import java.util.*; import java.awt.color; import java.awt.frame; import java.awt.graphics; import java.awt.graphicsconfiguration; import java.awt.graphicsdevice; import java.awt.graphicsenvironmen...
Read more