I want nested result set. so could not close the previous statment .. like
this
Connection conn=...
Statement stmt1=...
statement stmt2 =...
ResultSet rs1= stmt1.execute(....
while (rs1.next())
{
ResultSet rs2=stmt2.execute(....
...
....
rs2.close
}
rs1.close
...
...
----- Original Message -----
From: "yilmaz ay" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 28, 2001 12:56 PM
Subject: Re: Connection is busy with results for another hstmt ????
> SLM alykm,
> have you already closed the first statement before executing the second
> one?
>
> On Tue, 28 Aug 2001 12:29:49 +0500, A mailing list for discussion about
Sun
> Microsystem's Java Servlet API Technology. wrote:
>
> > Hi users!
> >
> > I am using MSSQL server and jdbc-odbc bridge . When i try to open
> another statement object (second one after having the first one ) on the
> same connection object. its results in the following error:
> >
> > Exception in isPageSelectedInRole() :java.sql.SQLException:
> [Microsoft][ODBC SQL Server Driver]Connection is busy with results for
> another hstmt.
> >
> >
> >
> > Can any body please help me ? what could be reason and how could i fix
> it.
> >
> > regards
> >
> > sajida kalsoom
> >
> >
> >
>
>
>
>
>
> _______________________________________________________
> Send a cool gift with your E-Card
> http://www.bluemountain.com/giftcenter/
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
