aspose file tools*
The moose likes Java in General and the fly likes writing connection class to oracle Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "writing connection class to oracle" Watch "writing connection class to oracle" New topic
Author

writing connection class to oracle

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
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31079
    
163

Shashi Prakash wrote: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 .

Right. If your requirement is to have database specific connections, you cannot use connection pooling.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Shashi Prakash
Ranch Hand

Joined: Mar 28, 2007
Posts: 40
Yes , but there is something like Identity based connection pooling in Weblogic server . If we have anything like this in Jboss or else we can achieve this by different means .
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31079
    
163

Shashi,
We have a JBoss forum if you want to ask specifically for JBoss. I don't know of anything generic.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: writing connection class to oracle