Oracle10.2 SSL with JDBC Thin Driver
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oracle10.2 SSL with JDBC Thin Driver

  1. #1
    Join Date
    Apr 2007
    Location
    Zurich, Switzerland
    Posts
    1

    Oracle10.2 SSL with JDBC Thin Driver

    Hi,
    I'm trying to get an SSL connection between an Oracle10.2 instance (running on Windows XP) and a JDBC client using a Thin Driver (JDK1.5). I configured the oracle instance as following (see also attached files):
    - wallet created with already available certificate and correspondent CA
    - configure ASO for using tcps protocol
    - create a simple Java client
    I do not want to use a certificate on the client side (1-way SSL) because the authentication should still happen via username/password.
    Something goes wrong and the connection will never be stablished because the Java client hangs somewhere: any idea? Did anyone already tried to do the same?
    I attached the following files:
    - tnsnames.ora
    - sqlnet.ora
    - listener.ora
    - java client, with comments

    thanks in advance
    bye
    carlo
    Attached Files Attached Files
    Last edited by cdr; 04-25-2007 at 10:19 AM. Reason: forgot the attachments, sorry ;-)

  2. #2
    Join Date
    Aug 2008
    Posts
    2
    Did you ever solve this???

  3. #3
    Join Date
    Aug 2008
    Posts
    2
    I have discovered a few things:

    1. Encryption of transport layer only as described in the documentation DOES NOT WORK. You need to have a wallet on both the server and client side.
    2. 10g R2 JDBC thin driver DOES NOT WORK. Moving to 11g driver allows for successful SSL handshake and connection.

    Did not test authentication so can't say anything about that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width