Re: selecting records in a derby database

[Bryan Pendleton]

int recordCount = rs.getInt();

I get compilation error on last line

The method getInt(int) in the type ResultSet in not applicable for the
arguments ()

Indeed, you have to specify the columnIndex.

http://docs.oracle.com/javase/7/docs/api/java/sql/ResultSet.html#getInt(int)

Specify getInt( 1 ), since there is one and only one
column in the query "select count(*) from..."

bryan