Oracle JDBC (Unix)


Using the JDBC driver from Oracle:

  1. Download jdbc.tar.Z from the following link. This is not the thin driver but the oci one although you can use the thin one if you like:

    http://www.oracle.com/products/free_software/index.html

  2. Install JDesignerPro if you haven't already
  3. Unzip the jdbc.tar.Z to a temporary directory
  4. Unzip classes111.zip from the \lib dir into the JDesignerPro dir
  5. Start JaggServer
  6. Start JDesignerPro
  7. At the Setup or Select a Datasource screen (if you already have JDP installed) press the New button, enter Oracle for the database name
  8. Select oracle.jdbc.driver.OracleDriver for the JDBC Driver
  9. Select jdbc:oracle:oci7: for the JDBC prefix
  10. Enter @ for the JDBC Suffix
  11. Enter your Oracle username and password
  12. Enter the admin username/password of your choice (if you are installing JDP)
  13. Press the Install JDP Button (if installing JDP) or press the Connect button.

See Selecting a Database for detailed information on setting up a JDBC connection to your database from within JDesignerPro.

If you experience problems please send an email to support@bulletproof.com. Please include the JaggServer console output with any email that you send along with a detailed description of your problem.