Query with 1 record vs. multiple records

[anderma8]

I have a method that queryies the DB for a single record and returns the expected information, but when I create a 2nd method returining multiple records, I'm getting 0 records. I verified that the SQL statement is correct and I think it may have to do with the connection and statement. Can someone steer me in the right direction? I have the following:


stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSI TIVE, ResultSet.CONCUR_READ_ONLY);
rs.stmt.executeQuery("Select firstname, lastname from myTable");

Thank!

[Albert]

Can you paste more code?
I need to know how do you realized that you have 0 records.
Maybe the problem is when you iterate in the resultset

[anderma8]

I hope this formats well:

Here is the query: static String GETMFDEMPINFO = "select serialno, keyop, keyopempno, keyopbld, keyoproom, keyopphone, altop, altopempno, altopbld, altoproom, altopphone, dolu from tbl_mfd";


Thanks for your input!


public MFDObjList getMFDList() {
Connection conn = getConnection();
Statement stmt = null;
ResultSet rs = null;

MFDObjList myList = new MFDObjList();

try {

stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSI TIVE, ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(GETMFDEMPINFO);

while (rs.next()) {
MFDObj myMFD = new MFDObj();

myMFD.setSerialNo(rs.getString("serialno"));
myMFD.setKeyOp(rs.getString("keyop"));
myMFD.setKeyOpEmpNo(rs.getString("keyopempno"));
myMFD.setKeyOpBld(rs.getString("keyopbld"));
myMFD.setKeyOpRoom(rs.getString("keyoproom"));
myMFD.setKeyOpPhone(rs.getString("keyopphone"));
myMFD.setAltOp(rs.getString("altop"));
myMFD.setAltOpEmpNo(rs.getString("altopempno"));
myMFD.setAltOpBld(rs.getString("altopbld"));
myMFD.setAltOpRoom(rs.getString("altoproom"));
myMFD.setAltOpPhone(rs.getString("altopphone"));

myList.addMFDItem(myMFD);
}

} catch (Exception ex) {
System.out.println("SQL Exception (" + ex.getMessage() + ")");
} finally {
returnResources(rs, stmt, conn);
}
return myList;
}

[anderma8]

that the table in which I am performing a query on is a new table and it may be a rights issue. When I try and grand myself rights to the table, I get:

ORA-01749: you may not grant/revoke privileges to/from yourself

I'm trying to figure out how else I can grant privileges to the user that created the table. I'm thinking this is what is causing my problem of 0 replies...

[anderma8]

it needed either the fully qualified table name OR a synonym... it works now! Thanks for your efforts!

[Albert]

I was testing your example but you've resolved it !! great
;)