Setting preferences allows you to define user and implementation settings. JDBC Driver Paths preferences allow you to register a JDBC driver for each non-Sybase database to be accessed; Sybase JDBC drivers are included and configured automatically when Unwired Orchestrator is installed. When a service is deployed, the JDBC driver information from the endpoint is defaulted to the server-side properties.
To register non-Sybase JDBC drivers:
From the Preferences navigator, select JDBC Driver Paths. The JDBC Driver Paths preferences window displays.
Use the New button
to add the jar file or zip file for the JDBC driver to the list. Browse
to locate the .jar or .zip file for the JDBC driver.
You can add one or more jar or zip files for each JDBC driver that
you wish to register. You can also use the buttons to manage the contents
of the displayed list of drivers.
Use the Up and Down buttons to order the files.
Click OK.
Notes:
- The order the files are listed is important if you need to register multiple
versions of the JDBC driver for a particular database. If more than one
jar file implementing the same JDBC driver is listed, the file closer
to the top of the list is the one that is implemented. The contents of
the list act like a CLASSPATH specification: for two sets of driver files,
the higher set of the desired driver implementation is the one that is
used. You may also register multiple sets of files if you need to support
multiple database versions. Be sure to consider the possible interactions
between the different implementations.
- Some JDBC drivers are supplied using multiple jar or zip files. Be sure
that all required files are added to the list.
At runtime, verify that the JDBC files are in the server <server install directory>/jar/ext/jdbc/lib directory.
Adding and removing JDBC Drivers from the Unwired Orchestrator preferences may disable existing database service endpoints. A driver cannot be used if it is not referenced by an existing connection in the classpath (that is, it must appear in the JDBC Driver Paths list).
You may remove entries in the list. Be sure to verify the database endpoints you have defined before using this feature so that you do not disable access to one or more servers used by your Unwired Orchestrator projects.
Restore Defaults removes all of the JDBC Drivers, except the default Sybase JDBC Driver, from the preferences list.
The JDBC jar and zip files are supplied by the database vendor. Consult the vendor product documentation for information concerning installation, configuration, and accessibility features. That documentation should identify the classname of the JDBC driver that is needed when you add a database endpoint. If you have problems connecting to any of the databases, refer to the documentation for the corresponding JDBC driver. For more information on JDBC, see Sun's FAQ for JDBC at http://java.sun.com/products/jdbc/faq.html.