• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Tim Cooke
  • Devaka Cooray
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Rob Spoor
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
  • Mikalai Zaikin
Bartenders:
  • Carey Brown
  • Roland Mueller

server side database transaction management

 
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi all


i have few questions regarding the server managed datasource

what is the difference between application and server side datasource management?

why should we go for server side datasource management?

difference type of transaction management?
 
Ranch Hand
Posts: 544
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hello there,
I am not sure what you are trying to ask here. But here is an attempt to answer them.

have few questions regarding the server managed datasource

what is the difference between application and server side datasource management?

why should we go for server side datasource management?


As far as I understand all the Datasources are created on the server.I am assuming that you are using Websphere because you posted this in websphere forum.

difference type of transaction management?



Transaction can be managed by your application or left to the server/ejb container by using declarative transaction attributes for methods. e.g. "Required", "RequiredNew" etc.
If you want to handle the transaction then you can obtain the transaction manager in the global JNDI respository. I think the JNDI name is "java:comp/UserTransaction" to get handle to it. Once you have it then you can use UserTransaction Interface's various method to begin,rollback and committing the transaction on your own.

Hope this clarifies some of your doubts.

Regards,
Amit
 
dhoni Gibson
Ranch Hand
Posts: 30
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
hi amit,

thanks for your response. can you please explain what is the difference between XA transaction and normal transaction.
 
amit punekar
Ranch Hand
Posts: 544
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi,
My Understanding is like this:
XA Transaction and Connection is needed in the cases where you need 2 Phase commit.
Normal transaction and connection does not support 2 Phase commit.

Someone more knowledgable about this please correct if this is wrong.

Regards,
Amit
 
A lot of people cry when they cut onions. The trick is not to form an emotional bond. This tiny ad told me:
We need your help - Coderanch server fundraiser
https://coderanch.com/wiki/782867/Coderanch-server-fundraiser
reply
    Bookmark Topic Watch Topic
  • New Topic