Hi,
I think there is a problem in your design or in the code implementation that
is creating lots of connections, which is why the TCP limit is reached for
the OS process (as in lots of TIME_WAITs).
Keeping connections in sessions may be detrimental when you have many
sessions each of which may not generate much request load but keep their own
connections tied to them. Use a JDBC 2.0 connection pool instead.
Remember connections are shared resources and you need not keep them tied to
each session. "Get the resource, Use the resource and release the resource".
Its worth repeating: "Get the resource, Use the resource and release the
resource".
Regards,
Partha
----------
From: Andy Susanto [SMTP:[EMAIL PROTECTED]
Sent: Thursday, August 05, 2004 2:46 PM
To: [EMAIL PROTECTED]
Subject: Re: problem
hai,
i am not using JDBC datasource and i do not know about rebind(), my
Connection i am store it in a HttpSession, Because i want to less
create
objek Connection.
TIA,
andy
> Could you check whether the JDBC datasource was bound properly. If
it
> was
> not, then you would have got some exception in the start-up
logging from
> tomcat if you used server.xml for the resource binding.
>
>
> Or are you trying to manually use rebind() in your code....
>
> Regards,
> Partha.
>
> ----------
> From: Andy Susanto [SMTP:[EMAIL PROTECTED]
>> Sent: Thursday, August 05, 2004 12:28 PM
>> To: [EMAIL PROTECTED]
>> Subject: Re: problem
>>
>> hai,
>>
>> i am not running another Tomcat. i develop internal
application that
>> use
>> one server, one Tomcat,one application(inside hp proliant
>> machine),Client
>> use the application every day its oke that error message do
not
>> exist. But
>> This Time error message appear. When i look log file i found
that
>> error
>> message.
>>
>> Why the problem exist now and i do not know what causing
that ?
>>
>>
>> TIA,
>>
>> andy
>>
>>
>> > seems like you already have a tomcat running while trying
to start
>> a
>> > another
>> > tomcat....
>> > terminate all your java processes and than restart tomcat.
>> >
>> > -----Original Message-----
>> > From: A mailing list for discussion about Sun
Microsystem's Java
>> Servlet
>> > API
>> > Technology. [mailto:[EMAIL PROTECTED]
Behalf Of
>> Andy
>> > Susanto
>> > Sent: Wednesday, August 04, 2004 12:22 PM
>> > To: [EMAIL PROTECTED]
>> > Subject: problem
>> >
>> >
>> > hai,
>> >
>> > i have a problem like this :
>> > "java.sql.SQLException: Unable to connect to any hosts due
to
>> exception:
>> > java.net.BindException: Address already in use: connect"
>> >
>> >
>> > i use Session to store Object Connection.
>> >
>> > my OS
>> > window 2000server
>> > hp proliant
>> > tomcat 4.1
>> > mysql 3.23.55
>> >
>> > the application i store only in server and client just
connect
>> from IE to
>> > access the application
>> >
>> >
>> > how to solve that problem, and what happen ?
>> > when i use netstat i have a many TIME_WAIT is that oke ?
>> >
>> >
>> > TIA,
>> >
>> > andy
>> >
>> >
>>
___________________________________________________________________________
>> > 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
>> >
>>
>>
>>
___________________________________________________________________________
>> 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
>>
*********************************************************************
>> Disclaimer: The information in this e-mail and any attachments is
>> confidential / privileged. It is intended solely for the
addressee or
>> addressees. If you are not the addressee indicated in this
message, you
>> may
>> not copy or deliver this message to anyone. In such case, you
should
>> destroy
>> this message and kindly notify the sender by reply email. Please
advise
>> immediately if you or your employer does not consent to Internet
email
>> for
>> messages of this kind.
>>
*********************************************************************
>>
>
___________________________________________________________________________
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
*********************************************************************
Disclaimer: The information in this e-mail and any attachments is
confidential / privileged. It is intended solely for the addressee or
addressees. If you are not the addressee indicated in this message, you may
not copy or deliver this message to anyone. In such case, you should destroy
this message and kindly notify the sender by reply email. Please advise
immediately if you or your employer does not consent to Internet email for
messages of this kind.
*********************************************************************
___________________________________________________________________________
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
