my dog learned polymorphism
The moose likes JDBC and Relational Databases and the fly likes ResultSet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "ResultSet" Watch "ResultSet" New topic


Mike Yu
Ranch Hand

Joined: Nov 17, 2001
Posts: 175
In JDBC API documentation, it states that "For maximum portability, result set columns within each row should be read in left-to-right order, and each column should be read only once."
Does "left-to-right order" mean the order of the columns listed in the SELECT statement?

Thanks,<br />Mike
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

I believe so, but this is the way I've always done it by default anyway
(i need a 'hmm' emoticon that is one step less than the confused image, like a thoughtful expression)
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8927

MS SQL database requires that. I have also noticed that some MS SQL drivers require that result set returned from a stored procedure be read before any OUT parameters.
[ November 05, 2002: Message edited by: Pradeep Bhat ]

I agree. Here's the link:
subject: ResultSet
It's not a secret anymore!