ANSI92 has a syntax to handle a 'proxied' connection
SET SESSION AUTHORIZATION
This syntax would allow an app server with a cached connection to "assume
the identity" of another user on the connection.
This would be a fabulous ting for every datbase but AFAIK only <VENDOR>
Sybase Adaptive Server Enterprise</VENDOR> supports this syntax. In Sybase
<VENDOR> EAServer </VENDOR> our caches know how to handle this syntac and
can 'proxy' a datbase connection to the authenticated applcation server
user.
Otherwise you will have to simply bypass the caching your container provides
you. The problem is that this means you cannot have the container manage
your tx's. The option would be to write your own JDBC2 interface that gave
you this functionality but would work with your app servers caching.
Wouldnt be fun however.
Dave Wolf
Internet Applications Division
Sybase
> -----Original Message-----
> From: A mailing list for Enterprise JavaBeans development
> [mailto:[EMAIL PROTECTED]]On Behalf Of Chen, Andy
> Sent: Tuesday, September 12, 2000 3:44 PM
> To: [EMAIL PROTECTED]
> Subject: [Q] How can a BMP connect to DB w/ each user's pwd and id?
>
>
> Hi, I wonder if anybody try this before.
>
> I am trying to create a BMP Entity Bean with a getConnection() method to
> connect to a database. Instead using a general account to connect the
> database to those BMP Beans through. JDBC or data source, we like to use
> each end user's password and id to create the connection. (Just like those
> old client-server programs)
>
> Is this possible? Is this against the EJB rules? If not, where should I
> store this info? PrimaryKey? EJBBean? Or SessionBean?
>
> Thanks in advance,
>
> Andy
>
> ==================================================================
> =========
> To unsubscribe, send email to [EMAIL PROTECTED] and include
> in the body
> of the message "signoff EJB-INTEREST". For general help, send email to
> [EMAIL PROTECTED] and include in the body of the message "help".
>
>
===========================================================================
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff EJB-INTEREST". For general help, send email to
[EMAIL PROTECTED] and include in the body of the message "help".
