I have 3 records with the same FINR and AUFN in my table EDILBEPO. When I
read the resultset, I only get the first record. What could be wrong ? The
result_p.size() ended in a PersistenceException: Cursor not in a valid
state.
Here is the code:
// Positionen verarbeiten
oql_p = db.getOQLQuery("SELECT P FROM bestellung.EDILBEPO P
WHERE P.FINR=$1 AND P.AUFN=$2");
oql_p.bind(new BigDecimal(finr));
oql_p.bind(new BigDecimal(aufnr));
result_p = oql_p.execute();
// System.out.println("Anzahl Positionen: " +
result_p.size());
while (result_p.hasMore()) {
bepo = (EDILBEPO) result_p.next();
eppos = bepo.getPOS();
epbmeng = bepo.getBMENG();
epwdatu = bepo.getWDATU();
epartnd = bepo.getARTND();
epbezgd = bepo.getBEZGD();
epartnl = bepo.getARTNL();
epbezgl = bepo.getBEZGL();
epptxt = bepo.getPTXT();
.
.
.
}
--
View this message in context:
http://www.nabble.com/Only-one-result-from-resultset-tf4645829.html#a13271035
Sent from the Castor - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe from this list please visit:
http://xircles.codehaus.org/manage_email
