You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by ma...@tyranz.com on 2006/11/15 08:14:23 UTC
sql connection error
Hi, i use tomcat 5.5.20, when i start tomcat all is fine all works but
after some time i am getting this message :
java.sql.SQLException: No operations allowed after connection closed
and the only way right now i have find is to restart tomcat, what could be
the cause of this message? i don't understand what could close the
connection and can't reopen it.
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: sql connection error
Posted by Santosh Puranshettiwar <sa...@wirkle.com>.
master@tyranz.com wrote:
> unfotrtunately i didn t have any more the complete trace i will wait for
> tomcat to do it again , i just now that i had this sort of log in the same
> time with the other error :
>
> com.mysql.jdbc.CommunicationsException: Communications link failure due to
> underlying exception:
>
> ** BEGIN NESTED EXCEPTION **
>
> java.net.SocketException
> MESSAGE: Broken pipe
>
> STACKTRACE:
>
> java.net.SocketException: Broken pipe
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
Its difficult to say anything by this stacktrace. Lets wait till you can
gather some more stack trace.
--
Santosh.
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: sql connection error
Posted by ma...@tyranz.com.
unfotrtunately i didn t have any more the complete trace i will wait for
tomcat to do it again , i just now that i had this sort of log in the same
time with the other error :
com.mysql.jdbc.CommunicationsException: Communications link failure due to
underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: Broken pipe
STACKTRACE:
java.net.SocketException: Broken pipe
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: sql connection error
Posted by Santosh Puranshettiwar <sa...@wirkle.com>.
master@tyranz.com wrote:
>> master@tyranz.com wrote:
>>
>>> Hi, i use tomcat 5.5.20, when i start tomcat all is fine all works but
>>> after some time i am getting this message :
>>> java.sql.SQLException: No operations allowed after connection closed
>>>
>>> and the only way right now i have find is to restart tomcat, what could
>>> be
>>> the cause of this message? i don't understand what could close the
>>> connection and can't reopen it.
>>>
>>>
>> Do you use any connection pooling?
>>
>>> ---------------------------------------------------------------------
>>>
>
>
> no i have read somewhere on internet that this can be cause by pool of
> connection so i don't use it
>
>
Ok.
Please send the complete stack trace (the relevant section atleast).
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
--
Santosh.
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: sql connection error
Posted by ma...@tyranz.com.
> master@tyranz.com wrote:
>> Hi, i use tomcat 5.5.20, when i start tomcat all is fine all works but
>> after some time i am getting this message :
>> java.sql.SQLException: No operations allowed after connection closed
>>
>> and the only way right now i have find is to restart tomcat, what could
>> be
>> the cause of this message? i don't understand what could close the
>> connection and can't reopen it.
>>
> Do you use any connection pooling?
>>
>> ---------------------------------------------------------------------
no i have read somewhere on internet that this can be cause by pool of
connection so i don't use it
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: sql connection error
Posted by Santosh Puranshettiwar <sa...@wirkle.com>.
master@tyranz.com wrote:
> Hi, i use tomcat 5.5.20, when i start tomcat all is fine all works but
> after some time i am getting this message :
> java.sql.SQLException: No operations allowed after connection closed
>
> and the only way right now i have find is to restart tomcat, what could be
> the cause of this message? i don't understand what could close the
> connection and can't reopen it.
>
Do you use any connection pooling?
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>
>
--
Santosh
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org