How to shrink the connection

Question

0.00/5 (No votes)

See more:

How to create a method in java class that can
1)shrinking the connection in pool after use,
2)rename the connection name

Posted 9-Oct-11 18:18pm

nazila24

Add a Solution

Comments

Sergey Alexandrovich Kryukov 10-Oct-11 15:20pm

Shrinking the connection? What is "renaming the name". Does it mean the name itself has a name to be modified? :-)
--SA

nazila24 10-Oct-11 20:35pm

yes , shrinking a connection pool.
Renaming the connection name to make easier for programmer identified the connection. Recently the connection name quiet difficult to identify

Nagy Vilmos 11-Oct-11 6:06am

Either reality is broken or your question makes no sense.
I'm going with the later.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

jschell · Accepted Answer · 2011-10-21T12:37:00

Solution 1

A idle connection in a pool is a connection that is not being used.
To remove idle connections from a pool the following concepts are used/
1. Time connection is idle
2. A minimum number to keep even if idle.
3. The time that a connection was last used is kept.
4. Whether a connection is currently in use.

If one creates their own pool then they create a thread/timer which when fired checks the idle time (current time minus last time used) and removes (closes) connections that have been idle too long. That is repeated until the minimum is reached.

If one is using another pool then the same idea applies except one looks to the configuration of the pool.

As for the 'name', a pool should only be associated with a single location. There is no point in keeping track of individual connections (although an int is suitable.) The pool itself might have a name but that is dependent on the implementation of the pool.

Posted 21-Oct-11 12:37pm

jschell

Comments

nazila24 23-Oct-11 22:21pm

what is time connection idle?can you give an example

jschell 24-Oct-11 13:54pm

A idle connection is one that is not being used.
The idle time is the time based on "current time" - "last time used"

nazila24 25-Oct-11 1:27am

in your opinion, what should i do to enable shrinking of connection?

jschell 25-Oct-11 13:50pm

You haven't specified whether you have your own library or are using an existing one.

You also haven't specified why you think it is necessary to discard idle connections.

nazila24 26-Oct-11 20:56pm

yes, i'm using existing one..i have try to modify it. don't you think it necessary?actually i'm a student,i have get a task to modify connection pool manager(DBAccess class) in order to improved performance and flexibility to handle the connection

jschell 27-Oct-11 14:05pm

If you are already using a pool it is unlikely that you will impact performance by closing idle connections. Most likely result of that would be to reduce performance.

If you want to improve performance then stop GUESSING.

Instead measure the application via either an automated profiling tool or by manually inserting timing measurements throughout the code. Using the measurements (not guessing) you then determine where actual performance bottlenecks lie and then you focus your analysis on those arease.

nazila24 27-Oct-11 21:33pm

Thank you very much for the advice and response my comment.i'm really appreciate. it. can you help me explain measurement should be use. what automated profiling tool?what do you mean by timing measurement?what timing?
Sorry for those 'stupid' question..Thank you :)

jschell 28-Oct-11 15:00pm

Following is one profiler. I am certain there are others.

http://www.red-gate.com/products/dotnet-development/

To effectively use a profiler you must be able to run your application in a way that simulates real business use. The profiler will not help with that.

Profiling involves two aspect for one method.
- Time how long a single method takes
- How many time the method was called.
To profile an application you do that for all or many methods. Then look at the results for all and determine maximums.

When a database involved you must also profile the database code. Look to a reference specific to your database on how to do that.

In term of 'timing' a method it involves
1. Get the start time.
2. Run method
3. Get the end time.
4. Subtract 1 from 3.

There are other factors such as that it is seldom a good idea to run a method just once nor it is a good idea to time the first run of the method. However that last is only going to apply if you are trying to do this manually.

nazila24 31-Oct-11 1:37am

Thank you for detail explanation. For my task..it is profiling need in connection?
because i am only involved modify class that manage connection pool that using oracle database, apache tomcat server and JSP