how to connect two schemas one in local host and one in remote computer

Asked Jul 02 '14 at 05:02

Active Jul 02 '14 at 05:13

Viewed 146 times

How to connect two mysql schemas one in localhost and other in computer in hibernate in j2ee project using glassfish server. I have created 2 persistence units and 2 data sources. Is it the correct way to do this? Data retrieving can be done from both schemas.
But it throws

java.sql.SQLException: Error in allocating a connection.Cause: java.lang.IllegalStateException: Local transaction already has 1 non-XA Resource: cannot add more resources. " exception when updating the database.

Have you any ideas to do this?

edited Jul 02 '14 at 05:13

Rakib

7,435
7
29
45

asked Jul 02 '14 at 05:02

Sudarshani Perera

Did you use two session factories or not – pratim_b Jul 02 '14 at 05:12
Pls post your configuration and code for helpful answer. – Wundwin Born Jul 02 '14 at 05:18
There is no session factory created that created by me. – Sudarshani Perera Jul 02 '14 at 10:26
Please add your `persistence.xml` to the question. – unwichtich Jul 02 '14 at 22:16
My answer to this questio may help: http://stackoverflow.com/questions/14950835/connecting-two-mysql-data-source-using-a-single-connection-object – Travis Stevens Jul 17 '14 at 15:40

how to connect two schemas one in local host and one in remote computer

0 Answers0