Hi,
I have already tried closing the result set & connection but met with
the same problem.Can some one give some info on locking and connection
pooling in SQL server
Regards,
S.S.Rajagopal
On Fri, 12 May 2000, blueads.com wrote:
> Just a guess, but it sounds like your not closing your resultset or
> connection. Have you thought about going with JDBC and a connection pool?
>
> Tom Kochanowicz
>
>
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
> SSRAJAGOPAL
> Sent: Thursday, May 11, 2000 10:13 PM
> To: [EMAIL PROTECTED]
> Subject: Query on SQL server
>
>
> Hi all,
> I am doing my project using servlets . Recently I shifted my
> application from MS-Access to SQL Server 7.0 . When i try to access the
> application and run any of the servlets it gives me the following error
>
> " Connection is busy with results of another hstmt")ODBC -HY0000
>
> Has anyone encountered this problem . ?If so what should be done to
> remove this ?.
>
> Note : I am using IIS and Servlet Exec utility ro run my servlets
>
> Thanx in advance
>
> Regards,
> S.S.Rajagopal
>
> ___________________________________________________________________________
> 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
>
"Nobody is perfect in this world and since i am nobody .........."
__ooooooooo__
oOOOOOOOOOOOOOOOOOOOOOo
oOOOOOOOOOOOOOOOOOOOOOOOOOOOOOo
oOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOo
oOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOo
oOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOo
oOOOOOOOOOOO* *OOOOOOOOOOOOOO* *OOOOOOOOOOOOo
oOOOOOOOOOOO OOOOOOOOOOOO OOOOOOOOOOOOo
oOOOOOOOOOOOOo oOOOOOOOOOOOOOOo oOOOOOOOOOOOOOo
oOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOo
oOOOO OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO OOOOo
oOOOOOO OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO OOOOOOo
*OOOOO OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO OOOOO*
*OOOOOO *OOOOOOOOOOOOOOOOOOOOOOOOOOOOO* OOOOOO*
*OOOOOO *OOOOOOOOOOOOOOOOOOOOOOOOOOO* OOOOOO*
*OOOOOOo *OOOOOOOOOOOOOOOOOOOOOOO* oOOOOOO*
*OOOOOOOo *OOOOOOOOOOOOOOOOO* oOOOOOOO*
*OOOOOOOOo *OOOOOOOOOOO* oOOOOOOOO*
*OOOOOOOOo oOOOOOOOO*
*OOOOOOOOOOOOOOOOOOOOO*
""ooooooooo""
************************************************************
* S.S.RAJAGOPAL permanent address: *
* SYSTEMS EXECUTIVE no 3 ,pushpha colony *
* saligramam *
* INFOTECH SERVICES DIVISION chennai:600093 *
* GODREJ & BOYCE tel:(044)4813161 *
* *
* VIKHROLI MUMBAI-400079 temporary address: *
* F2/56,l.b.marg *
* email : [EMAIL PROTECTED] godrej colony *
* vikhroli *
* tel: 5773535(36) ext:4041 mumbai -79 *
************************************************************
___________________________________________________________________________
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
