• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JTS and JDBC in J2EE

 
Mary Cole
Ranch Hand
Posts: 362
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
I have a doubt regarding JTS and JDBC pools
Whats the difference between JTS pool and JDBC connection pool
Which is advantageous ,why and in what situation should I use JTS pool?
Thanx in advance
 
pavi kavi
Ranch Hand
Posts: 56
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
as far as i know we use JTS driver to connect connection pooling .
In weblogic they providded TXdatasource which uses this jts driver inbuilt to connect to the databse thru connection pooling
pavithra
Originally posted by Mary, Cole:
Hi all,
I have a doubt regarding JTS and JDBC pools
Whats the difference between JTS pool and JDBC connection pool
Which is advantageous ,why and in what situation should I use JTS pool?
Thanx in advance

 
daman sidhu
Ranch Hand
Posts: 184
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
Using JTS and JDBC Connection pooling are 2 different things, with JDBC pooling u just maintain a pools of connections to the database which help to improve the performance of ur system, but with JTS which is the Java Transcation Services, and for using them we have the Java Transcation API short JTA, in that we can obtain and run our programs in Expilict Trancations which we can manage oursevles, this feature one cant get from JDBC, thus the transcaion which the client can make using JTA can be propogated to EJB's which can run in the client transaction and the container automatically rolls back all the updates to the DB if the tranction fails, or else if we can deteremine such a conditin the we can use Usertrancation.rollback() method.
Hope this helps,
Cheers,
Daman
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic