Creating a JDBC Connection Profile

Create a JDBC connection profile for third-party database servers to supply the runtime connection information for a Java Database Connectivity (JDBC) database endpoint. You can create connection profiles for Sybase database servers, Adaptive Server Enterprise, SQL Anywhere, and Sybase IQ; however, Sybase recommends using the provided connection profile options specific to the database server.

1. In Enterprise Explorer, right-click the server type or enterprise resource for which you want to create a connection profile and select New.
2. On the Wizard Selection page, select the appropriate connection profile type and click Next.
3. Enter a name and description for the connection profile, and click Next.

   Table 1. Create Connection Profile page

   Field	Description
   Name	Enter a unique and descriptive name for the connection profile.
   Description	(Optional) Enter a profile description that helps you distinguish it from others.
   Auto-Connect at Startup	(Optional) Connect automatically to the server and display its contents in Enterprise Explorer when Sybase WorkSpace starts.

4. In the Specify a Driver and Connection Details page, enter the rest of the connection profile details.

   Table 2. Specify a Driver and Connection Details page

   Field	Description
   Select a driver from the drop-down	Select a driver for your database. If connecting to a supported third-party database, click [...] to open the Driver Definitions dialog to select a connection profile template. For third-party databases, you need to add the appropriate JAR file from the installation. If deploying a web service to EAServer or Service Container, you need to add the JAR to the lib\ext directory in the EAServer installation. The default connection information appears in the rest of the fields. Select Generic JDBC Driver to create connection profiles for other third-party database servers for which Sybase does not provide a connection profile template.
   Database	The database associated with the connection profile, which is populated with the default based on the selected database driver. You can use the default or enter a different database name.
   URL	Enter the URL address for the profile or modify the sample syntax provided for your database driver, if necessary. In most cases, if you selected a provided driver, you do not need to modify the value in this field. For example, jdbc:sybase:Tds:snow:5000/dbPluginTest
   User Name	Enter the name of the authorized user.
   Password	Enter the password for the database server login, if required.
   Save Password	Select this checkbox to save the password for this connection profile. Passwords persist for the current WorkSpace session. If you do not save your password and exit WorkSpace, you have to enter it when trying to connect to the database server via the connection profile for the new WorkSpace session. Note: Whether you want to save your password depends on your organization's security policy. Passwords are saved into the ServerProfiles.dat file with minimal encryption.
   Optional Properties text box	In the text box, specify connection properties using the KEY=value format, or choose from the drop-down list, and click Add. For example, DYNAMIC_PREPARE=true. Use the Up, Down, Remove, and Clear All buttons to delete or change the order of the connection properties.

5. Click Test Connection to ping the server and to verify that the connection profile is working.
6. Click Finish to create the connection profile.

   The connection profile displays under the appropriate category in the Enterprise Explorer.

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com