Orindasoft

JDBCWizard Web Service Generator Reference Manual

Installing JDBCWizard

Topics

1. Windows Installation
   
2. Installing Orindabuild using an Eclipse Update Site
   
3. Installing Orindabuild on Unix
   

Windows Installation

To install JDBCWizard.

1. Save the JDBCWizard.exe file on your computer.



2. Double-click the JDBCWizard.exe file
   
   - Or -
   
   Choose Run from the Windows Start menu



3. Write down the version number and the license expiration date.
In this example, the version number is 5.0.2184:


You must know the version and license information to obtain Orinda Software support or to check for updates to the JDBCWizard documentation.




Important: If the expiration date of the JDBCWizard.exe file has passed, you can install JDBCWizard but you cannot generate code.

Before installation you can check the version and expiration date by right-clicking on the JDBCWizard.exe file and selecting the Properties menu item:

 




4. Choose where to install JDBCWizard on your computer.







5. Read the licence agreement. If you accept it indicate this by clicking on "I Agree" and then "Next"







If you use Oracle's JDeveloper 10g you can install Orindabuild as an extension. You can also install this extension manually by copying the file"JDBCWizard.ddin40.jar" from the "JDev10G" directory beneath JDBCWizard.s home directory into Oracle JDeveloper's "jdev/lib/ext" directory. Information on how to use this extension is available

here.





If you use Eclipse 3.0  you can install Orindabuild as a Plugin. You can also install this plugin  manually by copying the subbdirectory "com.orindasoft.app.procbuilder.ec30_4.0.XXXX" from the "Eclipse30" directory beneath JDBCWizard.s home directory into Eclipse's "Plugins" directory. Information on how to use this plugin is available here.






6. Choose the version of the Java Developer's Kit (JDK) recommended by the JDBCWizard installer or another version on your computer

9. The installation program will then begin to copy the JDBCWizard files to your system:
   

10. Choose the Finish button to complete the installation.

JDBCWizard Installed Components

1. The installation creates an Orinda Software group in your Windows Start > Programs menu:
   
   
   
   The Orinda Software program group items are:
   
   

   Program Group Item	Used for
   JDBCWizard 8.1.5	JDBCWizard version optimized for Oracle 8.1.5
   JDBCWizard 8.1.6	JDBCWizard version optimized for Oracle 8.1.6
   JDBCWizard 8.1.7	JDBCWizard version optimized for Oracle 8.1.7
   JDBCWizard 9.0.1	JDBCWizard version optimized for Oracle 9.0.1
   JDBCWizard 9.2.0	JDBCWizard version optimized for Oracle 9.2.0
   JDBCWizard 10.1.0	JDBCWizard version optimized for Oracle 10.1.0
   JDBCWizard 10.2.0	JDBCWizard version optimized for Oracle 10.2.0
   JDBCWizard 11.1.0	JDBCWizard version optimized for Oracle 11.1.0
   Purchase JDBCWizard.br>	Open up the JDBCWizard Purchase page in your browser
   JDBCWizard Documentation	Accessing the JDBCWizard User Guide in HTML format
   JDBCWizard Web Site	Accessing the Orinda Software web site




2. The installation locates the following files on your computer:
   
   

   Installation Directory	Files Installed
   Installdir/	BAT batch files and SH shell scripts used to run the application and to delete log files.
   Installdir/conf	The JDBCWizard.pb2 configuration file.
   Installdir/doc	JDBCWizard User Guide and Orinda Software Public Java API documentation.
   Installdir/Src	Zip files containing the source code for the www.orindasoft.pub classes
   Installdir/Demo	JDBCWizard demonstration files.
   Installdir/Eclipse30	JDBCWizard Eclipse 3.0 Plugin files.
   Installdir/JDev10G	JDBCWizard Oracle JDeveloper 10g extension files.
   Instaldir/lib	Common JAR files, program icons and graphics
   Installdir/lib/815	Oracle 8.1.5 specific JAR and ZIP files.
   Installdir/lib/816	Oracle 8.1.6 specific JAR and ZIP files.
   Installdir/lib/817	Oracle 8.1.7 specific JAR and ZIP files.
   Installdir/lib/901	Oracle 9.0.1 specific JAR and ZIP files.
   Installdir/lib/920	Oracle 9.2.0 specific JAR and ZIP files.
   Installdir/lib/1010	Oracle 10.1.0 specific JAR and ZIP files.
   Installdir/lib/1020	Oracle 10.2.0 specific JAR and ZIP files.
   Installdir/lib/1110	Oracle 11.1.0 specific JAR and ZIP files.
   Installdir/lib/1120	Oracle 11.2.0 specific JAR and ZIP files.
   Installdir/PlsqlDev	PL/SQL Developer 7.0 plugin files
   Installdir/PlsqlDevWork	Temporary directory used by PL/SQL Developer 7.0 plugin
   Installdir/logs	The JDBCWizard installation program and the JDBCWizard log files.
   InstallDir/Logs/OldIniFiles	The last 10 saved PB2 files.

Eclipse Update Site Installation

Installing JDBCWizard from an Eclipse update site

If you are an eclipse user you can install the demo version of the Eclipse Plugin using an Eclipse update site.

To start select "Help", "Software Updates" and then "Find and Install"

If you have already installed the JDBCWizard Plugin for Eclipse then select "Search for updates of the currently installed features".

If you haven't installed the Plugin select "Search for new features to install"

Then select "New Remote Site". Enter "Orinda Software" for the Name and the URL http://www.orindasoft.com/public/ec33/site.xml. The select "Finish".

The search should show entry for JDBCWizard under "Orinda Software". Check the boxes and move on the the licence screen.. The select "Finish".

In order to finish the installation you must agree to the terms of the licence. For more information on licensing see here.. Then select "Next".

The second last screen allows you to control where the JDBCWizard plugin is installed. Select "Finish" to complete the installation.

The last screen advises you that the plugin is unsigned. Select "Finish" to complete the installation.

Unix Installation

Installing JDBCWizard on Unix

You can run JDBCWizard in graphical mode if you have a Unix workstation or emulator.


To install JDBCWizard.

1. Install JDBCWizard on a Windows computer.
2. Copy the entire installation directory structure to your Unix computer. Take care not to corrupt any of the installed files during this process. Your licence terms may require you to delete the original imstallation once you have copied the files.
3. Set the following environment variables using the provided shellscripts:




Unix Environment Variable ...	Purpose...
JAVA_HOME	The Java home directory for your computer. JAVA_HOME should be set so that the Java executable is located at ${JAVA_HOME}/bin/java
DISPLAY	If you wish to use the graphical user interface (GUI) version, DISPLAY must refer to a valid X-Windows emulation server. If the DISPLAY variable cannot be set, you can run JDBCWizard in command line mode only.

• You can run JDBCWizard in graphical mode if you have a Unix workstation or suitable X-Windows emulation software.
• You can still run JDBCWizard in command line mode on Unix even if the DISPLAY variable cannot be set to a valid value.
• The Windows 'Skin' is not available when JDBCWizard is being run on Unix
• See the "Command Line" section in this document for more information.

Running JDBCWizard on Unix

Below is an example of how to run the JDBCWizard GUI on a Unix platform such as Solaris^® or Linux.

In this case a Windows installation was copied in its entirety to a directory called 'JDBCWizard. on a Solaris workstation called 'unix_test'.

Then the following happens:

1. Change directory to the JDBCWizard directory.
2. Find out where Java is installed, verify that it's an acceptable version and set JAVA_HOME accordingly.
3. Find the name of the computer and use it to set the DISPLAY variable - in this case the computer is directly connected to a monitor.
4. Export the environment variables JAVA_HOME and DISPLAY so they are visible to the JDBCWizard.20.sh script.
5. Start the JDBCWizard.20.sh script by passing in a name for a configuration file




bash-2.03$ cd JDBCWizard./code> bash-2.03$ cd JDBCWizard./code> bash-2.03$ ls -l total 46 drwxr-xr-x   2 spooky   oinstall     512 Mar 19 13:15 conf -rw-r--r--   1 spooky   oinstall      43 Mar 19 13:15 dellogs.bat drwxr-xr-x   3 spooky   oinstall     512 Mar 19 13:15 demo drwxr-xr-x   3 spooky   oinstall     512 Mar 19 13:15 doc drwxr-xr-x   4 spooky   oinstall     512 Mar 19 13:16 Eclipse30 drwxr-xr-x   2 spooky   oinstall     512 Mar 19 13:16 Jdev10G drwxr-xr-x   9 spooky   oinstall     512 Mar 19 13:17 lib drwxr-xr-x   3 spooky   oinstall     512 Mar 19 13:17 logs -rw-r--r--   1 spooky   oinstall     960 Mar 19 13:17 JDBCWizard.010.sh -rw-r--r--   1 spooky   oinstall     960 Mar 19 13:17 JDBCWizard.020.sh -rw-r--r--   1 spooky   oinstall     955 Mar 19 13:17 JDBCWizard.15.sh -rw-r--r--   1 spooky   oinstall     954 Mar 19 13:17 JDBCWizard.16.sh -rw-r--r--   1 spooky   oinstall     954 Mar 19 13:17 JDBCWizard.17.sh -rw-r--r--   1 spooky   oinstall     954 Mar 19 13:17 JDBCWizard.01.sh -rw-r--r--   1 spooky   oinstall     954 Mar 19 13:17 JDBCWizard.20.sh -rw-r--r--   1 spooky   oinstall     352 Mar 19 13:17 JDBCWizard.1010.bat -rw-r--r--   1 spooky   oinstall     352 Mar 19 13:17 JDBCWizard.1020.bat -rw-r--r--   1 spooky   oinstall     347 Mar 19 13:17 JDBCWizard.815.bat -rw-r--r--   1 spooky   oinstall     346 Mar 19 13:17 JDBCWizard.816.bat -rw-r--r--   1 spooky   oinstall     346 Mar 19 13:17 JDBCWizard.817.bat -rw-r--r--   1 spooky   oinstall     346 Mar 19 13:17 JDBCWizard.901.bat -rw-r--r--   1 spooky   oinstall     346 Mar 19 13:17 JDBCWizard.920.bat -rw-r--r--   1 spooky   oinstall     350 Mar 19 13:17 JDBCWizard.DEMO.bat -rw-r--r--   1 spooky   oinstall     958 Mar 19 13:17 JDBCWizard.EMO.sh drwxr-xr-x   2 spooky   oinstall     512 Mar 19 13:17 src bash-2.03$ which java /usr/bin/java bash-2.03$ java -version java version "1.2.2" Solaris VM (build Solaris_JDK_1.2.2_10, native threads, sunwjit) bash-2.03$ JAVA_HOME=/usr bash-2.03$ uname -n unix_test bash-2.03$ DISPLAY=unix_test:0.0 bash-2.03$ export JAVA_HOME DISPLAY bash-2.03$ sh JDBCWizard.20.sh newfile.pb2 Starting GUI on Display unix_test:0.0




6. Provided DISPLAY has been set correctly the application will then start: