Getting Exception With DB2 Select from Table

Question

I keep getting the "java.sql.SQLException: Column 'id' not found." when trying select from a table using DB2 on Netbeans. Here is my table creation code:

string="CREATE TABLE PlayerCollection "
                + "(id integer not null GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),"
                + "name varchar(20),"
                + "height varchar(20),"
                + "weight varchar(20),"
                + "position varchar(20),"
                + "team varchar(20),"
                + "PRIMARY KEY (id))";

And here is my code to select from the table:

String sql = "select name, height, weight, position, team from PlayerCollection "
                        + "where id=" + strIndex;

Why am I getting this exception even though "id" clearly exists in my table and how do I fix this?
Actually it seems that my error is at this line:

int ind = rs.getInt("id");

Here "rs" is a result set.

Actually it seems that my error is at this line "int ind = rs.getInt("id");" Here "rs" is a result set. — newbie
– newbie, Commented Dec 14, 2019 at 18:47

forpas · Accepted Answer · 2019-12-14 18:57:44Z

2

The resultset contains only the columns that you select, so you must include the column id in the select list:

String sql = "select id, name, height, weight, position, team from PlayerCollection "
           + "where id=" + strIndex;

or since you have the id's value in the variable strIndex which you use in the WHERE clause, simply remove the line:

int ind = rs.getInt("id");

from your code, or change it to this:

int ind = Integer.parseInt(strIndex);

edited Dec 14, 2019 at 18:57

answered Dec 14, 2019 at 18:50

forpas

165k10 gold badges51 silver badges85 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Getting Exception With DB2 Select from Table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related