Setting a role on connection pool

From: Arnaud Benjacar <arnaud.benjacar_at_ilim.com>
Date: Wed, 24 Jul 2002 11:28:14 +0100
Message-ID: <ahlvej$lrg$1@kermit.esat.net>

Hi folks,
is it possible to set a role on a connection pool so that any connection will have the relevant role set before executing a stored procedure.
I do not really want to set the role after every getConnection() request.

So far, I've created my own connection pool and executed set role my_role on each connection. But what if I want to use a vendor connection pool. I do not have control on the creation and as I said I don't want to execute a "set role"
on each request.

I doesn't seem like I can pass role=my_role in the Properties in the same way
we have 'user', 'password' or 'url'

Thanks
Arnaud

Oracle driver: oracle.jdbc.driver.OracleDriver Language: Java
App Server: WLS 6.1 Received on Wed Jul 24 2002 - 05:28:14 CDT