Re: Connecting to DB with user supplied credentials.

2008-06-11 Thread Ken Anderson
Henrique, Can you give a little background as to why you need to do this? As people have said, it's possible, but it's not terribly straightforward, and can be expensive. Why do you need to login to the DB with separate credentials? Ken On Jun 11, 2008, at 1:28 PM, Lon Varscsak wrote:

Re: Connecting to DB with user supplied credentials.

2008-06-11 Thread Lon Varscsak
Google for: separate database connection WebObjects It's the first apple link (I can't cut and paste on my phone). Look at Project WOnder there may be some stuff there to aid on this. -Lon On 6/11/08, Lon Varscsak <[EMAIL PROTECTED]> wrote: > I believe you need a separate EOF stack for every se

Re: Connecting to DB with user supplied credentials.

2008-06-11 Thread Lon Varscsak
I believe you need a separate EOF stack for every session. While this isn't difficult, you'll need to watch memory. Umm, its not difficult...but, I'm on my iPhone and don't remember how to do it exactly. :) Google around for this, you'll find it, if not I'll catch you later when I get to a comput

Re: Connecting to DB with user supplied credentials.

2008-06-11 Thread Henrique Gomes
Funny, the first connectWithModelNamed throws a NPE, but the second invocation I put on the catch wasn't even necessary. If I only invoke it once, swallow the NPE and continue to fetch some EOs, a connection is then started with the provided credentials... [2008-6-11 16:41:54 WEST] Using JD

Re: Connecting to DB with user supplied credentials.

2008-06-11 Thread Henrique Gomes
Yes, that is correct. I guess I'm asking what is the correct way to do that. Henrique Gomes On Jun 11, 2008, at 4:25 PM, Lon Varscsak wrote: To clarify, you want each session to have it's own connection to the database? Lon On Wed, Jun 11, 2008 at 7:50 AM, Henrique Gomes <[EMAIL PROTEC

Re: Connecting to DB with user supplied credentials.

2008-06-11 Thread Lon Varscsak
To clarify, you want each session to have it's own connection to the database? Lon On Wed, Jun 11, 2008 at 7:50 AM, Henrique Gomes <[EMAIL PROTECTED]> wrote: > > > On Jun 11, 2008, at 3:41 PM, Daniele Corti wrote: > >> But, were you connected to a DB before calling >> EOUtilities.connectWithModel

Re: Connecting to DB with user supplied credentials.

2008-06-11 Thread Henrique Gomes
On Jun 11, 2008, at 3:41 PM, Daniele Corti wrote: But, were you connected to a DB before calling EOUtilities.connectWithModelNamed? I restart the app and only see this message *after* calling EOUtilities.connectWithModelNamed : Using JDBCPlugIn 'PostgresqlPlugIn' for JDBCAdaptor So

Re: Connecting to DB with user supplied credentials.

2008-06-11 Thread Daniele Corti
But, were you connected to a DB before calling EOUtilities.connectWithModelNamed? On Wed, Jun 11, 2008 at 4:37 PM, Henrique Gomes <[EMAIL PROTECTED]> wrote: > > Sorry, the stack trace for the NPE is this: > > EC creation: First failed!!java.lang.NullPointerException > java.lang.NullPointerExceptio

Re: Connecting to DB with user supplied credentials.

2008-06-11 Thread Henrique Gomes
Sorry, the stack trace for the NPE is this: EC creation: First failed!!java.lang.NullPointerException java.lang.NullPointerException at com .webobjects .eoaccess .EODatabaseContext.forceConnectionWithModel(EODatabaseContext.java:1139) at com .webobjects .eoaccess.EOUtilities.connectWi

Connecting to DB with user supplied credentials.

2008-06-11 Thread Henrique Gomes
Hello, In my first WO project, I need to connect to the db using the credentials that users provide on the login page. At most 10-20 users will be using it simultaneous so there won't be scalability problems (I hope). Anyway I tried the following, storing the editing context on the sess