[Date Prev][Date Next] [Chronological] [Thread] [Top]

(ITS#3541) ResultSet getString(int i)



Full_Name: Charles Robinson
Version: doc says 0.1 zip suggests 2.0
OS: Wiin 2000
URL: ftp://ftp.openldap.org/incoming/
Submission from: (NULL) (130.36.62.127)


When analyzing the ResultSet derived from a Select as follows (notice the
explicit names in the select)

ResultSet rs = stmt.executeQuery("SELECT
cn,displayName,givenName,department,mail FROM ou=Users where
sn="+lastnames[i]);

I found that if I did a rs.getString(1) I got a random column.
I converted to rs.getString("cn") and got the column named.

It looked as if the result set was ordered by whatever order LDAP itself turned
back, not what the programmer specified in the select.