Re: Database System Tables [WO newbie]
Re: Database System Tables [WO newbie]
- Subject: Re: Database System Tables [WO newbie]
- From: Mark Morris <email@hidden>
- Date: Wed, 14 Dec 2005 12:09:21 -0600
Hello Thomas,
Also, if you're having trouble seeing those tables in EOModeler's
"new model" assistant, a workaround I've used in the past with Oracle
(which may work in your case as well) is to create an empty table in
your schema for each the table you want to add. I do something like:
CREATE TABLE table_a AS
SELECT * FROM other_schema.table_a
WHERE 1=2;
You can then see them and set them up the model, then if necessary go
inspect each of the tables to add the "other_schema." prefix to the
external table names.
Regards,
Mark
On Dec 14, 2005, at 10:50 AM, Jerry W. Walker wrote:
Hi, Thomas,
Though I've never done this and have never used Ingres, I don't see
why you can't create entities in an EOModel that reference the
tables and fetch them like any other Enterprise Objects (EOs).
An easy test would be to create the entities in EOModeler, than use
the data browser in EOModeler to see if it has access.
Perhaps an Ingres knowledgeable WO user can jump in here.
You mention that the system catalogs are readable, which, I
presume, means that they're not writable by just any database user.
If that's true you might mark the entities "Read Only" in the
Advanced Entity Inspector for safety.
Good luck,
Jerry
On Dec 13, 2005, at 10:44 AM, Thomas Friesen wrote:
I am just beginning to work with WebObjects/EnterpriseObjects, and
as an Ingres DBA, am rather interested in accessing the system
catalogues (iitables, iirelations, etc.) via Enterprise Objects. I
was a little surprised that I was able to have EO connect and pick
up the user tables with no extra effort.
But can I somehow have EO recognise the system tables for reading.
(In Ingres, system catalogues are readable by any database user,
and are read using standard SQL statements.)
Ideas would be appreciated. Known solutions would be fantastic!
Cheers,
Tom Friesen
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40gmail.com
This email sent to email@hidden
--
__ Jerry W. Walker,
WebObjects Developer/Instructor for High Performance Industrial
Strength Internet Enabled Systems
email@hidden
203 278-4085 office
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40onpointsoftware.com
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden