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...
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...