Oracle JDBC (Windows)


There are two ways to use JDP with Oracle on Windows:

Using the Oracle 7.3 ODBC driver:

  1. Download the 7.3 ODBC driver for your database from the following link. The driver must be version 7.3 or later.

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

  2. Install JDesignerPro if you haven't already
  3. Install the ODBC driver
  4. Create a System data source from the ODBC control panel using the 7.3 driver (see the Oracle docs for the SQLNet parameters). Generally the SQL*net string will be of the form P:<machinename>:ORCL or T:<machinenameorIP>:ORCL depending on which protocol listener service you have installed.
  5. Start JaggServer
  6. Start JDesignerPro from the JDP icon
  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 sun.jdbc.odbc.JdbcOdbcDriver for the JDBC Driver
  9. Select jdbc:odbc: for the JDBC prefix
  10. Select the Datasource that you previously created from the JDBC Suffix pulldown
  11. Enter the admin username/password of your choice
  12. Press the Install JDP Button (if installing JDP) or press the Connect button.

Using the JDBC driver from Oracle:

  1. Download jdbc.zip from the following link. This is not the thin driver but the regular one:

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

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