| Author |
limited connection
|
jhon Reader
Greenhorn
Joined: Sep 06, 2004
Posts: 21
|
|
hi,
I am not able make more connection to database
it say no of connection is over ie 150
what should i do to make more connection as per my requierment
bye
anuj
|
 |
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26168
|
|
Jhon,
Moving to JDBC as this question isn't Oracle specific.
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
|
Jeanne Boyarsky
internet detective
Marshal
Joined: May 26, 2003
Posts: 26168
|
|
Jhon,
First thing to do is check that you aren't leaking connections. 150 is a lot for one application. Are you connection pooling?
|
|
Shailesh Chandra
Ranch Hand
Joined: Aug 13, 2004
Posts: 1076
|
|
150 open connection I think its too much ...
1. Which Database are you using ?
2. which applcation server you are using (are you making connect from datasource)?
3. Are you closing connection properly in your application ?
|
Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
|
|
 |
|
|
subject: limited connection
|
|
|
0
