• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

limited connection

 
jhon Reader
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 34229
341
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jhon,
Moving to JDBC as this question isn't Oracle specific.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34229
341
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 1082
Java Oracle Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic