88 Servlet to Database Software Communication Approach 3 | Adv java Servlet Programming Tutorial смотреть онлайн

Approach 3/Strategy 3(#Servlet to #Database #Software #Communication):#Advance #Java #Servlet #Programming #Tutorial
- Gather the JDBC connection object from server managed JDBC connection pool being from service(-,-)/doXxx(-,-) methods of our servlet program.

- Use JDBC connection to create other JDBC objects and develop JDBC persistence logic in service(-,-)/doXxx(-,-) of our servlet program.

- Release the JDBC connection object back to JDBC connection Pool being from service(-,-)/doXxx(-,-) methods.

- Here the connection object that represents one JDBC connection Object of Connection Pool will be taken as local variable in service(-,-)/doXxx(-,-) method.

Sample Code:
------------
public calss TestSrv extends HttpServlet{

public void service(-,-)/doXxx(-,-)throws SE,IOE{

Connection con=null;
//logic to get one JDBC connection object from JDBC connection pool
-------
-------

//Logic to use that JDBC connection object & develop persistence logic
-------
-------


//logic to release JDBC connection object back to JDBC connection pool
-------
-------
}
}


Advantages :
------------
- here connection object is local variable of service/doXxx method, so its Threadsafe by default.

- Because of Connection pooling we can use maximum JDBC connection object to make maximum request & web resource program to interact with DB software , This gives quite good performace compare to approach 2 of servlet to db s/w communication.

- There is no need of keeping init (), destroy() life cycle method in our servlet program.

- There is no need of creating, managing, destrying JDBC connection objects manually by the programmer, because all these operations will be taken care by JDBC connection pool itself.


Conclusion:
-----------
While developing small-scale application its recommended to use Approach 1,

Similiarly to develop medium and large-scale application its recommended to Apporoach 3.