Hello Anil Colin Lobo,
Thanks for your info.Can you please elaborate a bit on how to exactly
implement connection pooling?
I have another doubt.If I go for the connection pool,shall I have to say
MAX_OPEN_CURSORS=200 in the orcl.ini file?
Please clarify and thanks for your time.
srr
>From: Anil Colin Lobo <[EMAIL PROTECTED]>
>Reply-To: "A mailing list for discussion about Sun Microsystem's Java
> Servlet API Technology." <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Cursors
>Date: Fri, 25 Aug 2000 10:04:43 -0700
>
>Hi,
> Why don't you use a connection pool offered by the servlet
>container? If
>your db is Oracle you have to set this parameter in your db ini (Ex.
>orcl.ini) file:
>MAX_OPEN_CURSORS=200 or whatever number of cursors you want to keep open. I
>think that open resultsets in java correspond to a open cursor in the
>database or something like that. So it would be better to close all
>resources and free the connection to the pool immediately after you are
>done
>using it.
>HTH
> Anil
>
>--------------------------------------------
>Anil Colin Lobo
>Aztec Software, Inc.
>3211 Scott Blvd., Suite 204
>Santa Clara, California 95054
>Ph: (408) 7483500
>Web: http://www.aztecsoft.com
>
>-----Original Message-----
>Subject: Cursors
>
>
>Hello Gurus,
>
>I have this cursors exceeded problem after some time.I am using a separate
>class for data base access and in each of my servlet init method I call
>this
>class' dbconnect mehod and in the destroy method I call the closedb method.
>
>But it does not work.
>How to call the close method in a servlet that has to perform many data
>base
>tasks based on the user request and also refresh every minute the display?
>
>TIA
>srr
>
>___________________________________________________________________________
>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
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
___________________________________________________________________________
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
