Hi Friends,

Hibernate version:
Hibernate 2.1.4

Name and version of the database you are using:
Informix Dynamic Server 7.4X and Informix Standard Engine 7.x

Problem

My application needs to connect to any of the 20 database severs in a single program by switching connections. Among these 20 database severs 19 are Informix SE database severs and remaining 1 is Informix Dynamic Server. The 19 DB Servers are having a database with same database schema and the Central 1 is having a database with a different DB Schema.

I am using two different sar files (1 for the 19 stations and 1 for the central). I am updating all the tables locally using the Hibernate layer.
How will I connect to other stations dynamically which ever database i need to update on the runtime.

How will i implement two phase commit protocol when updation to 3 different databases with in a single transaction. One issue is that Informix Standard Engine doesn't support ditribute transaction (XA).

Please give me a way to solve this problem.

Thanx in advance.

Peter