I am new to firebird
now i do have a table which has an user admin
when i try to query the table for details of the user admin

String query="select * from USER_DETAILS where USR_NAME='"+usrName+"';";
java.sql.ResultSet rs=stmt.executeQuery(query);
System.out.println("the result set is:"+rs.next());

eventhough i has a record (when i give that query to isql i had
obtaince the result)

the rs.next is returning false

so how can i get the results