Does your application hold Statements / Connections for a long time
without using them? The symptoms below are consistent with the
physical database connection being closed due to inactivity timeout on
the server side.
Phil
On Wed, Jan 26, 2011 at 12:50 PM, Suny kk wrote:
> Now my application r
Now my application rising following error sometime and sometime working
perfect, anyone of you ever faced such error?
Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No
operations allowed after statement closed.
at
sun.reflect.GeneratedConstructorA
You may want to look at what connections your database thinks are open.
In Oracle, from a sql plus command line:
select username, program, machine, osuser, logon_time, sid, serial#
from v$session where osuser != 'oracle' order by machine, logon_time;
You can also do something similar with mysql
On Tue, Jan 25, 2011 at 4:39 PM, Suny kk wrote:
> Hi Phil,
>
> Yes, I'm using BasiDataSource well, Is it because of my DBCP settings?
> Remember I got this exception when I started my application on different
> machine with same database.
>
Well, if the first instance starts and uses the full 500
Hi Phil,
Yes, I'm using BasiDataSource well, Is it because of my DBCP settings?
Remember I got this exception when I started my application on different
machine with same database.
Regards
On Sun, Jan 23, 2011 at 8:48 PM, Phil Steitz wrote:
> On Sun, Jan 23, 2011 at 4:02 AM, Suny kk wrote:
>
On Sun, Jan 23, 2011 at 4:02 AM, Suny kk wrote:
> I'm using DBCP 1.2.2 version there's no commons pool dependency in my
> project and following is stack trace
>
> org.springframework.jdbc.UncategorizedSQLException : (Hibernate operation):
>> encountered SQLException [Cannot create PoolableConnecti
I'm using DBCP 1.2.2 version there's no commons pool dependency in my
project and following is stack trace
org.springframework.jdbc.UncategorizedSQLException : (Hibernate operation):
> encountered SQLException [Cannot create PoolableConnectionFactory (Data
> source rejected establishment of connec
On Thu, Jan 20, 2011 at 6:16 AM, Suny kk wrote:
> Hi,
>
>
> I've facing "Too many connections" issue and following are my DBCP
> settings...
What exactly is your problem - i.e., what exception / liveness issue
are you seeing. Also what versions of commons dbcp and commons pool
are you running?
Hi,
I've facing "Too many connections" issue and following are my DBCP
settings...
#
# DBCP Connection Pool Settings
#
# The connection properties that will be sent to our JDBC driver when
# establishing new connections.
db
