[
https://issues.apache.org/jira/browse/DERBY-6985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16569236#comment-16569236
]
sagar commented on DERBY-6985:
------------------------------
This open connection issue also has other aspects ...
# Derby takes a lot of time to eatablish a connection or even times out if the
number of connections open exceeds.
# It also takes a hell lot of time to shutdown and sometimes does give many
protocol errors on the console. Will try to post them.
# If usimg connection pool like c3p0 if the pool does not shutdown the
connections properly or a program experiences an unhandled exception, the
connections I feel are not being closed even after 2 hours. Again try to
establish a single connection and it will take ages or even give a timeout
error the driver.
Will try to post more concrete observations with messages
> Document how to configure the keepAlive timeout on network sockets
> ------------------------------------------------------------------
>
> Key: DERBY-6985
> URL: https://issues.apache.org/jira/browse/DERBY-6985
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.14.1.0
> Reporter: Satyabrata Mohanty
> Priority: Major
> Attachments: Derby_Open_Connection.png
>
>
> Hi,
> Below is the complete description of the issue,
> * Running a java application which creates a good number of connections with
> derby on the machine X.
> * We are running the derby database server on the machine lets say Y.
> * We explicitly block the listening of 1527 port of system X traffics on
> system Y in the network until it thrown connection exception and then again
> established the network between the two systems.
> * After the java application has finished execution we found there are still
> some connections remained open in derby.
> * We can see open connections in derby although we have terminated the java
> application.
> * We have restarted derby to free up these connection.
> * Concern here is, how these connection are generated, is these connections
> are broken /stale connection made during the network reset, if YES then, how
> to these connection will be auto deleted or handled in derby ?
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
