File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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
It's not a secret anymore!