Posted on 1997-06-05
String url = "jdbc:odbc:NortonDB";
conDB = DriverManager.getConnection(url, "admin","");
Statement stmt = conDB.createStatement();
ResultSet rs = stmt.executeQuery(QueryLine);
The above line of code (that is commented out) is not doing what I want it to. It returns some weird number that is definitely not the number of entries in a particular queried recordset. I need to know how many entries are in a recordset I am querying.
I am using an MS Access database and Odbc bridge. The code is in an application written in java. I have no trouble with getting the info, but it would be nice to know how many items are in the recordset. So what is the call I need to make after I execute my Query? 'getRecordsetSize()' would be nice.
Please give me a full answer. Thank you.