Spring Hibernate Prototype for XA Transactions with Multi-Tenant DataSources

Job ID: 38059561

Budget: $250 – $750 USD

I'm in need of an experienced freelancer to help me develop a prototype. The main goal of the project is to improve transaction management, focusing on data integrity particularly, using Spring and Hibernate with Oracle Database.

Key Tasks:
- Help build a prototype emphasizing data integrity in transaction management.
- Ensure that all database operations are handled in an atomic manner.

Ideal Skills and Experience:
- Proficiency with Spring, Hibernate, Narayana JTA, and Oracle database integration.
- Solid understanding of transaction management, with a specific focus on data integrity.
- Experience with building prototypes and handling complex queries and procedures for database interaction.
- Ability to ensure database operations across multiple databases are atomic.
- Ability to think creatively to find a solution most advanced than most training material sand community forums typically show
- Strong track record of ensuring successful integration of Oracle databases with Spring and Hibernate.

Attached is a detailed write-up of the specific technical problem we are trying to solve, along with some prototype code that may or may not be needed.

Deliverable:
- A simple prototype which can write to 2 databases in 1 atomic transaction, accounting for the dynamic nature of data source management and transaction management described the attached overview
Related categories: Oracle Database Hibernate Spring JPA