Connecting to a Database Using a JDBC Driver

Updated instructions for the Eclipse Edition to connect to a database using a JDBC driver.

1. Download the driver.

   JDBC driver for:	URL
   Oracle	http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html
   DB2	http://www-306.ibm.com/software/data/db2/express/download.html
   SQL Server	http://msdn.microsoft.com/en-us/data/aa937724.aspx

2. Place the JDBC driver in the com.sybase.com.<database_type>\lib directory. For example: com.sybase.uep.com.oracle.<plugin version number>\lib
3. To create a connection profile to the server, right-click Databases in Enterprise Explorer and select New from the context menu.
4. Select Generic JDBC Connection and click Next.
5. Enter the connection name and click Next.
6. Click the ellipsis (...) and expand the driver type you are creating, for example, Oracle.
7. If you selected Oracle, select Oracle Thin Driver.
8. Click Edit.
9. Configure the driver and click OK.
10. Enter the URL, user name, and password and 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.