databases

[airrazor]

HI I was wondering if I could get some help here.

I have a java program that connects to an Access database. This is just a small simple program. The database table has a primary key and it is the first field with numbers in it going from 1 and up for each record. I would like to be able to goto the last record in the table and find out what the number is in the primary key. I used the last(); method and the program compiles fine but on runtime it gives me an error message -> Result set type is TYPE_FORWARD_ONLY 0 null

Can anyone help.

Here is my code:

import java.sql.*;

public class test {
public static void main(String[] arguments) {
String data = "jdbcdbc:tester1";

try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(
data, "", "");
Statement st = conn.createStatement();
ResultSet rec = st.executeQuery(
"SELECT * FROM Table1 ");

rec.last();
System.out.println(rec.getInt(1));

st.close();
} catch (SQLException s) {
System.out.println("SQL Error: " + s.toString() + " "
+ s.getErrorCode() + " " + s.getSQLState());
} catch (Exception e) {
System.out.println(" Error: " + e.toString()
+ e.getMessage());
}
}
}

[public_service]

The problem is that you don't have a "scrollable" cursor which you need for last. By default most cursors are TYPE_FORWARD_ONLY.

You can request a scrollable cursor by using a different method for creating your statement.

Statement statement = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs = statement.executeQuery(YOUR_SQL_GOES_HERE);

Consult the java.sql. API for more information on this.

[sjalle]

If you want the highest value, then you could use something like:

"select max(colName) \"MAXPRIMARY\" from aTable"

if that works with MS Access....

[public_service]

If you want the highest value, then you could use something like:

"select max(colName) \"MAXPRIMARY\" from aTable"

if that works with MS Access....

Oh silly me. I only read the original problem and not what the poster was actually trying to do.

Just to confirm. Access supports the MAX function.

So "SELECT MAX(primarykeycolumnname) FROM Table1" will work.