| <?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 Derby JDBC Connection Properties"/> |
| <meta name="abstract" content="Edit the properties of a Derby JDBC connection profile."/> |
| <meta name="description" content="Edit the properties of a Derby 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/asc1229700366088.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_derby_connection_properties.xml"/> |
| <meta name="DitaCms:MapImporter:OriginalObjectId" content="reference_0428C917A1E74ED18DF2DA6D930D29FE"/> |
| <meta name="status" content="Authoring:initial"/> |
| <meta name="source" content="Map Importer"/> |
| <meta name="comment:system" content="Imported topic [2008/12/19 08:26:07]"/> |
| <meta name="DC.Format" content="XHTML"/> |
| <meta name="DC.Identifier" content="asc1229700367572"/> |
| <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 Derby JDBC Connection Properties</title> |
| <meta name="provider" content="Sybase, Inc."/></head> |
| <body id="asc1229700367572"><a name="asc1229700367572"><!-- --></a> |
| <br/> |
| |
| <h1 class="topictitle1">Connection Profile Derby JDBC Connection Properties</h1> |
| |
| |
| |
| <div><p>Edit the properties of a Derby JDBC connection profile. |
| </p> |
| |
| |
| <div class="tablenoborder"><a name="asc1229700367572__table_6CD90CCD3CB64D88AD05D790AFBD2DF2"><!-- --></a><table cellpadding="4" cellspacing="0" summary="" id="asc1229700367572__table_6CD90CCD3CB64D88AD05D790AFBD2DF2" frame="border" border="1" rules="all"> |
| |
| |
| <thead align="left"> |
| <tr> |
| <th class="cellrowborder" valign="top" id="d3541e51">Property |
| </th> |
| |
| <th class="cellrowborder" valign="top" id="d3541e54">Description |
| </th> |
| |
| </tr> |
| |
| </thead> |
| |
| <tbody> |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d3541e51 "> Drivers</td> |
| |
| |
| <td class="cellrowborder" valign="top" headers="d3541e54 "> Select a driver from the list. If an appropriate driver definition does not exist, you can create one.<br/><a name="asc1229700367572__ul_76F6EF9B124940F8A34D0D114F263122"><!-- --></a><ul id="asc1229700367572__ul_76F6EF9B124940F8A34D0D114F263122"> |
| <li id="asc1229700367572__d27e59"><a name="asc1229700367572__d27e59"><!-- --></a>Select <a name="asc1229700367572__d27e61"><!-- --></a><img id="asc1229700367572__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="asc1229700367572__d27e71"><a name="asc1229700367572__d27e71"><!-- --></a>Select <a name="asc1229700367572__d27e73"><!-- --></a><img id="asc1229700367572__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> |
| |
| </td> |
| |
| </tr> |
| |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d3541e51 ">Database Location</td> |
| |
| <td class="cellrowborder" valign="top" headers="d3541e54 ">Enter the fully qualified path to the database, or click <span class="uicontrol">Browse</span>. You can select an existing database or create a new one.</td> |
| |
| </tr> |
| |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d3541e51 "> User Name |
| </td> |
| |
| <td class="cellrowborder" valign="top" headers="d3541e54 "> User ID associated with the connection profile. |
| |
| </td> |
| |
| </tr> |
| |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d3541e51 "> Password |
| </td> |
| |
| <td class="cellrowborder" valign="top" headers="d3541e54 ">Password for the database server login. |
| |
| |
| |
| |
| </td> |
| |
| </tr> |
| |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d3541e51 "> URL |
| </td> |
| |
| <td class="cellrowborder" valign="top" headers="d3541e54 "> Displays the URL address for the profile. |
| </td> |
| |
| </tr> |
| |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d3541e51 ">Create Database (If Required)</td> |
| |
| <td class="cellrowborder" valign="top" headers="d3541e54 ">Creates a database, if the one you indicated in the <span class="uicontrol">Database Location</span> does not exist.</td> |
| |
| </tr> |
| |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d3541e51 ">Upgrade Database to Current Version</td> |
| |
| <td class="cellrowborder" valign="top" headers="d3541e54 ">Select if you are using an older version of a Derby database and want to use the version that matches the driver version. </td> |
| |
| </tr> |
| |
| <tr> |
| <td class="cellrowborder" valign="top" headers="d3541e51 ">Save Password</td> |
| |
| <td class="cellrowborder" valign="top" headers="d3541e54 ">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="d3541e51 "> Optional</td> |
| |
| <td class="cellrowborder" valign="top" headers="d3541e54 "> |
| <br/><a name="asc1229700367572__ol_5341D009E8B440F3AD96ACE9F4E450E4"><!-- --></a><ol id="asc1229700367572__ol_5341D009E8B440F3AD96ACE9F4E450E4"> |
| <li id="asc1229700367572__d27e86"><a name="asc1229700367572__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="asc1229700367572__d27e98"><a name="asc1229700367572__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="d3541e51 ">Test Connection</td> |
| |
| <td class="cellrowborder" valign="top" headers="d3541e54 ">Ping the |
| server and verify that the connection profile is working.</td> |
| |
| </tr> |
| |
| </tbody> |
| |
| </table> |
| </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/asc1229700366088.html" title="Edit the properties of a JDBC connection profile.">Connection Profile JDBC or Driver 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> |
