Connection Pool :
The Reason for using connection pool is opening and maintaining a database connection for each user, an especially request made to a dynamic database driven website application, is costly and wastes of resources. so to avoid this connection pool uses a cache of database connections maintained, so that the connections can be reused when future requests to the database are required.
XA Data source:
It's basically when you have to use a two phase commit, an XA transaction, in the most general terms is a "global transaction " that may span multiple resources. So this would mean for EX : if there are two Database which needs to be committed at the same time, so in this case you would use an XA Data Source (driver)
The Reason for using connection pool is opening and maintaining a database connection for each user, an especially request made to a dynamic database driven website application, is costly and wastes of resources. so to avoid this connection pool uses a cache of database connections maintained, so that the connections can be reused when future requests to the database are required.
XA Data source:
It's basically when you have to use a two phase commit, an XA transaction, in the most general terms is a "global transaction " that may span multiple resources. So this would mean for EX : if there are two Database which needs to be committed at the same time, so in this case you would use an XA Data Source (driver)
** GO
GREEN AND SAVE THE EARTH – Chandu Chowdary **
No comments:
Post a Comment