Connecting to a Database Using a JDBC Driver

Use the appropriate database specific JDBC driver to create a connection profile to the database.

Prerequisites

Download the appropriate JDBC driver.

Task

To create a connection profile to the server, right-click Database Connections in Enterprise Explorer and select New.
Select Generic JDBC Connection, enter the connection name and click Next.
When specifying a Generic JDBC Connection, you cannot specify a driver type. Instead select the New Driver Definition icon and specify the JAR list for the driver and enter the connection URL, database name, driver class and user id to create a generic JDBC driver.
After configuring the driver, enter database, URL, user name and password for the connection profile. Click Finish.
Note: An Oracle, SQL Server, or DB2 database that is connected with a JDBC driver currently has the following limits in its functionality:
- Dragging and dropping a table onto the mobile application diagram results in the warning: This operation may not generate valid attributes or executable operations for non-Sybase databases. Do you want to continue?
- Clicking the Validate Syntax button in the data source wizard results in an error and the SQL statement does not validate.
- Auto-generated SQL is wrongly prefixed with a database name, which must manually be removed for the database qualification to make the SQL work.