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

[Jason Mihalick <oo...@ecr.net>]

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" <oo...@ecr.net>
>To: <oj...@db.apache.org>
>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: ojb-user-unsubscribe@db.apache.org
>>For additional commands, e-mail: ojb-user-help@db.apache.org
>>
>>
>>    
>>
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
>For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>  
>



---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org