Member Avatar for venugreddy

Hi All -

I am using Hibernate Transactions in our project .
The flow is as follows.

JSP --> Actions -- > Business Layer --> Component Layer --> Persistence Layer --> Data base

Currentl I am doing Transaction management in Persistence Layer.

Can I do it in business layer ? The reason is , In a business layer in a function I am calling two methods which will connect to two different databases. If one Transaction is success and one fails I can't roll back both transactions as persistent layer is different for both and databases are different.

Thanks ,
Venu

  • 2 Contributors
  • 4 Replies
  • 90 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by venugreddy

Recommended Answers

All 4 Replies

Member Avatar for BestJewSinceJC

Your problem sounds extremely application specific. From my understanding, persistence layer is where the data is stored, so your question doesn't make sense anyway -- why would you be doing transaction management in your database? Maybe I don't know what I'm talking about here.

Member Avatar for venugreddy

It is not application specific. It is regarding distributed transaction management. Persistence layer is where we can interact with database.(writing SQLS and HQLS).
Let me know if u need further info.

Member Avatar for BestJewSinceJC

Well, I'm afraid I can't help you since I know nothing about those protocols. Sorry & good luck

Member Avatar for venugreddy

Hi -

Any other suggestions please?

Thanks -
Venu.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.