HELP -- Counting rows with oracle & jdbc

[erin_az]

I have the following code snippet:
String queryJoinCount = "select count(contract_type_id) from clause_type_join where clause_id = ? and comment_id = ?";
PreparedStatement stmt = conn.prepareStatement(queryJoinCount);
stmt.setInt(1, clause.getId());
stmt.setInt(2, comment.getId());
ResultSet rs_count = stmt.executeQuery();
if(rs.next()){
//then some results were returned
int count = rs.getInt("count(contract_type_id)"); //problem here
}
I keep getting an sql exception on the line inside the if statement.
How do I refer to the column name that Oracle's count mechanism is returning?
thanks,
Erni

[Daniel Dunleavy]

you name the the count field like
select count(emp_id) emp_cnt from....
emp_cnt is now the field name
Dan

[erin_az]

That is helpful to know, thanks,
e.