Re: [Sqlrelay-discussion] Multiple databases?

[David M. <dav...@fi...>]

Piotr,

You can access data in multiple schemas by creating an oracle user that
has the necessary permissions to access data in other schemas, configure
SQL Relay to log in as that user, and then refer to table using the
SCHEMA.TABLE notation.

But, you can also set up an oracle user that proxies several other users
and, set authtier="database" in the sqlrelay.conf file and then code
your apps to log into SQL Relay using the user/password for the schema
you want to access.  Here's a page describing how to do it:
http://sqlrelay.sourceforge.net/sqlrelay/oraclentier.html

I'm curious about the segfault though, what are you doing to try to
switch schemas within your app that causes the segfault?

David Muse
dav...@fi...


On Tue, 2006-01-17 at 11:35 +0100, pt...@po... wrote:
>    Hello.
> 
> As I managed to run succesfully SQLRelay with single DB instance connection, I've been trying to rewrite further apps so they communicate with OCI9i database. Then I bumped into issue: when I switch the DB schema inside the application code, it crashes with segfault. If I understand it correctly SQLR is to be configured for one database per daemon only? Is there any way to make it pool connections to different schemas without deploying greater number of daemons?
>    Thanks in advance, regards
> 
> Piotr
> 
> ----------------------------------------------------------------------
> Kliknij po wiecej! >>> http://link.interia.pl/f18ed
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid3432&bid#0486&dat1642
> _______________________________________________
> Sqlrelay-discussion mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion
>