Oracle JDBC (Unix)
Using the JDBC driver from Oracle:
- 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
- Install JDesignerPro if you haven't already
- Unzip the jdbc.tar.Z to a temporary directory
- Unzip classes111.zip from the \lib dir into the JDesignerPro dir
- Start JaggServer
- Start JDesignerPro
- 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.