• Post Reply Bookmark Topic Watch Topic
  • New Topic

how many database connections possible.  RSS feed

 
Arun Vethadas .T
Ranch Hand
Posts: 36
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hai
i using oracle (JDBC) for database connection
with JSP. i'm using normal connection object.
class.forName();
Connection con = DriverManager.getConnection("jdbc dbc ratrain" , user,paaword);
Using like this, at the same time how many users possible to connect with database.Any no.of default connection ??? for example sametime 50 users try to connect database what happen???
i want solution fro that ???
Pls. help me.
Thanks,
Arun.
 
Carl Trusiak
Sheriff
Posts: 3341
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
The number of Maximum concurrent connections that a database can have is setup in the Database server. You can ask your DBA if you have one or consult the documentation of your Database to figure out what this is and how to change it.
Now, don't make a connection for each and every user. A connection is too expensive for this. Use connection pooling. A good example is at JavaExchange
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!