Re: [Re-post] indirection-table and schema (Thomas, can you confirm?)

[Jason Mihalick]

Synonyms don't work in DB2.  Everything has to be qualified with a 
schema.  The only way around it is that I'm aware of is to run the "set 
current sqlid='<Schema>'", a DB2 platform specific command.

I haven't had a chance to test yet, but I suspect that I will need to set

indirection-table="SYSADM.FOO_BAR"

Thomas, can you confirm or deny this?  ;-)

--
Jason
Roland Carlsson wrote:

If I remember correctly a schema is to Ojb the same thing as the user.  You
specify the login to the database you are going to use and then you can use
all objects that the user has rights to use. I'm not sure if the
<Schema>.<Resource> notation work but you could prehaps create synoyms for
those objects?
Regards
Roland
----- Original Message ----- 
From: "Jason Mihalick" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 22, 2003 11:56 AM
Subject: [Re-post] indirection-table and schema

 

Does the indirection-table attribute on a <collection-descriptor> pick up
   

a
 

schema name from anywhere or is this something you have to specify in the
value of the indirection-table attribute?
Example:

If my schema name is SYSADM and my indirection table is FOO_BAR, does my
indirection-table attribute need to look like this?
<class-descriptor
     table="FOO"
     schema="SYSADM"
     ...
   

     

  <collection-descriptor
     ...
     indirection-table="SYSADM.FOO_BAR"
  >
     ...
  </collection-descriptor>
</class-descriptor>

OR is the schema inherited from parent class-descriptor?

Thanks in advance,
Jason


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
   



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]