This week's book giveaway is in the Game Development forum.
We're giving away four copies of Badass: Making Users Awesome and have Kathy Sierra on-line!
See this thread for details.
The moose likes Oracle/OAS and the fly likes Oracle Label Security (OLS), jdbc, connection pool Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Badass: Making Users Awesome this week in the Game Development forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Oracle Label Security (OLS), jdbc, connection pool" Watch "Oracle Label Security (OLS), jdbc, connection pool" New topic

Oracle Label Security (OLS), jdbc, connection pool

Jim Atharris

Joined: Jan 07, 2008
Posts: 28

Currently we are using a connection pool (via BEA app server) to access our Oracle database. However, for security purposes, we are going to incorporate OLS. This basically means instead of executing each query (insert/update/delete) as the default user/pwd for the connection (from the connection pool), we now need to execute those queries as a specified user. Additionally we would like to still use the connection pool. Thus creating a connection per user/pwd contradicts the whole reason behind the connection pool: connections are expensive to create.

Does anyone have experience to share or direction to go research?

JH Harrison

Joined: Jul 05, 2006
Posts: 4
We are also looking for a similar solution. But no luck with weblogic connection pool.
What we are experimenting is writing a proxy to our DAO's so that once we get a DB connection from the pool then apply OLS label using proxy. But this has server performance impact especially in enterprise scale app.
Honestly speeking we don't know any other solution and we are still struggling to come-up with a neater solution.

We are hoping Oracle will look into our request and provide elegent solution. In the mean time if any of you find or have any suggestion please share your ideas. Thanks

John H
Cory Max
Ranch Hand

Joined: Jul 20, 2005
Posts: 83
Sorry to revive an old thread but... we are also looking for a solution where we can use a connection pool and oracle label security.

Any takers? We could really use some help.



There are only 10 types of people in this world... Those who understand binary and those who don't.
It is sorta covered in the JavaRanch Style Guide.
subject: Oracle Label Security (OLS), jdbc, connection pool