using multiple database in adf application

is it possible to have one global data source i have one application which is using diffirent database but those database have the same data model(erd) but diffirent data so if i have global data source which will go and read from all the database

am in jdeveloper 11.1.1.9.0
chalie001Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Helena Markováprogrammer-analystCommented:
I am not sure I have understood your question correctly.
If you want to use data from different databases then you can import data to your "global" data source. The database in your application will be the same.
0
chalie001Author Commented:
I can.T  DO THAT THE DATA CANNOT BE MIXED
0
mrcoffee365Commented:
If your question is about oracle and whether there's an oracle declaration which will ignore database names and pull from all databases, the answer is no.  You have to identify the databases.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

chalie001Author Commented:
am asking from adf view can application use multiple database instance
0
Helena Markováprogrammer-analystCommented:
An application can use one database instance at one time.
If you want to use data from different databases, then there are database links:
(http://docs.oracle.com/cd/E11882_01/server.112/e40540/glossary.htm#CNCPT2027)
database link - In a schema object, a schema object in one database that enables users to access objects on a different database.
0
Helena Markováprogrammer-analystCommented:
I have read this
https://blogs.oracle.com/onesizedoesntfitall/entry/making_use_of_multiple_independent
and it is about 2 databases and not about 2 instances of the same database.
0
mrcoffee365Commented:
Yes you can write code which can pull data from any number of databases.  

It's easy to try -- why do you think there's a problem?
0
chalie001Author Commented:
do you have sample of that code how can i do that in java  adf
0
mrcoffee365Commented:
If you don't know how to write code to use a database from Java, there are a lot of examples on the web.  Oracle has some great tutorials.
http://docs.oracle.com/cd/E53569_01/tutorials/tut_rich_app_alta/tut_rich_app_alta_1.html
https://docs.oracle.com/middleware/1212/adf/ADFFD/intro_tour.htm

If your real question is how to use JDeveloper to connect to a db, you should probably accept the answers here and ask your real question.

But try the tutorials first.  Connect to a single db, and see how that goes.  Then you can ask questions about how to add the connection to another db from the same program.
0
chalie001Author Commented:
i did that this way
connection
the question is if i have another database instance and certain user only use that database but same database model9erd) but diiffirent data how can i do that it will be one application
0
mrcoffee365Commented:
Try writing actual java code rather than using the menus in JDeveloper.  The user interface for JDeveloper seems to assume that programmers only want to conect to a single database.

If you write a java program which makes a connection to one database, and then another connection to another database, it will be clear to you how to use data from more than one database in your program.
0
chalie001Author Commented:
Can you show me  how to do that
0
mrcoffee365Commented:
Do you have a java program?  Post the lines you are trying, and we'll see if we can help.

If you don't know how to write java, then you should probably check some tutorials.  This is a nice tutorial to start with:
http://blogs.msdn.com/b/brian_swan/archive/2011/03/02/getting-started-with-the-sql-server-jdbc-driver.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Java

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.