To supply the runtime connection information for a Java Database Connectivity (JDBC) database endpoint, create a JDBC connection profile. You can also use the fully-configured default JDBC connection profile installed with Sybase WorkSpace.
To create the connection profile:
In the Enterprise Explorer, right-click Databases and select New.
In the Wizard Selection page, select JDBC Connection Profile and click Next.
Complete the following information on the wizard pages:
Name and Description page
| Field | Description |
|---|---|
| Name | For example, jdbc02. |
| Description | For example, Standard JDBC interface. |
| Auto-Connect | 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 (provided by the database administrator)
| Field | Description |
|---|---|
| Select Driver | Select the driver for your database, for example, Generic JDBC. If no compatible driver exists, click [...] to open the Driver Definitions dialog and define one. |
| URL | For example, jdbc:sybase:Tds:snow:5000/dbPluginTest. |
| User Name | For example, dbadmin. |
| Password | Enter the password for the user name, if required. |
| Filter Properties | |
| Procedures and Functions | If your catalog has the same name as the Database Name, accept this as the default, for example, jdbcdemo. If you have multiple catalogs on your database, enter the appropriate catalog name. |
| Schema | Specify a schema or filter by schema name, using % as the wild card, for example, TABL%. To specify all schemas on 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 on the schema, enter %. |
Click Next.
In the Optional Properties frame, specify one or more connection properties, if necessary, by entering the text in the format KEY=value, for example, DYNAMIC_PREPARE=true. After entering each connection property, click Add to add it to the list.
For complete information on connection properties in JDBC, contact the database administrator.
Repeat the previous step until all connection properties are added, then click Next.
In the Summary page, click Back to make changes or Finish to confirm.
The connection profile icon appears in the Enterprise Explorer under the Databases|JDBC Server folder. If you selected Auto-Connect in the Name and Description page, the connection profile is connected.
If you change the connection properties of a connection profile that is already connected, the connection profile will immediately disconnect from the resources and automatically attempt to reconnect using the updated information.
To browse the server:
In the Enterprise Explorer, navigate to Databases|JDBC Server|YourJDBCServer|Contents|Procedures & Functions.
Setting Up Connection Profiles for Service Development
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com