Solved

jdbc connection through Windows OS Authentication

Posted on 2007-11-20
2
2,013 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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
PL/SQL Search for multiple strings 5 57
help on oracle query 5 45
oracle RMAN - trying to duplicate a database 5 30
Creation date for a PDB 5 21
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to take different types of Oracle backups using RMAN.

773 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