Not Quite sure how there is a SQLException on this line...

[Michael Paul]

Hi,

I am trying to just get the value of a column in a DB that stores an int. The value is not null. I have tried both using a column name and index number and with both I get a SQLException error. This is the code:

    
public void actionPerformed(ActionEvent evt) {
JButton Clicked = (JButton) evt.getSource();
ClickedText = Clicked.getText();
            System.out.println(ClickedText);
 
try {
General.Database.createDBConnection(); //establishes connection to DB
Connection conn = (Connection) General.Database.getConn();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT ProcessStep FROM table "
+ "WHERE ID='" + ClickedText + "'");
Step = rs.getInt("ProcessStep");
System.out.println(Step);
} catch (SQLException e) {
e.printStackTrace();
}
catch(Exception ex){
ex.printStackTrace();
}

The line I am getting the error on is:

Step = rs.getInt("ProcessStep");

Anyone have an idea as to why this would be happening? All help would be appreciated.

[Jeanne Boyarsky]

Michael,
JDBC requires you call rs.next() before rs.getXXX(). A typical idiom is:

while (rs.next) {
  Step = rs.getInt("ProcessStep");
  System.out.println(Step);
}

[Jeanne Boyarsky]

Note that we have a forum just for JDBC questions up near the top of the forum list. I'll move this for you.

[Michael Paul]

Thank you very much, sometimes I shock myself with how I overlook small things! I new that you had to do rs.next() and for some reason refused to think of that...Thank you very much for your help!

Michael