| <?xml version="1.0" encoding="UTF-8"?> |
| <!DOCTYPE html |
| PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
| <html lang="en" xml:lang="en"> |
| <head> |
| <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/> |
| <meta name="copyright" content="(C) Copyright 2005"/> |
| <meta name="DC.rights.owner" content="(C) Copyright 2005"/> |
| <meta name="DC.Type" content="reference"/> |
| <meta name="DC.Title" content="Connection Profile JDBC or Driver Connection Properties"/> |
| <meta name="abstract" content="Edit the properties of a JDBC connection profile."/> |
| <meta name="description" content="Edit the properties of a JDBC connection profile."/> |
| <meta name="DC.subject" content="dtp"/> |
| <meta name="keywords" content="dtp"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700360259.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700361681.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700363103.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700364666.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700367572.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700369119.html"/> |
| <meta name="DC.Relation" scheme="URI" content="../../doc/html/asc1229700358681.html"/> |
| <meta name="DC.Creator" content="ekapner"/> |
| <meta name="DitaCms:MapImporter:OriginalFileFullPath" content="\\kohman-xpvm1\tech_pubs_base_pool_1\projects\dtp\dtp\en\source\r_connection_profile_jdbc_connection_properties.xml"/> |
| <meta name="DitaCms:MapImporter:OriginalObjectId" content="reference_190F46B276E04C05BF1A6520C3CDF377"/> |
| <meta name="status" content="Authoring:initial"/> |
| <meta name="source" content="Map Importer"/> |
| <meta name="comment:system" content="Imported topic [2008/12/19 08:26:06]"/> |
| <meta name="DC.Format" content="XHTML"/> |
| <meta name="DC.Identifier" content="asc1229700366088"/> |
| <meta name="DC.Language" content="en"/> |
| <link rel="stylesheet" type="text/css" href="../../styles/commonltr.css"/> |
| <link rel="stylesheet" type="text/css" href="../../styles/doc.css"/> |
| <title xmlns:xs="http://www.w3.org/2001/XMLSchema">Connection Profile JDBC or Driver Connection Properties</title> |
| <meta name="provider" content="Sybase, Inc."/></head> |
| <body id="asc1229700366088"><a name="asc1229700366088"><!-- --></a> |
| <br/> |
| |
| <h1 class="topictitle1">Connection Profile JDBC or Driver Connection Properties</h1> |
| |
| |
| |
| <div><p>Edit the properties of a JDBC connection profile. |
| </p> |
| |
| <div class="section" id="asc1229700366088__section_1A057DE1504D4912BD87E6E358CDD929"><a name="asc1229700366088__section_1A057DE1504D4912BD87E6E358CDD929"><!-- --></a> |
| |
| <div class="tablenoborder"><a name="asc1229700366088__table_6CD90CCD3CB64D88AD05D790AFBD2DF2"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="asc1229700366088__table_6CD90CCD3CB64D88AD05D790AFBD2DF2" frame="border" border="1" rules="all"> |
| |
| |
| <thead align="left"> |
| <tr> |
| <th class="cellrowborder" valign="top" id="d3179e54">Property |
| </th> |
| |
| <th class="cellrowborder" valign="top" id="d3179e57">Description |
| </th> |
| |
| </tr> |
| |
| </thead> |
| |
| <tbody> |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d3179e54 "> Drivers</td> |
| |
| |
| <td class="cellrowborder" valign="top" headers="d3179e57 "> Select a driver from the list. If an appropriate driver definition does not exist, you can create one.<br/><a name="asc1229700366088__ul_0A3C41A6E3B04EE0AC652AB303F636BE"><!-- --></a><ul id="asc1229700366088__ul_0A3C41A6E3B04EE0AC652AB303F636BE"> |
| <li id="asc1229700366088__d27e59"><a name="asc1229700366088__d27e59"><!-- --></a>Select <a name="asc1229700366088__d27e61"><!-- --></a><img id="asc1229700366088__d27e61" src="../image/asc1229700339040.image" alt="New Driver Definition button"/> |
| <span class="uicontrol">New Driver Definition</span> to create a new driver definition.</li> |
| |
| <li id="asc1229700366088__d27e71"><a name="asc1229700366088__d27e71"><!-- --></a>Select <a name="asc1229700366088__d27e73"><!-- --></a><img id="asc1229700366088__d27e73" src="../image/asc1229700340602.image" alt="Edit Driver Definition button"/> |
| <span class="uicontrol"> Edit Driver Definition</span> to edit an existing driver definition.</li> |
| |
| </ul> |
| |
| <p> If deploying a web service to EAServer or Service Container, you need to add the JAR to the <span class="filepath">lib\ext</span> directory in the EAServer installation.</p> |
| |
| </td> |
| |
| </tr> |
| |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d3179e54 ">Database</td> |
| |
| <td class="cellrowborder" valign="top" headers="d3179e57 ">Database associated with the connection profile.</td> |
| |
| </tr> |
| |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d3179e54 "> URL |
| </td> |
| |
| <td class="cellrowborder" valign="top" headers="d3179e57 "> URL address for the profile. |
| In most cases, if you selected a provided driver, you do not need to modify the value in this field. |
| </td> |
| |
| </tr> |
| |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d3179e54 "> User Name |
| </td> |
| |
| <td class="cellrowborder" valign="top" headers="d3179e57 "> User ID associated with the connection profile. |
| |
| </td> |
| |
| </tr> |
| |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d3179e54 "> Password |
| </td> |
| |
| <td class="cellrowborder" valign="top" headers="d3179e57 ">Password for the database server login. |
| |
| |
| |
| |
| </td> |
| |
| </tr> |
| |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d3179e54 ">Save Password</td> |
| |
| <td class="cellrowborder" valign="top" headers="d3179e57 ">Save the password for this connection profile. |
| Passwords persist only for the current session. If you do not save your password and exit the workbench, you have to enter it when trying to connect to the database server via the connection profile for the new session.<div class="note"><span class="notetitle">Note:</span> Whether you want to save your password depends on your organization's security policy. Passwords are saved in the workspace metadata in the <span class="filepath">ServerProfiles.dat</span> file with minimal encryption.</div> |
| |
| </td> |
| |
| </tr> |
| |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d3179e54 "> Optional</td> |
| |
| <td class="cellrowborder" valign="top" headers="d3179e57 "> |
| <br/><a name="asc1229700366088__ol_73A841451EAD44998204DCD642CB4B18"><!-- --></a><ol id="asc1229700366088__ol_73A841451EAD44998204DCD642CB4B18"> |
| <li id="asc1229700366088__d27e86"><a name="asc1229700366088__d27e86"><!-- --></a> In the |
| text box, specify connection properties using the KEY=value format, or choose |
| from the drop-down list, and click |
| <span class="uicontrol">Add</span>. |
| <p>For example, |
| <kbd class="userinput">DYNAMIC_PREPARE=true</kbd>.</p> |
| |
| </li> |
| |
| <li id="asc1229700366088__d27e98"><a name="asc1229700366088__d27e98"><!-- --></a>Use the |
| <span class="uicontrol">Up</span>, |
| <span class="uicontrol">Down</span>, |
| <span class="uicontrol">Remove</span>, and |
| <span class="uicontrol">Clear All</span> buttons to delete or |
| change the order of the connection properties. |
| </li> |
| |
| </ol> |
| |
| </td> |
| |
| </tr> |
| |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d3179e54 ">Test Connection</td> |
| |
| <td class="cellrowborder" valign="top" headers="d3179e57 ">Ping the |
| server and verify that the connection profile is working.</td> |
| |
| </tr> |
| |
| </tbody> |
| |
| </table> |
| </div> |
| |
| </div> |
| |
| </div> |
| |
| <div><div class="reltasks"><strong>Related tasks</strong><br/> |
| <div><a href="../../doc/html/asc1229700358681.html" title="Edit data source/enterprise resource configuration parameters for a specific connection profile.">Editing Connection Profile Properties</a></div> |
| </div> |
| <div class="relref"><strong>Related reference</strong><br/> |
| <div><a href="../../doc/html/asc1229700360259.html" title="Edit the properties common to all connection profiles.">Connection Profile Common Properties</a></div> |
| <div><a href="../../doc/html/asc1229700361681.html" title="Indicate which schemas display in Data Source Explorer.">Connection Profile Default Schema Filter Properties</a></div> |
| <div><a href="../../doc/html/asc1229700363103.html" title="Indicate which stored procedures display in Data Source Explorer.">Connection Profile Default Stored Procedure Filter Properties</a></div> |
| <div><a href="../../doc/html/asc1229700364666.html" title="Indicate which tables display in Data Source Explorer.">Connection Profile Default Table Filter Properties</a></div> |
| <div><a href="../../doc/html/asc1229700367572.html" title="Edit the properties of a Derby JDBC connection profile.">Connection Profile Derby JDBC Connection Properties</a></div> |
| <div><a href="../../doc/html/asc1229700369119.html" title="Connects to the data source and updates version information.">Connection Profile Version Properties</a></div> |
| </div> |
| </div> |
| <div/> |
| </body> |
| </html> |
