connection pooling in jdbc using sql server

Question

I am trying to make connection through SQL Server from web server using java .It is simply opening the connection by sql driver but when multiple users try to connect with the web server of the company the server goes slow down due to the heavy traffic . So i think it must use the connection pooling concept . i am using the following code to connect with database

   try{   
     Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
       cnn     =java.sql.DriverManager.getConnection("jdbc:sqlserver://202.54.119.141:1433;Database=LCXERP" ,"shivam","shivbabaji");
     st1=cnn.createStatement();


    }
    catch(Excpetion ex)
  {
    ex.printStackTrace();
  }

suggest the alternate way to connect with data base to avoid congestion

As you said connection pool. :) Try using datasource of server that will save you from implementing connection pool. — Subir Kumar Sao
– Subir Kumar Sao, Commented Mar 8, 2013 at 10:38
You can use Apache Commons DBCP for connection pooling. There are others too. — Seshagiri
– Seshagiri, Commented Mar 8, 2013 at 10:53

Lakshmi · Accepted Answer · 2013-03-08 11:00:04Z

3

Connection Pooling can help you. There are various connection pooling avaible most common among them are DBCP connection pooling and C3pO connection pooling. You can refer Sample connection pooling for your guidance . Also you can read more on the advantages of connection pooling here.In general connection pooling can reduce the number of connections made to the backend at a time thereby increasing the performance.

answered Mar 8, 2013 at 11:00

Lakshmi

2,2943 gold badges30 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Th3Nic3Guy · Accepted Answer · 2013-03-08 11:02:00Z

0

Ill suggest you use JNDI code for implementing the connection code. the Application server can take care of the connection pooling. for example in weblogic server u can set the connection pool size.

dont go re-inventing the wheel and use the AS features. will help..

answered Mar 8, 2013 at 11:02

Th3Nic3Guy

1,9798 gold badges33 silver badges68 bronze badges

Collectives™ on Stack Overflow

connection pooling in jdbc using sql server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related