birt-02-6.html from BIRT at Krugle
Show birt-02-6.html syntax highlighted
<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<meta name="GENERATOR" content="Quadralay WebWorks Publisher 2003 for FrameMaker 8.0.7.2249" />
<meta name="TEMPLATEBASE" content="Dynamic-HTML-Eclipse-20060620" />
<meta name="LASTUPDATED" content="06/23/06 16:56:44" />
<title>How to add a JDBC driver</title>
<link rel="StyleSheet" href="document.css" type="text/css" media="all" />
<link rel="StyleSheet" href="catalog.css" type="text/css" media="all" />
<link rel="contents" title="Table of Contents" href="TOC.html" />
<link rel="first" title="First" href="TOC.html" />
<link rel="last" title="Last" href="birt-24-1.html" />
<link rel="previous" title="Previous" href="birt-02-5.html" />
<link rel="next" title="Next" href="birt-02-7.html" />
</head>
<body>
<table id="SummaryNotReq1" border="0" align="right" cellpadding="4" cellspacing="0">
<tr>
<td>
<a accesskey="4" href="birt-02-5.html"><img id="LongDescNotReq1" src="images/prev.gif" border="0" alt="Previous Topic" /></a><a accesskey="5" href="birt-02-7.html"><img id="LongDescNotReq2" src="images/next.gif" border="0" alt="Next Topic" /></a>
</td>
</tr>
</table>
<br />
<br />
<!-- AC_CONTENT -->
<a name="wp191398"> </a><h4 class="pHeading4">
How to add a JDBC driver
</h4>
<a name="wp217174"> </a><p class="pBody">
If you have an existing JDBC data source, you can add JDBC drivers by editing the data source.
</p>
<div class="pSmartList1"><ol type="1" class="pSmartList1">
<a name="wp217178"> </a><div class="pSmartList1"><li>In BIRT Report Designer, open an existing report design.</li></div>
<a name="wp217180"> </a><div class="pSmartList1"><li>Choose Data Explorer.</li></div>
<a name="wp217181"> </a><div class="pSmartList1"><li>Right-click an existing JDBC data source, then choose Edit from the context menu. Edit Data Source appears, as shown in <a href="birt-02-6.html#wp216726">Figure 2-11</a>.</li></div>
<a name="wp191415"> </a><p class="pBodyRelative">
<img src="images/jdbc_edit_driver_manager.gif" height="167" width="367" id="wp191410" border="0" hspace="0" vspace="2"/>
</p>
<a name="wp216726"> </a><div class="pFigTitle">
Figure 2-11 Adding a JDBC driver
</div>
<a name="wp191418"> </a><div class="pSmartList1"><li>Choose Manage Drivers. The JDBC driver manager appears, as shown in <a href="birt-02-6.html#wp216728">Figure 2-12</a>.</li></div>
<a name="wp191428"> </a><p class="pBodyRelative">
<img src="images/manage_jdbc_drivers_jar_files.gif" height="308" width="400" id="wp191423" border="0" hspace="0" vspace="2"/>
</p>
<a name="wp216728"> </a><div class="pFigTitle">
Figure 2-12 Managing JDBC drivers
</div>
<a name="wp191431"> </a><div class="pSmartList1"><li>To add the JAR files for the additional driver, choose Add, then navigate to the directory that contains the driver class file, select the driver JAR file, and choose Open. </li></div>
<a name="wp201802"> </a><div class="pSmartList1">The driver manager appears, showing the new driver class. BIRT Report Designer copies the JAR file to the Eclipse JDBC directory.</div>
<a name="wp191441"> </a><div class="pSmartList1"><li>Choose Drivers to see the drivers page, as shown in <a href="birt-02-6.html#wp216730">Figure 2-13</a>. </li></div>
<a name="wp191451"> </a><p class="pBodyRelative">
<img src="images/manage_jdbc_drivers_drivers_selected.gif" height="240" width="400" id="wp191446" border="0" hspace="0" vspace="2"/>
</p>
<a name="wp216730"> </a><div class="pFigTitle">
Figure 2-13 Viewing JDBC driver classes
</div>
<a name="wp191455"> </a><div class="pSmartList1"><li>Specify the properties for a driver:</li></div>
<div class="pSmartList2"><ol type="1" class="pSmartList2">
<a name="wp191456"> </a><div class="pSmartList2"><li>Select the new driver, then choose Edit. Edit JDBC Driver appears, as shown in <a href="birt-02-6.html#wp216732">Figure 2-14</a>.</li></div>
<a name="wp191466"> </a><p class="pBodyRelative">
<img src="images/edit_jdbc_driver.gif" height="106" width="271" id="wp191461" border="0" hspace="0" vspace="2"/>
</p>
<a name="wp216732"> </a><div class="pFigTitle">
Figure 2-14 Editing a JDBC driver URL template
</div>
<a name="wp191468"> </a><div class="pSmartList2"><li>Specify settings for the JDBC driver:</li></div>
<div class="pSmartList3"><ul class="pSmartList3">
<a name="wp191471"> </a><div class="pSmartList3"><li>In Driver Display Name, type a name that you want to use for this driver in the Display Name column in the driver manager. </li></div>
<a name="wp191475"> </a><div class="pSmartList3"><li>In URL Template, type the syntax suggestion that you want to display for this driver in Database URL on New Data Source.</li></div>
</ul></div>
<a name="wp191476"> </a><div class="pSmartList2">Choose OK. The driver manager displays the new display name and URL template syntax suggestion.</div>
</ol></div>
<a name="wp191478"> </a><div class="pSmartList1"><li>Choose OK. New Data Source--New Data Source appears.</li></div>
</ol></div>
<!-- /AC_CONTENT -->
<!--
<blockquote>
< !--BeginHiddenExpansion Dollar_BP80PageASP_Content; EndHiddenExpansion-- >
</blockquote>
<br />
-->
<br />
<a href="../notices.html">
<img src="images/ac-copyright.gif" width="296" height="14" border="0" alt="(c) Copyright Actuate Corporation 2006" /><br />
</a>
<br />
<!--
<hr />
<table id="SummaryNotReq2" align="right" border="0" cellspacing="0" cellpadding="4">
<tr>
<td align="right">
<span style="font-size: 10px">
<img src="images/actuate_logo.gif" width="186" height="42" border="0" alt="(c) Copyright Actuate Corporation 2005" /><br />
<span style="font-size: 14px ; font-weight: bold; font-family: Arial, Helvetica, sans-serif">
Actuate Corporation<br />
</span>
Actuate Corporation<br />
<a href="http://www.actuate.com">http://www.actuate.com</a><br />
<a href="mailto:info@actuate.com">info@actuate.com</a>
<br />
</span>
</td>
</tr>
</table>
-->
<table id="SummaryNotReq3" border="0" align="left" cellpadding="4" cellspacing="0">
<tr>
<td>
<a accesskey="4" href="birt-02-5.html"><img id="LongDescNotReq3" src="images/prev.gif" border="0" alt="Previous Topic" /></a><a accesskey="5" href="birt-02-7.html"><img id="LongDescNotReq4" src="images/next.gif" border="0" alt="Next Topic" /></a>
</td>
</tr>
</table>
</body>
</html>
See more files for this project here