JSP & Oracle

Hello,

I have an error in my JSP pages and don't know how to fixe it. Tih is my error :

javax.servlet.ServletException: Exception thrown on line '197' from page 'D:\\web\\Medicale\\Web\\index.jsp'.

    java.sql.SQLException: Result set type is TYPE_FORWARD_ONLY     at
sun.jdbc.odbc.JdbcOdbcResultSet.isBeforeFirst(JdbcOdbcResultSet.java:1925)

    at jrun__index2ejspa._jspService(jrun__index2ejspa.java:90)      at allaire.jrun.jsp.HttpJSPServlet.service(HttpJSPServlet.java:40)

and this is my code :

            <%myConnect.connect();

            String sqlActu = "";

            sqlActu = "SELECT Titre FROM Actualite ";
            sqlActu = sqlActu + "WHERE Status='V' ";
            sqlActu = sqlActu + "AND DateDebutAffichage <= " +
myUtil.DateRequest(Calendar.getInstance()) + " ";
            sqlActu = sqlActu + "AND DateFinAffichage >= " +
myUtil.DateRequest(Calendar.getInstance()) + " ";
            //out.println(sqlActu);
            ResultSet rsActualite = myConnect.execSQL(sqlActu);
            if (rsActualite.isBeforeFirst()){    // this is the 197 line
                rsActualite.last();
                int MaxActualite = rsActualite.getRow();
                rsActualite.beforeFirst();
                //out.println(MaxActualite + "<br>");

Does anyone have an idea ?

thanks,

Douglas. Received on Tue Feb 20 2001 - 05:21:53 CST