BowerStudios.com

  • My Lab
  • Family
  • Friends
  • Professional
  • About
Home

Connecting to an SSL enabled Postgres Server with Oracle Sql Developer

daniel —Wed, 03/04/2015 - 9:31am

  • SQL
  1. First, add the Postgres driver to Oracle Sql Developer:

    Tools > Preferences > Database > "Third Party JDBC Drivers" > Add Entry

    Navigate to a save location of the Postgresql JDBC driver from jdbc.postgresql.org

  2. Next, In Oracle Sql Developer, crate a new connection. Give it a Connection Name, Username, HostName, and Port. Now Save.
  3. Exit Sql Developer
  4. Open ~/.sqldeveloper/system4.0.3.16.84/o.jdeveloper.db.connection.12.1.3.2.41.140908.1359/connections.xml
  5. Update the customUrl for the connection you just created to something like:

    <StringRefAddr addrType="customUrl">
    <Contents>jdbc:postgresql://localhost:5432/mydatabasename?ssl=true</Contents>
    </StringRefAddr>

    Basically, we're adding the ?ssl=true parameter to the connection string.

  • Log in to post comments

Navigation

  • Search
  • Recent content
  • Contact Me
  • Mail
  • Pass Hasher
  • Bower Studios Admin

Quotes

daniel —Mon, 02/26/2007 - 12:19pm

Educate your children to self-control, to the habit of holding passion and prejudice and evil tendencies subject to an upright and reasoning will, and you have done much to abolish misery from their future and crimes from society.

—

Benjamin Franklin

  • Log in to post comments
  • daniel's quotes

Popular content

Last viewed:

  • Code Stats with Team City and Intellij Links
  • Add BouncyCastle libs to Runtime of DropWizard
  • Rice Pilaf
  • Is the current request an ajax request?
  • Code examples and Introduction to Spring Batch

Copyright 2019 Daniel Bower
  • My Lab
  • Family
  • Friends
  • Professional
  • About