My problem is to make some JDBC 2.0 API calls such as rs.last(). I have
Tomcat 3.2.1 and JDK 1.3 installed. Source codes are below. Please help.

Jack Li

-----------------------------------------
<%@ page import="java.sql.*"%>
<%
        Connection con = null;
        try{
                    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                    con = DriverManager.getConnection("jdbc:odbc:internetdb", "", "");

                Statement st =
con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
                ResultSet rs = st.executeQuery("Select * from HRExt");
                rs.last();
                out.println(rs.getRow());
                rs.close();
                con.close();
            }
        catch(SQLException e){
                System.err.println(e.getMessage());
        }
        catch(Exception e){
            System.err.println(e.getMessage());
        }
        out.println("Hello World");
%>
---------------------------------------------

Reply via email to