Web app - multiple database connections
I have been building some web applications (using Netbeans) that access a MySQL database using Hibernate on the server. Works fine. But I have a new application that has a local database and one of the tables contains a list of remote databases that I need to access. I'm not sure of the correct way to connect to and manipulate those remote databases. The remote systems are also mysql databases, and I just need to add/update/delete information from them. Don't need to do anything complicated like joins or searches - at least not at the moment.
Can someone point me at either some sample code or a tutorial that would get me started? Do I want to try to use Hibernate for the remote access or just open a jdbc connection and use sql statements across the net?
Thanks in advance,
nbc
|