aspose file tools*
The moose likes Websphere and the fly likes Connect  oracle databse from Websphere 6.1 with OS Authentication Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Websphere
Bookmark "Connect  oracle databse from Websphere 6.1 with OS Authentication" Watch "Connect  oracle databse from Websphere 6.1 with OS Authentication" New topic
Author

Connect oracle databse from Websphere 6.1 with OS Authentication

Lasy Gsd
Greenhorn

Joined: Sep 16, 2009
Posts: 3
Hi All,

We are using thin client to connect to oracle database from websphere using JNDI data source with JBDC driver and it is working fine.
Now we have enabled OS authentication in Oracle so OS user can log into the database without giving any credentials.
how do i configure websphere to use OS authentication to connect to oracle
Am using oci driver and i do not know what to do with JAAS authetication username and password in the JAAS alias to filed is must
Please help me
Sekhar Choudary
Ranch Hand

Joined: May 03, 2008
Posts: 57

Hi,

Are your websphere and Database running on same machine ?


You can use local OS user names only to use Websphere for OS Authenitcation.




Lasy Gsd
Greenhorn

Joined: Sep 16, 2009
Posts: 3
Yes Both App and DB are on the same machine.
When you connect to oracle database from websphere we do use jdbc thin driver and also we need to pass database login credentials. But here we do not want to pass the login credentials to log into oracle so we are trying to use oci driver instead of thin. But we do not know what all changes need to done in websphere side .
I can log into oracle database from the machine as os user ( sqlplus / ) it wont ask usernamer and password, like this i want to connect to oracle from websphere using os authentication.


Please help ASAP
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connect oracle databse from Websphere 6.1 with OS Authentication