[stackoverflow] [progress Openedge Abl] Executeupdate Stuck With Insert Sql In Java

  • Thread starter Chandana Kumara
  • Start date
Status
Not open for further replies.
C

Chandana Kumara

Guest
I am using "com.ddtek.jdbc.openedge.OpenEdgeDriver" to execute sql queries in java. Because application running with progress DB. I execute insert sql statement as follows.

String sqlString="INSERT INTO PUB.hrlh (frmaid, grgrid, kwalid, klrnid, varid, rkeus, rolhid, genrol, prdcid, indate, levrid,"
+ " levrnaam, initlengte, lengte, efflengte, breedte, verfbad, krimpl, krimpb, prijs, barcode, specif, Rek, kolom, nivo, "
+ "pos, palet, edoms, diphid, seizid, stuknr, ref, swprt, beshid, beslid, volgnr, reflevnota, crdate, crtime, cruscd, alfa, "
+ "prijsfrm, mntnid, levnota, pakhid, snyhid, intbarc, divhid, snijln, reden, crsrt, vlgnr,"
+ " hcruscd,hcrtime,chdate,hcrdate) VALUES(" + roll.getFrmaid()+ ",'"+ roll.getGrgrid()+"','"+ roll.getKwalid()+"','"+ roll.getKlrnid()+
"',"+ roll.getVarid()+","+ roll.getRkeus()+","+ roll.getRolhid()+","+roll.getGenrol()+",'"+ roll.getPrdcid()+ "',"+(roll.getIndate()==null?null:"{ d '"+ roll.getIndate()+"' }")+
", "+ roll.getLevrid()+",'"+ SystemPara.replaceApostrophe(roll.getLevrnaam())+"',"+ roll.getInitlengte()+","+ roll.getLengte()+","+ roll.getEfflengte()+
","+ roll.getBreedte()+",'"+ roll.getVerfbad()+"',"+ roll.getKrimpl()+","+ roll.getKrimpb()+","+ roll.getPrijs()+","+ roll.getBarcode()+
",'"+ roll.getSpecif()+"','"+ roll.getRek()+"',"+ roll.getKolom()+","+roll.getNivo()+",'"+ roll.getPos()+"','"+ roll.getPalet()+"','"+ SystemPara.replaceApostrophe(edoms)+
"',"+ roll.getDiphid()+",'"+ roll.getSeizid()+"','"+ roll.getStuknr()+"','"+roll.getRef()+"',"+SystemPara.getIntFromBoolean(roll.getSwprt())+","+roll.getBeshid()+","+ roll.getBeslid()+
","+ roll.getVolgnr()+",'"+ roll.getReflevnota()+"',{ d '"+ SystemPara.getNewDate()+"'},"+ SystemPara.getNewTime().longValue()+",'"+ roll.getCruscd()+"','"+ roll.getAlfa()+
"',"+ roll.getPrijsfrm()+","+ roll.getMntnid()+",'"+ roll.getLevnota()+"',"+ roll.getPakhid()+","+ roll.getSnyhid()+","+ roll.getIntbarc()+
","+ roll.getDivhid()+","+ roll.getSnijln()+",'"+ roll.getReden()+"','"+ roll.getCrsrt()+"',"+ roll.getVlgnr()+
",'"+ roll.getHcruscd()+"',"+roll.getHcrtime() +","+ (roll.getChdate()==null?null:"{ d '"+roll.getChdate()+"'}") +","+
(roll.getHcrdate()==null?null:"{ d '"+roll.getHcrdate()+"'}")+")";

Statement stmt = con.createStatement();
stmt.executeUpdate(sqlString);


But this statement not execute and stuck at the executeUpdate() method.

I found the reason for this as "edoms" field in above query has 750 character string. "edoms" field contains following text.

Dear Ruwan,

We have received these 50mtr free of charge, so please enter this fabric as sample.

Brgds
Stefka

Van: abcd silva
Verzonden: woensdag 11 mei 2016 9:38
Aan: ’ruwan’; ’chandima’
CC: Frank Vermeulen; ’Serge’; ’Asanji’; ’samanthika’; ’patrice’; ’Udaya’; ’osanda’
Onderwerp: RE: SO prices Intex

Dear saman,

I am checking this, reverting back asap.

Brgds
Bert

Van: ruwan [mailto:saman@test.com]
Verzonden: woensdag 11 mei 2016 8:27
Aan: ’saman’; Bert ven; ’chandima’
CC: Frank Vermeulen; ’Serge’; ’Asanji’; ’samanthika’; ’patrice’; ’Udaya’; ’osanda’
Onderwerp: RE: SO prices Intex

Dear stefka

We need to create GRN for this received roll. If you want to make payment for this, pls. mail me invoice for thi


Please help me to solve this problem.

Continue reading...
 
Status
Not open for further replies.
Top