lucene-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kevin Risden (Confluence)" <conflue...@apache.org>
Subject [CONF] Apache Solr Reference Guide > Solr JDBC - DbVisualizer
Date Fri, 06 May 2016 15:15:53 GMT
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> 
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0">

<base href="https://cwiki.apache.org/confluence"> 
<title>Message Title</title>  
<style type="text/css">@media only screen and (max-device-width: 480px) {.mobile-only
{
    width: auto !important;
    height: auto !important;
    overflow: visible !important;
    line-height: normal !important;
    font-size: inherit !important;
    mso-hide: all;
}

.desktop-only {
    display: none !important;
}

/* iPhone 3GS fix for unwanted 20px right margin */
body {
    min-width: 100% !important;
    padding: 0;
    margin: 0;
}

#center-content-table {
    max-width: none;
!important;
}

#header-pattern-container {
    padding: 10px 10px 10px 10px !important;
    line-height: 20px !important;
}

#header-avatar-image-container {
    padding-right: 8px !important;
}

#email-content-container {
    padding: 0 !important;
}

.mobile-expand {
    border-radius: 0 !important;
    border-left: 0 !important;
    border-right: 0 !important;
    padding-left: 26px !important;
}

.mobile-resize-text {
    font-size: 16px !important;
    line-height: 22px !important;
}

#page-title-pattern-header {
    font-size: 20px !important;
    line-height: 28px !important;
}

#page-title-pattern-icon-image-container-cell {
    padding-top: 7px !important;
}

#inline-user-pattern {
    display: block !important;
}

#inline-user-pattern-avatar {
    padding-top: 3px !important;
}

.contextual-area-pattern {
    border-bottom: 1px solid #ccc !important;
    padding: 15px 10px 0 10px !important;
}

.users-involved-pattern-column-table {
    width: 100% !important;
}

.users-involved-pattern-avatar-table-cell {
    padding: 3px 5px 5px 0 !important;
}

.users-involved-pattern-column-container {
    padding-right: 0 !important;
}

.contextual-excerpt-pattern, #users-involved-pattern {
    border: 0 !important;
}

/** Aui Typography upsized for mobile **/
#content-excerpt-pattern-container, #contextual-excerpt-pattern-text-container {
    font-size: 16px !important;
    line-height: 22px !important;
}

#content-excerpt-pattern-container h1, #contextual-excerpt-pattern-text-container h1 {
    font-size: 24px !important;
    line-height: 28px !important;
}

#content-excerpt-pattern-container h2, #contextual-excerpt-pattern-text-container h2 {
    font-size: 20px !important;
    line-height: 28px !important;
}

#content-excerpt-pattern-container h3, #contextual-excerpt-pattern-text-container h3 {
    font-size: 18px !important;
    line-height: 24px !important;
}

#content-excerpt-pattern-container h4, #contextual-excerpt-pattern-text-container h4 {
    font-size: 16px !important;
    line-height: 22px !important;
}

#content-excerpt-pattern-container h5, #contextual-excerpt-pattern-text-container h5 {
    font-size: 14px !important;
    line-height: 20px !important;
}

#content-excerpt-pattern-container h6, #contextual-excerpt-pattern-text-container h6 {
    font-size: 14px !important;
    line-height: 20px !important;
}

.user-mention {
    line-height: 18px !important;
}

/** Aui Typography end **/

/* Show appropriate footer logo on mobile, display links vertically */
#footer-pattern {
    padding: 15px 10px !important;
}

#footer-pattern-logo-desktop-container {
    padding: 0 !important;
}

#footer-pattern-logo-desktop {
    width: 0 !important;
    height: 0 !important;
}

#footer-pattern-logo-mobile {
    padding-top: 10px !important;
    width: 30px !important;
    height: 27px !important;
    display: inline !important;
}

#footer-pattern-text {
    display: block !important;
}

#footer-pattern-links-container {
    line-height: 0 !important;
}

.footer-pattern-links.mobile-resize-text,
.footer-pattern-links.mobile-resize-text,
#footer-pattern-text.mobile-resize-text,
#footer-pattern-links-container.no-footer-links {
    font-size: 14px !important;
    line-height: 20px !important;
}

.footer-link {
    display: block !important;
}

#footer-pattern-links-container table {
    display: inline-block !important;
    float: none !important;
}

#footer-pattern-links-container, #footer-pattern-text {
    text-align: center !important;
}

#footer-pattern-links {
    padding-bottom: 5px !important;
}

/** Team Calendar overrides, these should be removed when notifications are updated in Team
Calendars. For now CSS
    overrides are being used because the structure of the content can't change without rereleasing
the plugin */
.mail-calendar-container .day-header + table tr td:first-child {
    vertical-align: top !important;
    padding-top: 5px !important;
}}
@media (min-width: 900px) {#center-content-table { width: 900px; }}
@media all {#outlook a {
    padding: 0;
}

/* Force Outlook to provide a "view in browser" menu link. */
/* Prevent Webkit and Windows Mobile platforms from changing default font sizes.*/
body {
    -webkit-text-size-adjust: 100%;
    -ms-text-size-adjust: 100%;
}

.ExternalClass {
    width: 100%;
}

/* Force Hotmail to display emails at full width */
#background-table {
    margin: 0;
    padding: 0;
    width: 100% !important;
}

/* Needed to override highlighting on date and time links in iOS */
.grey a {
    color: #707070;
    text-decoration: none;
}/* These styles are appended to the head element of a notification in order to prevent Apple
Mail and similar
   clients from underlining the due dates with a blue hyperlink */
/* a lozenge outside an inline task should always be #333, lozenges inside an inline task
should be
   colored according to their upcoming due dates, a completed task date lozenge or deleted
task date
   lozenge should always be #707070 */
.date-time-lozenge a {color: #333333; text-decoration: none; }
.inline-task-text-container .date-time-lozenge.date-upcoming a {color: #DF6F00; text-decoration:
none; }
.inline-task-text-container .date-time-lozenge.date-past a {color: #D04437; text-decoration:
none; }
.inline-task-text-container.content-deleted-color .date-time-lozenge a,
.inline-task-text-container.checked .date-time-lozenge a {
    color: #707070; text-decoration: none;
}}
</style> 
</head>
<body>
<table id="background-table" cellpadding="0" cellspacing="0" width="100%" style="border-collapse:
collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; color: #333; background-color: #f5f5f5">

<tbody> 
<tr> 
<td id="header-pattern-container" style="padding: 0px; border-collapse: collapse; padding:
10px 20px"> 
<table id="header-pattern" cellspacing="0" cellpadding="0" border="0" style="border-collapse:
collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; color: #333"> 
<tbody> 
<tr> 
<td id="header-avatar-image-container" valign="top" style="padding: 0px; border-collapse:
collapse; vertical-align: top; width: 32px; padding-right: 9px"><a href="https://cwiki.apache.org/confluence/display/~risdenk?src=mail&amp;src.mail.timestamp=1462547753579&amp;src.mail.notification=com.atlassian.confluence.plugins.confluence-content-notifications-plugin%3Apage-created-notification&amp;src.mail.recipient=8aa980874e36a1eb014e36a2992a202c"
style="color: #3b73af; text-decoration: none"><img id="header-avatar-image" class="image_fix"
src="cid:avatar_f6ced7834bef5b6b022f00813d300e01" height="32" width="32" border="0" style="border-radius:
3px; vertical-align: top"></a></td>
<td id="header-text-container" valign="middle" style="padding: 0px; border-collapse: collapse;
vertical-align: middle; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px;
mso-line-height-rule: exactly; mso-text-raise: 1px">Kevin Risden <strong>created</strong>
a page</td> 
</tr> 
</tbody> 
</table> </td> 
</tr> 
<!-- End Header pattern --> 
<tr> 
<td id="email-content-container" style="padding: 0px; border-collapse: collapse; padding:
0 20px"> 
<table id="email-content-table" cellspacing="0" cellpadding="0" border="0" width="100%"
style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; color: #333;
border-spacing: 0; border-collapse: separate"> 
<tbody> 
<tr> 
<td class="email-content-rounded-top mobile-expand" style="padding: 0px; border-collapse:
collapse; color: #fff; padding: 0 15px 0 16px; height: 15px; background-color: #fff; border-left:
1px solid #ccc; border-top: 1px solid #ccc; border-right: 1px solid #ccc; border-bottom: 0;
border-top-right-radius: 5px; border-top-left-radius: 5px">&nbsp;</td> 
</tr> 
<tr> 
<td class="email-content-main mobile-expand" style="padding: 0px; border-collapse: collapse;
border-left: 1px solid #ccc; border-right: 1px solid #ccc; border-top: 0; border-bottom: 0;
padding: 0 15px 15px 16px; background-color: #fff"> 
<table id="page-title-pattern" cellspacing="0" cellpadding="0" border="0" width="100%"
style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; color: #333">

<tbody> 
<tr> 
<td id="page-title-pattern-icon-image-container" valign="top" style="padding: 0px; border-collapse:
collapse; width: 16px; vertical-align: top"> 
<table cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse; mso-table-lspace:
0pt; mso-table-rspace: 0pt; color: #333"> 
<tbody> 
<tr> 
<td id="page-title-pattern-icon-image-container-cell" style="padding: 0px; border-collapse:
collapse; width: 16px; padding: 9px 8px 0px 0px; mso-text-raise: 5px; mso-line-height-rule:
exactly"><a href="https://cwiki.apache.org/confluence/display/solr/Solr+JDBC+-+DbVisualizer?src=mail&amp;src.mail.timestamp=1462547753579&amp;src.mail.notification=com.atlassian.confluence.plugins.confluence-content-notifications-plugin%3Apage-created-notification&amp;src.mail.recipient=8aa980874e36a1eb014e36a2992a202c&amp;src.mail.action=view"
title="page icon" style="vertical-align: top;; color: #3b73af; text-decoration: none"><img
style="vertical-align: top; display: block;" src="cid:page-icon" alt="page icon" title="page
icon" height="16" width="16" border="0"></a></td> 
</tr> 
</tbody> 
</table> </td>
<td style="vertical-align: top;; padding: 0px; border-collapse: collapse; padding-right:
5px; font-size: 20px; line-height: 30px; mso-line-height-rule: exactly" id="page-title-pattern-header-container"><span
id="page-title-pattern-header" style="font-family: Arial, sans-serif; padding: 0; font-size:
20px; line-height: 30px; mso-text-raise: 2px; mso-line-height-rule: exactly; vertical-align:
middle"><a href="https://cwiki.apache.org/confluence/display/solr/Solr+JDBC+-+DbVisualizer?src=mail&amp;src.mail.timestamp=1462547753579&amp;src.mail.notification=com.atlassian.confluence.plugins.confluence-content-notifications-plugin%3Apage-created-notification&amp;src.mail.recipient=8aa980874e36a1eb014e36a2992a202c&amp;src.mail.action=view"
title="Solr JDBC - DbVisualizer" style="color: #3b73af; text-decoration: none">Solr JDBC
- DbVisualizer</a></span></td> 
</tr> 
</tbody> 
</table> </td> 
</tr> 
<tr> 
<td class="email-content-main mobile-expand" style="padding: 0px; border-collapse: collapse;
border-left: 1px solid #ccc; border-right: 1px solid #ccc; border-top: 0; border-bottom: 0;
padding: 0 15px 15px 16px; background-color: #fff"> 
<table class="content-excerpt-pattern" cellspacing="0" cellpadding="0" border="0" width="100%"
style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; color: #333;
font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule:
exactly; mso-text-raise: 1px"> 
<tbody> 
<tr> 
<td class="content-excerpt-pattern-container mobile-resize-text " style="padding: 0px;
border-collapse: collapse; padding: 0 0 0 24px"> <p style="margin: 10px 0 0 0; margin-top:
0"> <style type="text/css">/**/
div.rbtoc1462547753570 {padding: 0px;}
div.rbtoc1462547753570 ul {list-style: disc;margin-left: 0px;}
div.rbtoc1462547753570 li {margin-left: 0px;padding-left: 0px;}

/**/</style> </p> 
<div class="toc-macro rbtoc1462547753570" style="padding: 0px; padding: 0px"> 
<ul class="toc-indentation" style="margin: 10px 0 0 0; margin-top: 0; list-style: disc;
margin-left: 0px; list-style: disc; margin-left: 0px"> 
<li style="margin-left: 0px; padding-left: 0px; margin-left: 0px; padding-left: 0px">
<a href="#SolrJDBC-DbVisualizer-Overview" style="color: #3b73af; text-decoration: none">Overview</a>
</li> 
<li style="margin-left: 0px; padding-left: 0px; margin-left: 0px; padding-left: 0px">
<a href="#SolrJDBC-DbVisualizer-SetupDriver" style="color: #3b73af; text-decoration: none">Setup
Driver</a> 
<ul class="toc-indentation" style="margin: 10px 0 0 0; list-style: disc; margin-left: 0px;
list-style: disc; margin-left: 0px"> 
<li style="margin-left: 0px; padding-left: 0px; margin-left: 0px; padding-left: 0px">
<a href="#SolrJDBC-DbVisualizer-OpenDriverManager" style="color: #3b73af; text-decoration:
none">Open Driver Manager</a> </li> 
<li style="margin-left: 0px; padding-left: 0px; margin-left: 0px; padding-left: 0px">
<a href="#SolrJDBC-DbVisualizer-AddDriver" style="color: #3b73af; text-decoration: none">Add
Driver</a> </li> 
<li style="margin-left: 0px; padding-left: 0px; margin-left: 0px; padding-left: 0px">
<a href="#SolrJDBC-DbVisualizer-NametheDriver" style="color: #3b73af; text-decoration:
none">Name the Driver</a> </li> 
<li style="margin-left: 0px; padding-left: 0px; margin-left: 0px; padding-left: 0px">
<a href="#SolrJDBC-DbVisualizer-AddDriverfilestoClasspath" style="color: #3b73af; text-decoration:
none">Add Driver files to Classpath</a> </li> 
<li style="margin-left: 0px; padding-left: 0px; margin-left: 0px; padding-left: 0px">
<a href="#SolrJDBC-DbVisualizer-ReviewandcloseDriverManager" style="color: #3b73af; text-decoration:
none">Review and close Driver Manager</a> </li> 
</ul> </li> 
<li style="margin-left: 0px; padding-left: 0px; margin-left: 0px; padding-left: 0px">
<a href="#SolrJDBC-DbVisualizer-CreateaConnection" style="color: #3b73af; text-decoration:
none">Create a Connection</a> 
<ul class="toc-indentation" style="margin: 10px 0 0 0; list-style: disc; margin-left: 0px;
list-style: disc; margin-left: 0px"> 
<li style="margin-left: 0px; padding-left: 0px; margin-left: 0px; padding-left: 0px">
<a href="#SolrJDBC-DbVisualizer-UsetheWizard" style="color: #3b73af; text-decoration: none">Use
the Wizard</a> </li> 
<li style="margin-left: 0px; padding-left: 0px; margin-left: 0px; padding-left: 0px">
<a href="#SolrJDBC-DbVisualizer-NametheConnection" style="color: #3b73af; text-decoration:
none">Name the Connection</a> </li> 
<li style="margin-left: 0px; padding-left: 0px; margin-left: 0px; padding-left: 0px">
<a href="#SolrJDBC-DbVisualizer-SelectthecreatedSolrdriver" style="color: #3b73af; text-decoration:
none">Select the created Solr driver</a> </li> 
<li style="margin-left: 0px; padding-left: 0px; margin-left: 0px; padding-left: 0px">
<a href="#SolrJDBC-DbVisualizer-SpecifytheSolrURL" style="color: #3b73af; text-decoration:
none">Specify the Solr URL</a> </li> 
</ul> </li> 
<li style="margin-left: 0px; padding-left: 0px; margin-left: 0px; padding-left: 0px">
<a href="#SolrJDBC-DbVisualizer-OpenandConnecttheConnection" style="color: #3b73af; text-decoration:
none">Open and Connect the Connection</a> </li> 
<li style="margin-left: 0px; padding-left: 0px; margin-left: 0px; padding-left: 0px">
<a href="#SolrJDBC-DbVisualizer-OpenSQLCommandertoenterqueries" style="color: #3b73af;
text-decoration: none">Open SQL Commander to enter queries</a> </li> 
</ul> 
</div> <p style="margin: 10px 0 0 0"></p> <h2 id="SolrJDBC-DbVisualizer-Overview"
style="margin: 10px 0 0 0; font-size: 20px; font-weight: normal; line-height: 30px; margin:
40px 0 0 0">Overview</h2> <p style="margin: 10px 0 0 0">For&nbsp;<a
class="external-link" href="https://www.dbvis.com/" rel="nofollow" style="color: #3b73af;
text-decoration: none">DbVisualizer</a>, you will need to create a new driver for
Solr using the DbVisualizer Driver Manager. This will add several SolrJ client .jars to the
DbVisualizer classpath. The files required are:</p> 
<ul style="margin: 10px 0 0 0"> 
<li>all .jars found in&nbsp;<code style="font-family: monospace">$SOLR_HOME/dist/solrj-libs</code>
</li> 
<li>the SolrJ .jar found at&nbsp;<code style="font-family: monospace">$SOLR_HOME/dist/solr-solrj-&lt;version&gt;.jar</code>
</li> 
</ul> <p style="margin: 10px 0 0 0">Once the driver has been created, you can
create a connection to Solr with the connection string format outlined in the generic section
and use the SQL Commander to issue queries.</p> <h2 id="SolrJDBC-DbVisualizer-SetupDriver"
style="margin: 10px 0 0 0; font-size: 20px; font-weight: normal; line-height: 30px; margin:
40px 0 0 0">Setup Driver</h2> <h3 id="SolrJDBC-DbVisualizer-OpenDriverManager"
style="margin: 10px 0 0 0; font-size: 16px; line-height: 25px; margin: 30px 0 0 0; margin-top:
10px">Open Driver Manager</h3> <p style="margin: 10px 0 0 0"> <span class="confluence-embedded-file-wrapper
confluence-embedded-manual-size"><img class="confluence-embedded-image" height="400"
src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_1.png?api=v2"></span>
</p> <h3 id="SolrJDBC-DbVisualizer-AddDriver" style="margin: 10px 0 0 0; font-size:
16px; line-height: 25px; margin: 30px 0 0 0">Add Driver</h3> <p style="margin:
10px 0 0 0"> <span class="confluence-embedded-file-wrapper confluence-embedded-manual-size"><img
class="confluence-embedded-image" height="400" src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_2.png?api=v2"></span>
</p> <h3 id="SolrJDBC-DbVisualizer-NametheDriver" style="margin: 10px 0 0 0; font-size:
16px; line-height: 25px; margin: 30px 0 0 0">Name the Driver</h3> <p style="margin:
10px 0 0 0"> <span class="confluence-embedded-file-wrapper confluence-embedded-manual-size"><img
class="confluence-embedded-image" height="400" src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_3.png?api=v2"></span>
</p> <h3 id="SolrJDBC-DbVisualizer-AddDriverfilestoClasspath" style="margin: 10px
0 0 0; font-size: 16px; line-height: 25px; margin: 30px 0 0 0">Add Driver files to Classpath</h3>
<p style="margin: 10px 0 0 0"> <span class="confluence-embedded-file-wrapper confluence-embedded-manual-size"><img
class="confluence-embedded-image" height="400" src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_4.png?api=v2"></span>
</p> <p style="margin: 10px 0 0 0"> <span class="confluence-embedded-file-wrapper
confluence-embedded-manual-size"><img class="confluence-embedded-image" height="400"
src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_5.png?api=v2"></span>
</p> <p style="margin: 10px 0 0 0"> <span class="confluence-embedded-file-wrapper
confluence-embedded-manual-size"><img class="confluence-embedded-image" height="400"
src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_6.png?api=v2"></span>
</p> <p style="margin: 10px 0 0 0"> <span class="confluence-embedded-file-wrapper
confluence-embedded-manual-size"><img class="confluence-embedded-image" height="400"
src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_7.png?api=v2"></span>
</p> <p style="margin: 10px 0 0 0"> <span class="confluence-embedded-file-wrapper
confluence-embedded-manual-size"><img class="confluence-embedded-image" height="400"
src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_8.png?api=v2"></span>
</p> <p style="margin: 10px 0 0 0"> <span class="confluence-embedded-file-wrapper
confluence-embedded-manual-size"><img class="confluence-embedded-image" height="400"
src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_9.png?api=v2"></span>
</p> <h3 id="SolrJDBC-DbVisualizer-ReviewandcloseDriverManager" style="margin: 10px
0 0 0; font-size: 16px; line-height: 25px; margin: 30px 0 0 0">Review and close Driver
Manager</h3> <p style="margin: 10px 0 0 0"> <span class="confluence-embedded-file-wrapper
confluence-embedded-manual-size"><img class="confluence-embedded-image" height="400"
src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_10.png?api=v2"></span>
</p> <h2 id="SolrJDBC-DbVisualizer-CreateaConnection" style="margin: 10px 0 0 0;
font-size: 20px; font-weight: normal; line-height: 30px; margin: 40px 0 0 0">Create a Connection</h2>
<h3 id="SolrJDBC-DbVisualizer-UsetheWizard" style="margin: 10px 0 0 0; font-size: 16px;
line-height: 25px; margin: 30px 0 0 0; margin-top: 10px">Use the Wizard</h3> <p
style="margin: 10px 0 0 0"> <span class="confluence-embedded-file-wrapper confluence-embedded-manual-size"><img
class="confluence-embedded-image" height="400" src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_11.png?api=v2"></span>
</p> <p style="margin: 10px 0 0 0"> <span class="confluence-embedded-file-wrapper
confluence-embedded-manual-size"><img class="confluence-embedded-image" height="400"
src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_12.png?api=v2"></span>
</p> <h3 id="SolrJDBC-DbVisualizer-NametheConnection" style="margin: 10px 0 0 0;
font-size: 16px; line-height: 25px; margin: 30px 0 0 0">Name the Connection</h3>
<p style="margin: 10px 0 0 0"> <span class="confluence-embedded-file-wrapper confluence-embedded-manual-size"><img
class="confluence-embedded-image" height="400" src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_13.png?api=v2"></span>
</p> <h3 id="SolrJDBC-DbVisualizer-SelectthecreatedSolrdriver" style="margin: 10px
0 0 0; font-size: 16px; line-height: 25px; margin: 30px 0 0 0">Select the created Solr
driver</h3> <p style="margin: 10px 0 0 0"> <span class="confluence-embedded-file-wrapper
confluence-embedded-manual-size"><img class="confluence-embedded-image" height="400"
src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_14.png?api=v2"></span>
</p> <h3 id="SolrJDBC-DbVisualizer-SpecifytheSolrURL" style="margin: 10px 0 0 0;
font-size: 16px; line-height: 25px; margin: 30px 0 0 0">Specify the Solr URL</h3>
<pre style="margin: 10px 0 0 0">Example: jdbc:solr://localhost:9983?collection=collection1</pre>
<p style="margin: 10px 0 0 0"> <span class="confluence-embedded-file-wrapper confluence-embedded-manual-size"><img
class="confluence-embedded-image" height="400" src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_15.png?api=v2"></span>
</p> <h2 id="SolrJDBC-DbVisualizer-OpenandConnecttheConnection" style="margin: 10px
0 0 0; font-size: 20px; font-weight: normal; line-height: 30px; margin: 40px 0 0 0">Open
and Connect the Connection</h2> <p style="margin: 10px 0 0 0"> <span class="confluence-embedded-file-wrapper
confluence-embedded-manual-size"><img class="confluence-embedded-image" height="400"
src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_16.png?api=v2"></span>
</p> <p style="margin: 10px 0 0 0"> <span class="confluence-embedded-file-wrapper
confluence-embedded-manual-size"><img class="confluence-embedded-image" height="400"
src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_17.png?api=v2"></span>
</p> <p style="margin: 10px 0 0 0"> <span class="confluence-embedded-file-wrapper
confluence-embedded-manual-size"><img class="confluence-embedded-image" height="400"
src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_18.png?api=v2"></span>
</p> <h2 id="SolrJDBC-DbVisualizer-OpenSQLCommandertoenterqueries" style="margin:
10px 0 0 0; font-size: 20px; font-weight: normal; line-height: 30px; margin: 40px 0 0 0">Open
SQL Commander to enter queries</h2> <p style="margin: 10px 0 0 0"> <span class="confluence-embedded-file-wrapper
confluence-embedded-manual-size"><img class="confluence-embedded-image" height="400"
src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_19.png?api=v2"></span>
</p> <p style="margin: 10px 0 0 0"> <span class="confluence-embedded-file-wrapper
confluence-embedded-manual-size"><img class="confluence-embedded-image" height="400"
src="https://cwiki.apache.org/confluence/download/attachments/embedded-page/solr/Solr%20JDBC%20-%20DbVisualizer/dbvisualizer_solrjdbc_20.png?api=v2"></span>
</p> <p style="margin: 10px 0 0 0">&nbsp;</p> </td> 
</tr> 
</tbody> 
</table> </td> 
</tr> 
<tr> 
<td class="email-content-main mobile-expand action-padding last-row-padding" style="padding:
0px; border-collapse: collapse; border-left: 1px solid #ccc; border-right: 1px solid #ccc;
border-top: 0; border-bottom: 0; padding: 0 15px 15px 16px; background-color: #fff; padding-bottom:
10px; padding-bottom: 10px"> 
<table id="actions-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse:
collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; color: #333; font-family: Arial, sans-serif;
font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 1px">

<tbody> 
<tr> 
<td id="actions-pattern-container" valign="middle" style="padding: 0px; border-collapse:
collapse; padding: 15px 0 0 24px; vertical-align: middle"> 
<table align="left" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace:
0pt; color: #333"> 
<tbody> 
<tr> 
<td class="actions-pattern-action-icon-container" style="padding: 0px; border-collapse:
collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule:
exactly; mso-text-raise: 0px; vertical-align: middle"><a href="https://cwiki.apache.org/confluence/display/solr/Solr+JDBC+-+DbVisualizer?src=mail&amp;src.mail.timestamp=1462547753579&amp;src.mail.notification=com.atlassian.confluence.plugins.confluence-content-notifications-plugin%3Apage-created-notification&amp;src.mail.recipient=8aa980874e36a1eb014e36a2992a202c&amp;src.mail.action=view"
title="View page Icon" style="color: #3b73af; text-decoration: none"><img class="actions-pattern-action-icon-image"
height="16" width="16" border="0" title="View page Icon" src="cid:com.atlassian.confluence.plugins.confluence-email-resources%3Aview-page-email-adg-footer-item%3Aicon"
alt="View page Icon" style="vertical-align: middle"></a></td>
<td class="actions-pattern-action-text-container" style="padding: 0px; border-collapse:
collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule:
exactly; mso-text-raise: 4px; padding-left: 5px; white-space: nowrap"><a href="https://cwiki.apache.org/confluence/display/solr/Solr+JDBC+-+DbVisualizer?src=mail&amp;src.mail.timestamp=1462547753579&amp;src.mail.notification=com.atlassian.confluence.plugins.confluence-content-notifications-plugin%3Apage-created-notification&amp;src.mail.recipient=8aa980874e36a1eb014e36a2992a202c&amp;src.mail.action=view"
title="View page" style="color: #3b73af; text-decoration: none">View page</a></td>
<td class="actions-pattern-action-bull" style="padding: 0px; border-collapse: collapse;
font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule:
exactly; mso-text-raise: 4px; color: #999; padding: 0 5px">•</td> 
</tr> 
</tbody> 
</table> 
<table align="left" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace:
0pt; color: #333"> 
<tbody> 
<tr> 
<td class="actions-pattern-action-icon-container" style="padding: 0px; border-collapse:
collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule:
exactly; mso-text-raise: 0px; vertical-align: middle"><a href="https://cwiki.apache.org/confluence/display/solr/Solr+JDBC+-+DbVisualizer?showComments=true&amp;showCommentArea=true&amp;src=mail&amp;src.mail.timestamp=1462547753579&amp;src.mail.notification=com.atlassian.confluence.plugins.confluence-content-notifications-plugin%3Apage-created-notification&amp;src.mail.recipient=8aa980874e36a1eb014e36a2992a202c&amp;src.mail.action=comment#addcomment"
title="Add comment Icon" style="color: #3b73af; text-decoration: none"><img class="actions-pattern-action-icon-image"
height="16" width="16" border="0" title="Add comment Icon" src="cid:com.atlassian.confluence.plugins.confluence-email-resources%3Aadd-comment-to-content-email-adg-footer-item%3Aicon"
alt="Add comment Icon" style="vertical-align: middle"></a></td>
<td class="actions-pattern-action-text-container" style="padding: 0px; border-collapse:
collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule:
exactly; mso-text-raise: 4px; padding-left: 5px; white-space: nowrap"><a href="https://cwiki.apache.org/confluence/display/solr/Solr+JDBC+-+DbVisualizer?showComments=true&amp;showCommentArea=true&amp;src=mail&amp;src.mail.timestamp=1462547753579&amp;src.mail.notification=com.atlassian.confluence.plugins.confluence-content-notifications-plugin%3Apage-created-notification&amp;src.mail.recipient=8aa980874e36a1eb014e36a2992a202c&amp;src.mail.action=comment#addcomment"
title="Add comment" style="color: #3b73af; text-decoration: none">Add comment</a></td>
<td class="actions-pattern-action-bull" style="padding: 0px; border-collapse: collapse;
font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule:
exactly; mso-text-raise: 4px; color: #999; padding: 0 5px">•</td> 
</tr> 
</tbody> 
</table> 
<table style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt;
color: #333"> 
<tbody> 
<tr> 
<td class="actions-pattern-action-icon-container" style="padding: 0px; border-collapse:
collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule:
exactly; mso-text-raise: 0px; vertical-align: middle"><a href="https://cwiki.apache.org/confluence/plugins/likes/like.action?contentId=62695745&amp;src=mail&amp;src.mail.timestamp=1462547753579&amp;src.mail.notification=com.atlassian.confluence.plugins.confluence-content-notifications-plugin%3Apage-created-notification&amp;src.mail.recipient=8aa980874e36a1eb014e36a2992a202c&amp;src.mail.action=like"
title="Like Icon" style="color: #3b73af; text-decoration: none"><img class="actions-pattern-action-icon-image"
height="16" width="16" border="0" title="Like Icon" src="cid:com.atlassian.confluence.plugins.confluence-like%3Aview-email-adg-content-item%3Aicon"
alt="Like Icon" style="vertical-align: middle"></a></td>
<td class="actions-pattern-action-text-container" style="padding: 0px; border-collapse:
collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule:
exactly; mso-text-raise: 4px; padding-left: 5px; white-space: nowrap"><a href="https://cwiki.apache.org/confluence/plugins/likes/like.action?contentId=62695745&amp;src=mail&amp;src.mail.timestamp=1462547753579&amp;src.mail.notification=com.atlassian.confluence.plugins.confluence-content-notifications-plugin%3Apage-created-notification&amp;src.mail.recipient=8aa980874e36a1eb014e36a2992a202c&amp;src.mail.action=like"
title="Like" style="color: #3b73af; text-decoration: none">Like</a></td> 
</tr> 
</tbody> 
</table> </td> 
</tr> 
</tbody> 
</table> </td> 
</tr> 
<tr> 
<td class="email-content-rounded-bottom mobile-expand" style="padding: 0px; border-collapse:
collapse; color: #fff; height: 5px; line-height: 5px; padding: 0 15px 0 16px; background-color:
#fff; border-bottom-right-radius: 5px; border-bottom-left-radius: 5px; border-top: 0; border-left:
1px solid #ccc; border-bottom: 1px solid #ccc; border-right: 1px solid #ccc; mso-line-height-rule:
exactly">&nbsp;</td> 
</tr> 
</tbody> 
</table> </td> 
</tr> 
<tr> 
<td id="footer-pattern" style="padding: 0px; border-collapse: collapse; padding: 12px 20px">

<table id="footer-pattern-container" cellspacing="0" cellpadding="0" border="0" width="100%"
style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; color: #333">

<tbody> 
<tr> 
<td id="footer-pattern-links-container" width="100%" style="padding: 0px; border-collapse:
collapse; color: #999; font-size: 12px; line-height: 18px; font-family: Arial, sans-serif;
mso-line-height-rule: exactly; mso-text-raise: 2px"> 
<table align="left" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace:
0pt; color: #333; font-size: 12px; line-height: 18px; font-family: Arial, sans-serif; mso-line-height-rule:
exactly; mso-text-raise: 2px"> 
<tbody> 
<tr> 
<td class="footer-pattern-links mobile-resize-text" style="padding: 0px; border-collapse:
collapse"><a href="https://cwiki.apache.org/confluence/users/removespacenotification.action?spaceKey=solr&amp;src=mail&amp;src.mail.timestamp=1462547753579&amp;src.mail.notification=com.atlassian.confluence.plugins.confluence-content-notifications-plugin%3Apage-created-notification&amp;src.mail.recipient=8aa980874e36a1eb014e36a2992a202c&amp;src.mail.action=stop-watching"
title="" style="color: #3b73af; text-decoration: none">Stop watching space</a></td>
<td class="footer-pattern-links-bull" style="padding: 0px; border-collapse: collapse; padding:
0 5px; color: #999">•</td> 
</tr> 
</tbody> 
</table> 
<table style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt;
color: #333; font-size: 12px; line-height: 18px; font-family: Arial, sans-serif; mso-line-height-rule:
exactly; mso-text-raise: 2px"> 
<tbody> 
<tr> 
<td class="footer-pattern-links mobile-resize-text" style="padding: 0px; border-collapse:
collapse"><a href="https://cwiki.apache.org/confluence/users/editmyemailsettings.action?src=mail&amp;src.mail.timestamp=1462547753579&amp;src.mail.notification=com.atlassian.confluence.plugins.confluence-content-notifications-plugin%3Apage-created-notification&amp;src.mail.recipient=8aa980874e36a1eb014e36a2992a202c&amp;src.mail.action=manage"
title="" style="color: #3b73af; text-decoration: none">Manage notifications</a></td>

</tr> 
</tbody> 
</table> </td>
<td id="footer-pattern-logo-desktop-container" rowspan="2" valign="top" style="padding:
0px; border-collapse: collapse; padding-left: 20px; vertical-align: top"> 
<table style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt;
color: #333"> 
<tbody> 
<tr> 
<td id="footer-pattern-logo-desktop-padding" style="padding: 0px; border-collapse: collapse;
padding-top: 3px"><img id="footer-pattern-logo-desktop" src="cid:footer-desktop-logo"
alt="Confluence logo big" title="Confluence logo big" width="132" height="20" class="image_fix"></td>

</tr> 
</tbody> 
</table> </td> 
</tr> 
<tr> 
<td id="footer-pattern-text" class="mobile-resize-text" width="100%" style="padding: 0px;
border-collapse: collapse; color: #999; font-size: 12px; line-height: 18px; font-family: Arial,
sans-serif; mso-line-height-rule: exactly; mso-text-raise: 2px; display: none">This message
was sent by Atlassian Confluence 5.8.4<br> <img id="footer-pattern-logo-mobile" src="cid:footer-mobile-logo"
alt="" title="" width="0" height="0" style="display: none; mso-hide: all"></td> 
</tr> 
</tbody> 
</table> </td> 
</tr> 
</tbody> 
</table> 
<table id="sealed-section" border="0" cellpadding="0" cellspacing="0" width="0" style="border-collapse:
collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; color: #333; display: none"> 
<tbody> 
<tr> 
<td style="padding: 0px; border-collapse: collapse; border: 0; font-size: 0px; line-height:
0; mso-line-height-rule: exactly"></td> 
</tr> 
</tbody> 
</table>
</body>
</html>
Mime
View raw message