Re: Issue - Database Architecture

[Dave Newton]

Vijay K Anand wrote:

I get error : "java.sql.SQLException: Closed Connection: next "  when 
number of concurrent requests is more

public class PortfolioMgmtAction extends Action{
   private Connection con;
public ActionForward execute(..){
   this.con = dao.getConnection();
}
}

public class DAO
{
   private Connection objConnection;

public Connection createConnection() {
       Class.forName("oracle.jdbc.driver.OracleDriver");
"dashboard");
       objConnection = 
DriverManager.getConnection("jdbc:oracle:thin:@10.64.34.107:1521:spsdweb", 
"NPI_DBRD_AD", "RTAM70PW");
       return objConnection;

   }

What is the problem in architecture??

I'm not sure how related this is to Struts. I'm also not sure how we 
could tell you what's wrong with the architecture.

It sounds like you have too many concurrent database requests, no? 
Perhaps you could configure the database to allow more, close existing 
requests, use a connection pool, or use a ORM framework to avoid having 
to roll some/all that by hand. But it's hard to say.

Also, regardless of any security arrangements you have in place, it's 
generally a phenomenonally BAD idea to use real IP addresses, user 
names, passwords, etc. in an open forum.

Dave



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]