File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Problem geting column value. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Problem geting column value." Watch "Problem geting column value." New topic

Problem geting column value.

Em Aiy
Ranch Hand

Joined: May 11, 2006
Posts: 226
Please look at the following code

This code is throwing exception ... "array index out of range". I have checked it and it comes only when i use rs (resultset object) to retrieve the value.

The difference between <b>failure</b> and <b>success</b> is often being <b>right</b> and being <b>exactly right</b>.
Herman Schelti
Ranch Hand

Joined: Jul 17, 2006
Posts: 387
hi Muhammad Ali,

I think int i should start with the value 1 (not with 0):

the JavaDoc for ResultSetMetaData says:
column - the first column is 1, the second is 2, ...

Em Aiy
Ranch Hand

Joined: May 11, 2006
Posts: 226
yeah, one possible reason was that. The other reason was, i must have done "" in order to get a value from the record.
I agree. Here's the link:
subject: Problem geting column value.
It's not a secret anymore!