Oracle JDBC (Windows)
There are two ways to use JDP with Oracle on Windows:
Using the Oracle 7.3 ODBC driver:
- 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
- Install JDesignerPro if you haven't already
- Install the ODBC driver
- 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.
- Start JaggServer
- Start JDesignerPro from the JDP icon
- At the Setup or Select a Datasource screen (if you already have JDP installed) press the New button, enter Oracle for the database name
- Select sun.jdbc.odbc.JdbcOdbcDriver for the JDBC Driver
- Select jdbc:odbc: for the JDBC prefix
- Select the Datasource that you previously created from the JDBC Suffix pulldown
- Enter the admin username/password of your choice
- Press the Install JDP Button (if installing JDP) or press the Connect button.
Using the JDBC driver from Oracle:
- Download jdbc.zip from the following link. This is not the thin driver but the regular one:
- Install JDesignerPro if you haven't already
- Unzip the jdbc.zip to a temporary directory
- Copy Oci733jdbc.dll from the \lib dir into the JDesignerPro dir
- Unzip classes111.zip from the \lib dir into the JDesignerPro dir
- Start JaggServer
- Start JDesignerPro from the JDesignerPro icon
- At the Setup or Select a Datasource screen (if you already have JDP installed) press the New button, enter Oracle for the database name
- Select oracle.jdbc.driver.OracleDriver for the JDBC Driver
- Select jdbc:oracle:oci7: for the JDBC prefix
- Enter @ for the JDBC Suffix
- Enter your Oracle username and password
- Enter the admin username/password of your choice (if you are installing JDP)
- 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.