*
The moose likes Websphere and the fly likes server side database transaction management Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Products » Websphere
Bookmark "server side database transaction management" Watch "server side database transaction management" New topic
Author

server side database transaction management

dhoni Gibson
Ranch Hand

Joined: Feb 10, 2011
Posts: 30
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?
amit punekar
Ranch Hand

Joined: May 14, 2004
Posts: 507
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

Joined: Feb 10, 2011
Posts: 30
hi amit,

thanks for your response. can you please explain what is the difference between XA transaction and normal transaction.
amit punekar
Ranch Hand

Joined: May 14, 2004
Posts: 507
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: server side database transaction management
 
Similar Threads
Designing EJB public service (best practice)?
Hibernate connection & transaction management
Advanced JDBC topics for 484
Questions about jca connector
JAAS + JBOSS 5.1 - getting exception while trying perform authentication