Re: Database System Tables [WO newbie]

Fri, 16 Dec 2005 10:01:34 -0800

Thanks for the suggestions, guys! That worked perfectly! I suspect that for those tables with key information, a copydb (Ingres structure+data copy) on the tables in question to another schema would provide even more information, should it be necessary.

Cheers,

Tom Friesen


On 14-Dec-05, at 1:09 PM, Mark Morris wrote:

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 protected])
Help/Unsubscribe/Update your Subscription:

This email sent to [EMAIL PROTECTED]


--
__ Jerry W. Walker,
   WebObjects Developer/Instructor for High Performance Industrial Strength Internet Enabled Systems

    203 278-4085        office


_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:

This email sent to [EMAIL PROTECTED]


 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to