Database services communicate with databases using Java Database Connectivity (JDBC). Unwired Orchestrator supports most databases for which a JDBC 2.0-compliant driver is available.
During Design Time, JDBC is used to test connections to database endpoints and to retrieve metadata about stored procedures and result sets. During runtime, JDBC is used to invoke SQL queries and stored procedures.
Before you can use non-Sybase databases, you must provide the JDBC drivers. The drivers must be located on the machine where the Design Time tooling is installed and on the machine where the Runtime engine is installed. On the server the drivers must be located in <server install directory>/jar/ext/jdbc/lib directory. The drivers can be configured at any time before deployment but this configuration is a prerequisite for testing database endpoints or services that use a non-Sybase database. See Setting JDBC Driver Preferences.
The properties for the JDBC connections are set as global properties using the Endpoint Manager New Endpoint Wizard to add a connection for an endpoint. Adding the necessary information for the JDBC connection is part of the process of adding a connection for a database endpoint.
Note: If you have problems connecting to any of the databases, refer to the documentation provided by the database vendor. For problems with the JDBC connection, use Sun's FAQ for JDBC at http://java.sun.com/products/jdbc/faq.html.