Connecting to two different dbs in the same application

Hello.

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?

I hope this wasn't to unclear.
Thanks!!

Kjetil

So my question is; is it possible to connect to two different dbs in the same application and if so how?

Yes. Just uses two connections - one for each DB.

Thanks for your answer Paul.

I had allerady found a solution. I made a new object which held a static variable to a connection manager. I had forgotten that.

But anyway thanks!

Kjetil