Re: CakePHP + Oracle : query other schema

[Guillaume Luszack]

Actually it seems to be working with a view. No need for a synonym. As long as the user you're 
connected with

has granted rights on the tables you're guerying of course:)

Sorry for not trying with a view earlier !
G.


Selon Zaky Katalan-Ezra:

Did you try to create a view for the synoname?

On Mon, Mar 7, 2011 at 9:53 PM, guix69 > wrote:


Database is the same, only the schema is different.

My database.php contains the settings to connect to SCHEMA1 but I
would like to make a model to query data from SCHEMA2

I tried using a synonym (inside SCHEMA1, pointing to the desired table
inside SCHEMA2) but it looks like the synonym is invisible to cake.

--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org 
Check out the new CakePHP Questions site http://ask.cakephp.org
 and help others with their CakePHP related
questions.


To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com
 For more options,
visit this group at http://groups.google.com/group/cake-php






--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org 
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.



To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php

Re: CakePHP + Oracle : query other schema

[Zaky Katalan-Ezra]

Did you try to create a view for the synoname?

On Mon, Mar 7, 2011 at 9:53 PM, guix69  wrote:

> Database is the same, only the schema is different.
>
> My database.php contains the settings to connect to SCHEMA1 but I
> would like to make a model to query data from SCHEMA2
>
> I tried using a synonym (inside SCHEMA1, pointing to the desired table
> inside SCHEMA2) but it looks like the synonym is invisible to cake.
>
> --
>  Our newest site for the community: CakePHP Video Tutorials
> http://tv.cakephp.org
> Check out the new CakePHP Questions site http://ask.cakephp.org and help
> others with their CakePHP related questions.
>
>
> To unsubscribe from this group, send email to
> cake-php+unsubscr...@googlegroups.com For more options, visit this group
> at http://groups.google.com/group/cake-php
>

-- 
Our newest site for the community: CakePHP Video Tutorials 
http://tv.cakephp.org 
Check out the new CakePHP Questions site http://ask.cakephp.org and help others 
with their CakePHP related questions.


To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php

Re: CakePHP + Oracle : query other schema

[guix69]

Database is the same, only the schema is different.

My database.php contains the settings to connect to SCHEMA1 but I
would like to make a model to query data from SCHEMA2

I tried using a synonym (inside SCHEMA1, pointing to the desired table
inside SCHEMA2) but it looks like the synonym is invisible to cake.

-- 
Our newest site for the community: CakePHP Video Tutorials 
http://tv.cakephp.org 
Check out the new CakePHP Questions site http://ask.cakephp.org and help others 
with their CakePHP related questions.


To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php

Re: CakePHP + Oracle : query other schema

[Zaky Katalan-Ezra]

Use database 
link

On Mon, Mar 7, 2011 at 5:39 PM, guix69  wrote:

> Hello,
>
> My app is configured via database.php to query a specific oracle
> schema. Is there a way to define a model for data stored in another
> schema? (or is there no other way than querying directly in SQL?)
>
> Thanks
> G.
>
> --
> Our newest site for the community: CakePHP Video Tutorials
> http://tv.cakephp.org
> Check out the new CakePHP Questions site http://ask.cakephp.org and help
> others with their CakePHP related questions.
>
>
> To unsubscribe from this group, send email to
> cake-php+unsubscr...@googlegroups.com For more options, visit this group
> at http://groups.google.com/group/cake-php
>

-- 
Our newest site for the community: CakePHP Video Tutorials 
http://tv.cakephp.org 
Check out the new CakePHP Questions site http://ask.cakephp.org and help others 
with their CakePHP related questions.


To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php

CakePHP + Oracle : query other schema

[guix69]

Hello,

My app is configured via database.php to query a specific oracle
schema. Is there a way to define a model for data stored in another
schema? (or is there no other way than querying directly in SQL?)

Thanks
G.

-- 
Our newest site for the community: CakePHP Video Tutorials 
http://tv.cakephp.org 
Check out the new CakePHP Questions site http://ask.cakephp.org and help others 
with their CakePHP related questions.


To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php