aspose file tools*
The moose likes JDBC and the fly likes limited connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "limited connection" Watch "limited connection" New topic
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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30757
    
156

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
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30757
    
156

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: 1081

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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: limited connection