Hi,
I am using two data sources for an application . For example X,Y
Y database tables has some foreign key relations to X tables.

Later for some purpose i changed my X database name to Z.
I didn't change any foreign key referenced table names in Y. In order to get data while passing queries to X(present Z) i use interceptor to replace the catalog name from X to Z on every onPrepareStatement() which is available in EmptyInterceptor.

I am getting the data from table and working well.

But issues coming while insertions into database Y . While i am inserting into a table in Y which has foreign key relations with X(present Z) , it is not allowing me to insert records.


Please help in resolving this issue.