Solved

jdbc connection through Windows OS Authentication

Posted on 2007-11-20
2
2,005 Views
Last Modified: 2008-02-01
We are trying to use jdbc to connect to an Oracle database using Windows OS Authentication.  When using Windows OS Authentication, we don't need to specify the password.

When we try to connect with the jdbc thin client, it says that it will not work without a password specified.

Is there a way to get the jdbc thin client to connect using Windows OS Authentication, or should we be using something like jdbc OCI, etc.?
0
Comment
Question by:dastrw
  • 2
2 Comments
 
LVL 9

Accepted Solution

by:
techji earned 500 total points
ID: 20325782
If I remember it right, there were some security issues around this JDBC thin client using OS Authentication and oracle couldn't come up with a fix and they abandoned it in 9i. Not sure if they added it to 10g as a feature or not. I will have to check the JDBC docs to get a better answer.
0
 
LVL 9

Assisted Solution

by:techji
techji earned 500 total points
ID: 20325794
Sorry mate. Here is what oracle says "Only the JDBC/OCI driver supports an OS authentication login connection." No support yet for OS authentication via JDBC thin client.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  â€¦
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to recover a database from a user managed backup

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now