Hi there,

I am working on a project that uses JBoss and Hibernate with a MySQL Database on a dedicated database server.

What I would like to do is to physically separate Database & http network traffic. Unfortunately both the MySQL Server and the Application Server are in the same network.
That means on the app server I have 2 Interfaces that point to the same subnet.

So now I have the problem, that when I tell Hibernate to connect to the MySQL server, the connection will work on both interfaces, and the source interface is chose randomly (I guess).
Therefore my question:
Is there any way to tell hibernate which network interface should be used as "source interface" when opening the connection to the MySQL Server?

I'm sorry if my explanation is confusing, I'm happy to clarify if necessary.

Thanks a lot