Creating Additional JDBC Connection Profiles

Create a JDBC connection profile to supply the runtime connection information for a Java Database Connectivity (JDBC) database endpoint. Multiple database usage are supported for the following database types:

If you installed Sybase Developer Edition Servers on the same machine as Sybase WorkSpace, a default JDBC database connection profile (MyDatabase) is provided in the Enterprise Explorer.

To create the connection profile:

  1. In the Enterprise Explorer, right-click Databases and select New.

  2. In the Wizard Selection page, select JDBC and click Next.

  3. Complete the following information on the wizard pages and click Next:

    Name and Description page

    FieldDescription

    Name

    Enter a unique and descriptive name for the profile.

    For example, jdbc02

    Description

    		Enter a profile description that helps you distinguish it from others.

    For example, Standard JDBC interface

    Auto-Connect

    (Optional) Select the check box to automatically connect to the server and display its contents in the Enterprise Explorer. This happens whenever the Enterprise Explorer is opened.

    Specify a Driver and Connection Details page

    FieldDescription

    Select Driver

    Select a driver for your database. If no compatible driver exists, click [...] to open the Driver Definitions dialog and define one.

    URL

    Enter the URL address for the profile. Sample URLs are provided.

    For example, jdbc:sybase:Tds:snow:5000/dbPluginTest

    User Name

    Enter the name of the authorized user.

    For example, dbadmin

    Password

    1. Enter the password for the database server login, if required.

    2. Ping the database server. Click Test Connection.

      If the ping fails, verify the connection property values.

     
    Filter Properties

    Procedures and Functions

    Specify a database name, using % as the wild card, for example, DATABASE%. To specify all databases in the catalog, enter %.

    Schema

    Specify a schema or filter by schema name, using % as the wild card, for example, TABL%. To specify all schemas in the catalog, enter %.

    Procedure Name

    Specify a procedure or filter by procedure name, using % as the wild card, for example, ADDR%. To specify all procedures in the schema, enter %.

     

    Other Properties

    1. In the text box, specify connection properties using the KEY=value format and then click Add.

      For example: DYNAMIC_PREPARE=true and clicking Add

    2. Use the Up, Down, Remove, and Clear All buttons to delete or change the order of the connection properties.

      Note

      For more information on connection properties for JDBC, contact the database administrator.

  4. Test the connection. Click Test connection to ping the database server.

  5. Review the Summary page. Click Back to make changes or Finish to create the connection profile.

    The profile appears in the Enterprise Explorer under Databases and in the Database Explorer under Database Connection Profiles. If you selected Auto-Connect in the Name and Description page, the connection profile is also connected.

    Note

    If you change the connection properties of a connection profile that is already connected, the connection profile will immediately disconnect from the resources. A confirmation window asks that you verify the disconnect and following WorkSpace automatically attempts a reconnect using the updated information.

Related Tasks

Using the Default Connection Profiles

Developing a Database Service

Creating an ASA Connection Profile

Creating an ASE Connection Profile

Creating an ASIQ Connection Profile

Related Concept

Connection Profiles

Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com