Connecting to two different dbs in the same application
Joined: Jan 26, 2005
I have a problem concerning connections to a database. I have an application that connects to a postgresql db, retrieves inforamtion which is processed an than used in a query to an oracle db, but when I try to connect to this db I get an SQLException saying that my oracle table isn't in my postgresql base. I have two different databaseaccess classes to handle the different connections, but still I get the same error.
So my question is; is it possible to connect to two different dbs in the same application and if so how?