Oracle Schema & EOModeler
Oracle Schema & EOModeler
- Subject: Oracle Schema & EOModeler
- From: Franck Leveneur <email@hidden>
- Date: Thu, 15 Apr 2004 14:22:12 -0700
Hi,
This is the JDBC string I use:
jdbc:oracle:thin:@111.11.11.111:1521:spider
(IP is just for example)
Right now, using login (testing) and password (testing) gives me access
to Schema Testing.
I create a EO Model using (testing / testing) and selecting tables I
need
The table in Testing (ExcludeFacility) only contain FacilityCode and
some other info.
There is another Schema called Prod that has a table I need to add to
Testing schema.
That table has the rest of the info (FacilityName, RegionName...).
Question 1:
Do I need to go in EOModeler, create a new model, connect to Prod grab
that table, then drag and drop that table in the other EO Model (the
one for Testing)?
Question 2: Should I create a view in Testing Oracle Schema and grab it
with EOModel?
Question 3: What about using the External Query in Advanced Entity
Inspector to join between the table in Testing and the table in Prod?
Just wondering what is the best approach.
Other Question : It is possible to specify the Oracle schema in the
JDBC connection String?
(for MS SQL, you can specify the Database to use)
DaVita Inc.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.