Re: Oracle query seems to return every row twice in ResultSet
On Aug 12, 12:59 pm, Roedy Green <see_webs...@mindprod.com.invalid>
wrote:
On Wed, 12 Aug 2009 11:39:37 -0700 (PDT), "david.karr"
<davidmichaelk...@gmail.com> wrote, quoted or indirectly quoted
someone who said :
What could be going wrong here?
seehttp://mindprod.com/jgloss/sscce.html
We need to see the details.
I'm not sure what else I can provide. A fully working (or failing, as
the case might be) example would be pretty unlikely.
The only other directly relevant code is the "makeRecord()" method,
which is approximately this:
-------------
private Record makeRecord(final ResultSet rs)
throws SQLException {
Record record = new Record();
record.id = trimOrNull(rs.getString(1));
.
.
.
record.creationDate = rs.getDate(21);
record.maskAddress = trimOrNull(rs.getString(22));
record.badAddress = rs.getInt(24);
record.unitType = trimOrNull(rs.getString(25));
.
.
.
record.badRecord = rs.getInt(31);
logInfo("Returning record [" + record.id + "]");
return (record);
}
private String trimOrNull(String str) {
return (str != null ? str.trim() : null);
}
---------------