Re: JSP ORACLE CONNECTIVITY

From: Bjorn Abelli (DoNotSpam.bjorn_abelli_at_hotmail.com)
Date: 03/26/04


Date: Fri, 26 Mar 2004 15:39:42 +0100


"Manpreet" wrote...

> i am sending the code to u and u could reply at
> [COLOR=Blue]manpreetgrover@rediffmail.com[/COLOR] .

No I will not. You asked in a newsgroup, and will get the answer in the
newsgroup, so other can benefit from or object to the answers...

> after filling up the form in the first page and
> then submit is clicked it says resultset not found
> in type declaration.

With a quick glance on your code, I see:

> ResultSet rs = stmt.executeUpdate(...);

executeUpdate doesn't return a ResultSet and it shouldn't.

It returns an int with either the row count for INSERT, UPDATE or DELETE
statements, or 0 for SQL statements that return nothing.

// Bjorn A



Relevant Pages

  • Re: Forward-only recordsets
    ... there are sql statements using '*'. ... When referencing the fields in the recordset, ... It may be an issue with the datatypes. ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: Bind a field to a textbox
    ... Stephen Cairns wrote: ... > The connection cannot be used to perform this operation. ... I prefer to assign my sql statements to a ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Forward-only recordsets
    ... The backend is a sql2005 database. ... there are sql statements using '*'. ... When referencing the fields in the recordset, ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: SQL Statement Question
    ... this newsgroup is for Visual Basic not ASP or VBscript or SQL ... SQL statements: ... > Hi All - I have an ASP page that needs to pull data from a database. ...
    (microsoft.public.vb.general.discussion)
  • Re: IN() vs. OR
    ... > Assume I have two SQL statements: ... > Is there any difference in the recordet created by those statements? ... view and analyze the query plans generated by the query optimizers. ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)