This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "new connection class to oracle database" Watch "new connection class to oracle database" New topic
Author

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,


Thanks,<br />Target Scwcd<br />SCJP 1.4
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: new connection class to oracle database
 
Similar Threads
How to change user credentials when accessing DB
writing connection class to oracle
Identity-based Connection Pooling in Jboss
Providing JDBC Connections to Hibernate
Singleton pattern