| <html> |
| |
| <head> |
| <meta http-equiv=Content-Type content="text/html; charset=windows-1252"> |
| <meta name=Generator content="Microsoft Word 11 (filtered)"> |
| <title>Install Derby</title> |
| |
| <style> |
| <!-- |
| /* Style Definitions */ |
| p.MsoNormal, li.MsoNormal, div.MsoNormal |
| {margin:0in; |
| margin-bottom:.0001pt; |
| font-size:12.0pt; |
| font-family:"Times New Roman";} |
| h2 |
| {margin-top:12.0pt; |
| margin-right:0in; |
| margin-bottom:3.0pt; |
| margin-left:0in; |
| page-break-after:avoid; |
| font-size:14.0pt; |
| font-family:Arial; |
| font-style:italic;} |
| a:link, span.MsoHyperlink |
| {color:blue; |
| text-decoration:underline;} |
| a:visited, span.MsoHyperlinkFollowed |
| {color:purple; |
| text-decoration:underline;} |
| @page Section1 |
| {size:8.5in 11.0in; |
| margin:1.0in 1.25in 1.0in 1.25in;} |
| div.Section1 |
| {page:Section1;} |
| /* List Definitions */ |
| ol |
| {margin-bottom:0in;} |
| ul |
| {margin-bottom:0in;} |
| --> |
| </style> |
| |
| </head> |
| |
| <body lang=EN-US link=blue vlink=purple> |
| |
| <div class=Section1> |
| |
| <h2>Install Derby</h2> |
| |
| <p class=MsoNormal> </p> |
| |
| <ol style='margin-top:0in' start=1 type=1> |
| <li class=MsoNormal>Download Derby 10.0 from:</li> |
| </ol> |
| |
| <p class=MsoNormal> </p> |
| |
| <p class=MsoNormal> <a |
| href="http://db.apache.org/derby/releases/release-10.0.2.1.html">http://db.apache.org/derby/releases/release-10.0.2.1.html</a></p> |
| |
| <p class=MsoNormal> </p> |
| |
| <ol style='margin-top:0in' start=2 type=1> |
| <li class=MsoNormal>Extract the downloaded file to your file system. It is |
| not necessary to configure the Derby server as we will be using the |
| embedded driver which creates a database directly in the file system.</li> |
| </ol> |
| |
| <p class=MsoNormal> </p> |
| |
| <h2>Connect to Derby using DTP</h2> |
| |
| <p class=MsoNormal> </p> |
| |
| <p class=MsoNormal>Please note that DTP currently only allows one Derby connection per Eclipse session. The Derby embedded JDBC driver has special |
| requirements when closing a connection that have yet to be implemented in DTP. |
| Therefore, it is recommended that users do not use the test connection button |
| in the connection configuration UI as this will create the only allowed connection |
| and the user will need to restart Eclipse in order to reconnect and view the |
| database objects in the Data Source Explorer.</p> |
| |
| <p class=MsoNormal> </p> |
| |
| <p class=MsoNormal>To configure a connection to a Derby database:</p> |
| |
| <ol style='margin-top:0in' start=1 type=1> |
| <li class=MsoNormal>In the Data Source Explorer, right-click on the Databases |
| node and select the New
menu item.</li> |
| <li class=MsoNormal>In the resulting dialog select the SQL Model-JDBC |
| Connection profile type and click Next.</li> |
| <li class=MsoNormal>Enter a connection name and click Next.</li> |
| <li class=MsoNormal>Click the
button and click the Add
button in the |
| resulting dialog.</li> |
| <li class=MsoNormal>Now select Derby Embedded JDBC Driver for Derby 10.0 from the Available Driver Templates list and click OK. </li> |
| <li class=MsoNormal>In the Provider Driver Details dialog, edit the Driver |
| File specified so that it points to a valid location of the derby.jar |
| file. Click OK.</li> |
| <li class=MsoNormal>Click OK again on the Available Driver Definitions dialog.</li> |
| <li class=MsoNormal>In the wizard select Derby Embedded JDBC Driver for Derby 10.0 from the combo box labeled Select a driver from the drop-down:.</li> |
| <li class=MsoNormal>In the URL, replace C:\DerbyDatabases\MyDB with a valid |
| location on your system and click Finish. </li> |
| </ol> |
| |
| <p class=MsoNormal> </p> |
| |
| <p class=MsoNormal style='margin-left:.5in'>Note that if the final directory |
| (in this case MyDB) does not exist then the database will be created. If it |
| does exist then it must be a valid Derby database. Avoid the mistake of |
| specifying the final directory as an empty directory because a connection failure |
| will result. </p> |
| |
| <p class=MsoNormal style='margin-left:.5in'> </p> |
| |
| <ol style='margin-top:0in' start=10 type=1> |
| <li class=MsoNormal>Right-click on the connection in the Data Source Explorer |
| and select the Connect menu item. When the connection is open, expand the |
| nodes in the tree to view the database objects.</li> |
| </ol> |
| |
| </div> |
| |
| </body> |
| |
| </html> |