Re: Using database objects in different schemas

2018-01-29 Thread André Rothe
can fetch on each slave and then mash them together in an array, but > the objects in the array will not all share the same EC.  Personally, > I’d run away. > >   > > Chuck > >   > >   > > *From: *Paul Hoadley > *Date: *Friday, December 15, 2017 at 2:5

Re: Using database objects in different schemas

2017-12-15 Thread Chuck Hill
: Chuck Hill Cc: André Rothe , WebObjects-Dev Subject: Re: Using database objects in different schemas Hi Chuck, On 16 Dec 2017, at 6:17 am, Chuck Hill mailto:ch...@gevityinc.com>> wrote: I think you can make it work, but it is going to need a database connection for each slave. And

Re: Using database objects in different schemas

2017-12-15 Thread Paul Hoadley
Hi Chuck, On 16 Dec 2017, at 6:17 am, Chuck Hill wrote: > I think you can make it work, but it is going to need a database connection > for each slave. And there can’t be relationships between slaves or between > the master and the slave. And it is going to be susceptible to “bad > assumpti

Re: Using database objects in different schemas

2017-12-15 Thread Chuck Hill
EOAdaptorChannel.Delegate.adaptorChannelShouldEvaluateExpression boolean adaptorChannelShouldEvaluateExpression(EOAdaptorChannel channel, EOSQLExpression expression) Invoked from evaluateExpression to tell the delegate that the adaptor channel object is sending expression to the database server.

Re: Using database objects in different schemas

2017-12-15 Thread Chuck Hill
objects in different schemas Hi André, On 15 Dec 2017, at 6:33 pm, André Rothe mailto:andre.ro...@phosco.info>> wrote: But how does EOF differ the objects? They come from different tables (but with the same name, only the owners differ). The owner I would intercept and change in the SQL cod

Re: Using database objects in different schemas

2017-12-15 Thread André Rothe
Hi Paul, Hm, then I will come back to my first idea, building EOModels dynamically with databaseContext.availableChannel().adaptorChannel().describeModelWithTableNames(namelist) I hope, I can set full-qualified tablenames there. It is a very common method in my business domain to have a mas

Re: Using database objects in different schemas

2017-12-15 Thread Paul Hoadley
Hi André, On 15 Dec 2017, at 6:33 pm, André Rothe wrote: > But how does EOF differ the objects? They come from different tables (but > with the same name, only the owners differ). The owner I would intercept and > change in the SQL code. Can EOF track this without a model? Also the primary >

Re: Using database objects in different schemas

2017-12-15 Thread André Rothe
Hi Markus, But how does EOF differ the objects? They come from different tables (but with the same name, only the owners differ). The owner I would intercept and change in the SQL code. Can EOF track this without a model? Also the primary keys could overlap, because the "slaves" use its own s

Re: Using database objects in different schemas

2017-12-13 Thread Markus Ruggiero
André, I seem to remember that there are hooks in WebObjects that allow you to have a last look at the generated SQL statement before it is executed. You can then fine tune your statements by adding the qualifiying schema name to any table name. No need to fiddle with the EOModel. EOAdaptor de

Re: Using database objects in different schemas

2017-12-12 Thread André Rothe
Hello Jean, The problem with the "slave" accounts is, that I don't have the passwords for them. So I cannot create a connection to every account except the "master" account. Within the "master" there is a table, which holds the account names of the "slaves". So it is possible to get the acco

Re: Using database objects in different schemas

2017-12-12 Thread Jean-François Veillette
Hmmm … reading your email a few times again, it seems that I didn’t understand your problem at first and that my answer was off-topic. I’m still not sure I really understand enough to be of any help, but let me try again with (I hope) a better answer. It seems that you would need a new jdbc conn

Re: Using database objects in different schemas

2017-12-12 Thread Jean-François Veillette
You might need to create a new jdbc connection for every user. If I understand your situation correctly, I would try to use a unique EOF stack for every session (user). In practice this can work well as long as you don’t have too many sessions (exhausting DB connection). You will have to change