-------- 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?
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.
Ppps.: The "res-auth" for the DataSource is Application, but changing
it to Container does not help.
----
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".
