Resending this bounced message. Sorry about the inconvenience.
alex, majordomo master
-------- Original Message --------
Date: Sat, 28 Oct 2000 01:59:56 +0200
From: Dirk Koschuetzki <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Reusing a connection with different user/password combinations?
[ This message was sent to jonas-users twice without an answer. As I'm
stuck, I resend it to this mailing-list. Sorry, to all who see this mail
again. :-( ]
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".
