aspose file tools*
The moose likes JDBC and the fly likes ResultSet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ResultSet" Watch "ResultSet" New topic
Author

ResultSet

Mike Yu
Ranch Hand

Joined: Nov 17, 2001
Posts: 175
Hi,
Hi,
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
Mike


Thanks,<br />Mike
David O'Meara
Rancher

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: 8919

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 ]

Groovy
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: ResultSet