import-bot (20212) [Avatar] Offline
#1
[Originally posted by andoy]

The connection cache is great, but is there a way of reusing the DB connection
with another DB userid/password ? I.e. an end user's DB account rather than
have the current userid/password for the connection cache.

Our DBAs insist on people using their own userid's and passwords. It is
obviously quite expensive operation to keep connecting/disconnecting to the DB
whenever we have to do this. How can I get around this ? And more
specifically is there a way to do this for an Oracle DB ?

Regards,
Andrew
import-bot (20212) [Avatar] Offline
#2
Re: Using users own database account
[Originally posted by jasonweiss]

Contact Oracle and complain to them for not implement proxy capabilities that
were part of the latest ANSI SQL spec. Sybase ASE, to my knowledge, is the
only enterprise level database that supports proxy logins properly-- in other
words you can do what you are asking for in Sybase, but not Oracle. Outside
of Oracle enhancing their proxy support, your DBAs will have to relax their
rules. No other app server is going to be able to offer you what you are
looking for either because it is a database problem, not a middleware problem.

Sorry,

Jason Weiss
Sr. Software Engineer
Sybase, Inc.

> The connection cache is great, but is there a way of reusing the DB connection
> with another DB userid/password ? I.e. an end user's DB account rather than
> have the current userid/password for the connection cache.
>
> Our DBAs insist on people using their own userid's and passwords. It is
> obviously quite expensive operation to keep connecting/disconnecting to the DB
> whenever we have to do this. How can I get around this ? And more
> specifically is there a way to do this for an Oracle DB ?
>
> Regards,
> Andrew