aspose file tools*
The moose likes JDBC and the fly likes new connection class to oracle database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "new connection class to oracle database" Watch "new connection class to oracle database" New topic

new connection class to oracle database

Shashi Prakash
Ranch Hand

Joined: Mar 28, 2007
Posts: 40
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,<br />Target Scwcd<br />SCJP 1.4
I agree. Here's the link:
subject: new connection class to oracle database