Re: Rename connection to

Hi

No, i don't think you can,
you have to reconnect,
and if you can do that, you will
lost the ability to using
your application server's connection pooling i don't think you want that !

hth
Chris

"James Clement" <james.clement_at_ssq.ca> wrote in message news:<YqxM7.4714$3i2.865155_at_news20.bellglobal.com>...
> Hi,
>
> Is this possible to rename my connection (with new user Id/password) after
> my application server is connected to Oracle8i? I want to use the same
> connection because i would like that the audit is carried out on the level
> of the database and not on the level of the application. I do not want to
> preserve the connection initial because it is not a name (userId) of the
> person having to carry out the changes in the database. It would be
> impossible to know which carries out the changes in the database if we keep
> the initial connection of the server of application.
>
>
>
> Example:
>
> Initail connection by the application server:
> String driverName = "oracle.jdbc.driver.OracleDriver";
>
> connectStr="jdbc:oracle:thin:SERVER_APPLICATION/PASSWORD_SERVER_APPLICATION_at_
> IP-Adress:Port:SID
>
>
> I want, after the connection is established, to change the
> SERVER_APPLICATION for another USERID.
> - Is this possible to change the USER with JDBC or Stored Procedure?
>
>
> Thanks and sorry for english.
Received on Tue Nov 27 2001 - 15:05:00 CET