File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Max Connection Problem

 
Chetan Parekh
Ranch Hand
Posts: 3640
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
We are running Weblogic 6.1 with SP2.

We have set max connection size to 300.When ever 301st user is trying to connect the application, Weblogic server give internal error and hang.

Is there any solution to stop this?

Reg,
Chetan
 
Carol Enderlin
drifter
Ranch Hand
Posts: 1364
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What kind of connections are you asking about? Application threads? Database Connections?

What are they doing? How long does a request take?
 
Chetan Parekh
Ranch Hand
Posts: 3640
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am talking about Database Connection.

A Connection last for 10 second max.
 
Carol Enderlin
drifter
Ranch Hand
Posts: 1364
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you using connection pool and datasource?

Are you closing your ResultSets, Statements and Connections?

You could post some code snippets.
 
Chetan Parekh
Ranch Hand
Posts: 3640
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am geting Connection from the using DataSouce by following code...

InitialContext objInitialContext = new InitialContext();
DataSource objDataSource = (DataSource)objInitialContext.lookup(datasource);
System.out.println("Inside DBManager.getConnection() ");
return objDataSource.getConnection();

I am using following code to close the Connection

if(conn != null){
conn.close();
conn = null;
}

I want to know here, by doing Connection.close(), does the Connection object returns to the ConnectionPool?
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic