Alexandre Lefebvre wrote:
>
> -------- Original Message --------
>
> Date: Wed, 25 Oct 2000 11:05:47 +0200
> From: Dirk Koschuetzki <[EMAIL PROTECTED]>
> To: jonas users <[EMAIL PROTECTED]>,
> "Dirk
> =?iso-8859-1?Q?Kosch=FCtzki?=" <[EMAIL PROTECTED]>
> Subject: Resend [Reusing a connection with different user/passwd combinations?]
>
> I'm resending the question as I did not see an answer and the
> problem is urgent to me. Sorry! ]
>
> Hello,
>
> simple question: should a call of dataSource.getConnection (user,
> passwd) with different user/passwd combinations open new connections
> (or reuse connections if possible) AND forward the given uid/passwd to
> the database?
YEs. A connection is always associated with a user. 2 differents users
use always 2 different connections.
>
> Background of the question: I tried to insert some data into a table
> which has a column with a default of SQL "user", specification of the
> column is "UID VARCHAR2(32) DEFAULT user". The insert is performed
> with three different database-accounts. All inserts are performed with
> the first user id used by the bean, even if I the getConnection
> operation with the user/passwd arguments is used for the second and
> third user. It seems to me, that the pooling of connections does not
> check the username. As far a I can see, the traces show, that the call
> of getConnection is correct but that the getXAConnection does not open
> a second/third one for the second/third user.
>
> Question: Is this a bug or is I a feature? In case of a feature: what
> may I do to receive my intented behaviour?
>
> TIA!
> Dirk
>
> Ps.: JOnAS 2.1.1, running on Linux with Sun JDK 1.2.2, Database is
> Oracle 8.1.6 on Linux.
>
> Pps.: I have a small test scenario available showing the problem, if
> required.
Could you send us the scenario please ? I think I will better understand
your problem with it.
>
> Ppps.: The "res-auth" for the DataSource is Application, but changing
> it to Container does not help.
res-auth is not checked in this version.
> ----
> To unsubscribe, send email to [EMAIL PROTECTED] and
> include in the body of the message "unsubscribe jonas-users".
> For general help, send email to [EMAIL PROTECTED] and
> include in the body of the message "help".
--
Philippe Durieux ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Bull - 1 rue de Provence - 38432 Echirolles Cedex France
[EMAIL PROTECTED]
-> Download our EJBServer at http://www.evidian.com/ejb <-
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".
