• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

new connection class to oracle database

 
Shashi Prakash
Ranch Hand
Posts: 40
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ,

We are planning to have new application where we are going to have oracle database and here we will have OLS ( ORacle label security ) implemented. Due to this we need to have a connection class which will be responsible for making connection to database based on user credentials . Gere we will have some defined user groups and based on that a given user will be able to login to database from application and will be able to fetch data only those which is supposed to and insert with correct label.

I am looking if soemone can help me a good way of doing this as now we will be needing different credentials .

I can use driver manager here but I am mainly concern about connection pooling as forcing each user to have his own Datbase credential defeats the purpose of having a connection pool .

Thanks,

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic