Hello S.S.Rajagopal,
Since you are shifting from Access (for development only) to MS-SQL-Server-7
(a real database) I'm assumming you're also shifting from the odbc/jdbc
bridge to a straight JDBC Driver (type vary from 1-4). In a nut shell,
connection pooling is simply software that allocates connections to your
database. When the connection is no longer needed it relinquishes it back to
the pool to be used again. Several free ones are available. Not so with a
JDBC driver for MS-SQL-7, expect to pay. When you refer to locking, I assume
you mean row level locking??? This is internal to your database and probably
doesn't have anything to do with your problem. I would suggest refering to
Jason Hunters book to learn more about connection pooling.
Tom K.
-----Original Message-----
From: A mailing list for discussion about Sun Microsystem's Java Servlet
API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
SSRAJAGOPAL
Sent: Sunday, May 14, 2000 11:22 PM
To: [EMAIL PROTECTED]
Subject: Re: Query on SQL server
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
___________________________________________________________________________
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
