You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Reth RM <re...@gmail.com> on 2016/04/15 16:15:47 UTC
Question on Solr JDBC driver with SQL client like DB Visualizer
Note: I followed the steps mentioned in the pdf attached on this Jira
https://issues.apache.org/jira/browse/SOLR-8521
Page 11, the screenshot specifies to select a
"solr-solrj-6.0.0-SNAPSHOT.jar" which is equivalent into
"solr-solrj-6.0.0.jar" shipped with released version, correct?
When I try adding that jar, it doesn't show up driver class, DBVisualizer
still shows "No new driver class". Does it mean the class is not added to
this jar yet?
Re: Question on Solr JDBC driver with SQL client like DB Visualizer
Posted by Joel Bernstein <jo...@gmail.com>.
Can you post the output from the command below. Notice the diver classes in
the trunk snapshot on my desktop.
jar -tvf solr-solrj-7.0.0-SNAPSHOT.jar | grep sql
0 Sun Apr 03 20:20:28 EDT 2016 org/apache/solr/client/solrj/io/sql/
842 Sun Apr 03 20:20:28 EDT 2016 META-INF/services/java.sql.Driver
10124 Sun Apr 03 20:20:28 EDT 2016
org/apache/solr/client/solrj/io/sql/ConnectionImpl.class
23557 Sun Apr 03 20:20:28 EDT 2016
org/apache/solr/client/solrj/io/sql/DatabaseMetaDataImpl.class
4459 Sun Apr 03 20:20:28 EDT 2016
org/apache/solr/client/solrj/io/sql/DriverImpl.class
28333 Sun Apr 03 20:20:28 EDT 2016
org/apache/solr/client/solrj/io/sql/ResultSetImpl.class
5167 Sun Apr 03 20:20:28 EDT 2016
org/apache/solr/client/solrj/io/sql/ResultSetMetaDataImpl.class
10451 Sun Apr 03 20:20:28 EDT 2016
org/apache/solr/client/solrj/io/sql/StatementImpl.class
141 Sun Apr 03 20:20:28 EDT 2016
org/apache/solr/client/solrj/io/sql/package-info.class
Joel Bernstein
http://joelsolr.blogspot.com/
On Fri, Apr 15, 2016 at 10:15 AM, Reth RM <re...@gmail.com> wrote:
> Note: I followed the steps mentioned in the pdf attached on this Jira
> https://issues.apache.org/jira/browse/SOLR-8521
>
> Page 11, the screenshot specifies to select a
> "solr-solrj-6.0.0-SNAPSHOT.jar" which is equivalent into
> "solr-solrj-6.0.0.jar" shipped with released version, correct?
>
> When I try adding that jar, it doesn't show up driver class, DBVisualizer
> still shows "No new driver class". Does it mean the class is not added to
> this jar yet?
>
Re: Question on Solr JDBC driver with SQL client like DB Visualizer
Posted by Joel Bernstein <jo...@gmail.com>.
Ok, I think I know the problem you're running into. You'll need to load the
solr-solrj jar after loading the jars in the solrj-lib. Otherwise DbVis
seems to get confused and lose the driver class. We'll work on putting out
a single jar for the JDBC driver.
Joel Bernstein
http://joelsolr.blogspot.com/
On Fri, Apr 15, 2016 at 4:23 PM, Joel Bernstein <jo...@gmail.com> wrote:
> I just added the driver again to DBVisualizer and it found it for me. You
> can see the attached screen shot.
>
> Joel Bernstein
> http://joelsolr.blogspot.com/
>
> On Fri, Apr 15, 2016 at 3:13 PM, Joel Bernstein <jo...@gmail.com>
> wrote:
>
>> What version of DbVisualizer are you using?
>>
>> When I tested I was using the latest version.
>>
>> Joel Bernstein
>> http://joelsolr.blogspot.com/
>>
>> On Fri, Apr 15, 2016 at 12:47 PM, Reth RM <re...@gmail.com> wrote:
>>
>>> output of command :
>>>
>>> org/apache/solr/client/solrj/io/sql/
>>> META-INF/services/java.sql.Driver
>>> org/apache/solr/client/solrj/io/sql/ConnectionImpl.class
>>> org/apache/solr/client/solrj/io/sql/DatabaseMetaDataImpl.class
>>> org/apache/solr/client/solrj/io/sql/DriverImpl.class
>>> org/apache/solr/client/solrj/io/sql/ResultSetImpl.class
>>> org/apache/solr/client/solrj/io/sql/ResultSetMetaDataImpl.class
>>> org/apache/solr/client/solrj/io/sql/StatementImpl.class
>>> org/apache/solr/client/solrj/io/sql/package-info.class
>>>
>>>
>>>
>>> On Fri, Apr 15, 2016 at 9:01 PM, Kevin Risden <risdenk@avalonconsult.com
>>> >
>>> wrote:
>>>
>>> > >
>>> > > Page 11, the screenshot specifies to select a
>>> > > "solr-solrj-6.0.0-SNAPSHOT.jar" which is equivalent into
>>> > > "solr-solrj-6.0.0.jar" shipped with released version, correct?
>>> > >
>>> >
>>> > Correct the PDF was generated before 6.0.0 was released. The
>>> documentation
>>> > from SOLR-8521 is being migrated to here:
>>> >
>>> >
>>> >
>>> https://cwiki.apache.org/confluence/display/solr/Parallel+SQL+Interface#ParallelSQLInterface-SQLClientsandDatabaseVisualizationTools
>>> >
>>> >
>>> > > When I try adding that jar, it doesn't show up driver class,
>>> DBVisualizer
>>> > > still shows "No new driver class". Does it mean the class is not
>>> added to
>>> > > this jar yet?
>>> > >
>>> >
>>> > I checked the Solr 6.0.0 release and the driver is there. I was
>>> testing it
>>> > yesterday for a blog series that I'm putting together.
>>> >
>>> > Just for reference here is the output for the Solr 6 release:
>>> >
>>> > tar -tvf solr-solrj-6.0.0.jar | grep sql
>>> > drwxrwxrwx 0 0 0 0 Apr 1 14:40
>>> > org/apache/solr/client/solrj/io/sql/
>>> > -rwxrwxrwx 0 0 0 842 Apr 1 14:40
>>> > META-INF/services/java.sql.Driver
>>> > -rwxrwxrwx 0 0 0 10124 Apr 1 14:40
>>> > org/apache/solr/client/solrj/io/sql/ConnectionImpl.class
>>> > -rwxrwxrwx 0 0 0 23557 Apr 1 14:40
>>> > org/apache/solr/client/solrj/io/sql/DatabaseMetaDataImpl.class
>>> > -rwxrwxrwx 0 0 0 4459 Apr 1 14:40
>>> > org/apache/solr/client/solrj/io/sql/DriverImpl.class
>>> > -rwxrwxrwx 0 0 0 28333 Apr 1 14:40
>>> > org/apache/solr/client/solrj/io/sql/ResultSetImpl.class
>>> > -rwxrwxrwx 0 0 0 5167 Apr 1 14:40
>>> > org/apache/solr/client/solrj/io/sql/ResultSetMetaDataImpl.class
>>> > -rwxrwxrwx 0 0 0 10451 Apr 1 14:40
>>> > org/apache/solr/client/solrj/io/sql/StatementImpl.class
>>> > -rwxrwxrwx 0 0 0 141 Apr 1 14:40
>>> > org/apache/solr/client/solrj/io/sql/package-info.class
>>> >
>>> >
>>> > Kevin Risden
>>> > Apache Lucene/Solr Committer
>>> > Hadoop and Search Tech Lead | Avalon Consulting, LLC
>>> > <http://www.avalonconsult.com/>
>>> > M: 732 213 8417
>>> > LinkedIn <http://www.linkedin.com/company/avalon-consulting-llc> |
>>> Google+
>>> > <http://www.google.com/+AvalonConsultingLLC> | Twitter
>>> > <https://twitter.com/avalonconsult>
>>> >
>>> >
>>> >
>>> -------------------------------------------------------------------------------------------------------------
>>> > This message (including any attachments) contains confidential
>>> information
>>> > intended for a specific individual and purpose, and is protected by
>>> law. If
>>> > you are not the intended recipient, you should delete this message. Any
>>> > disclosure, copying, or distribution of this message, or the taking of
>>> any
>>> > action based on it, is strictly prohibited.
>>> >
>>>
>>
>>
>
Re: Question on Solr JDBC driver with SQL client like DB Visualizer
Posted by Joel Bernstein <jo...@gmail.com>.
What version of DbVisualizer are you using?
When I tested I was using the latest version.
Joel Bernstein
http://joelsolr.blogspot.com/
On Fri, Apr 15, 2016 at 12:47 PM, Reth RM <re...@gmail.com> wrote:
> output of command :
>
> org/apache/solr/client/solrj/io/sql/
> META-INF/services/java.sql.Driver
> org/apache/solr/client/solrj/io/sql/ConnectionImpl.class
> org/apache/solr/client/solrj/io/sql/DatabaseMetaDataImpl.class
> org/apache/solr/client/solrj/io/sql/DriverImpl.class
> org/apache/solr/client/solrj/io/sql/ResultSetImpl.class
> org/apache/solr/client/solrj/io/sql/ResultSetMetaDataImpl.class
> org/apache/solr/client/solrj/io/sql/StatementImpl.class
> org/apache/solr/client/solrj/io/sql/package-info.class
>
>
>
> On Fri, Apr 15, 2016 at 9:01 PM, Kevin Risden <ri...@avalonconsult.com>
> wrote:
>
> > >
> > > Page 11, the screenshot specifies to select a
> > > "solr-solrj-6.0.0-SNAPSHOT.jar" which is equivalent into
> > > "solr-solrj-6.0.0.jar" shipped with released version, correct?
> > >
> >
> > Correct the PDF was generated before 6.0.0 was released. The
> documentation
> > from SOLR-8521 is being migrated to here:
> >
> >
> >
> https://cwiki.apache.org/confluence/display/solr/Parallel+SQL+Interface#ParallelSQLInterface-SQLClientsandDatabaseVisualizationTools
> >
> >
> > > When I try adding that jar, it doesn't show up driver class,
> DBVisualizer
> > > still shows "No new driver class". Does it mean the class is not added
> to
> > > this jar yet?
> > >
> >
> > I checked the Solr 6.0.0 release and the driver is there. I was testing
> it
> > yesterday for a blog series that I'm putting together.
> >
> > Just for reference here is the output for the Solr 6 release:
> >
> > tar -tvf solr-solrj-6.0.0.jar | grep sql
> > drwxrwxrwx 0 0 0 0 Apr 1 14:40
> > org/apache/solr/client/solrj/io/sql/
> > -rwxrwxrwx 0 0 0 842 Apr 1 14:40
> > META-INF/services/java.sql.Driver
> > -rwxrwxrwx 0 0 0 10124 Apr 1 14:40
> > org/apache/solr/client/solrj/io/sql/ConnectionImpl.class
> > -rwxrwxrwx 0 0 0 23557 Apr 1 14:40
> > org/apache/solr/client/solrj/io/sql/DatabaseMetaDataImpl.class
> > -rwxrwxrwx 0 0 0 4459 Apr 1 14:40
> > org/apache/solr/client/solrj/io/sql/DriverImpl.class
> > -rwxrwxrwx 0 0 0 28333 Apr 1 14:40
> > org/apache/solr/client/solrj/io/sql/ResultSetImpl.class
> > -rwxrwxrwx 0 0 0 5167 Apr 1 14:40
> > org/apache/solr/client/solrj/io/sql/ResultSetMetaDataImpl.class
> > -rwxrwxrwx 0 0 0 10451 Apr 1 14:40
> > org/apache/solr/client/solrj/io/sql/StatementImpl.class
> > -rwxrwxrwx 0 0 0 141 Apr 1 14:40
> > org/apache/solr/client/solrj/io/sql/package-info.class
> >
> >
> > Kevin Risden
> > Apache Lucene/Solr Committer
> > Hadoop and Search Tech Lead | Avalon Consulting, LLC
> > <http://www.avalonconsult.com/>
> > M: 732 213 8417
> > LinkedIn <http://www.linkedin.com/company/avalon-consulting-llc> |
> Google+
> > <http://www.google.com/+AvalonConsultingLLC> | Twitter
> > <https://twitter.com/avalonconsult>
> >
> >
> >
> -------------------------------------------------------------------------------------------------------------
> > This message (including any attachments) contains confidential
> information
> > intended for a specific individual and purpose, and is protected by law.
> If
> > you are not the intended recipient, you should delete this message. Any
> > disclosure, copying, or distribution of this message, or the taking of
> any
> > action based on it, is strictly prohibited.
> >
>
Re: Question on Solr JDBC driver with SQL client like DB Visualizer
Posted by Reth RM <re...@gmail.com>.
output of command :
org/apache/solr/client/solrj/io/sql/
META-INF/services/java.sql.Driver
org/apache/solr/client/solrj/io/sql/ConnectionImpl.class
org/apache/solr/client/solrj/io/sql/DatabaseMetaDataImpl.class
org/apache/solr/client/solrj/io/sql/DriverImpl.class
org/apache/solr/client/solrj/io/sql/ResultSetImpl.class
org/apache/solr/client/solrj/io/sql/ResultSetMetaDataImpl.class
org/apache/solr/client/solrj/io/sql/StatementImpl.class
org/apache/solr/client/solrj/io/sql/package-info.class
On Fri, Apr 15, 2016 at 9:01 PM, Kevin Risden <ri...@avalonconsult.com>
wrote:
> >
> > Page 11, the screenshot specifies to select a
> > "solr-solrj-6.0.0-SNAPSHOT.jar" which is equivalent into
> > "solr-solrj-6.0.0.jar" shipped with released version, correct?
> >
>
> Correct the PDF was generated before 6.0.0 was released. The documentation
> from SOLR-8521 is being migrated to here:
>
>
> https://cwiki.apache.org/confluence/display/solr/Parallel+SQL+Interface#ParallelSQLInterface-SQLClientsandDatabaseVisualizationTools
>
>
> > When I try adding that jar, it doesn't show up driver class, DBVisualizer
> > still shows "No new driver class". Does it mean the class is not added to
> > this jar yet?
> >
>
> I checked the Solr 6.0.0 release and the driver is there. I was testing it
> yesterday for a blog series that I'm putting together.
>
> Just for reference here is the output for the Solr 6 release:
>
> tar -tvf solr-solrj-6.0.0.jar | grep sql
> drwxrwxrwx 0 0 0 0 Apr 1 14:40
> org/apache/solr/client/solrj/io/sql/
> -rwxrwxrwx 0 0 0 842 Apr 1 14:40
> META-INF/services/java.sql.Driver
> -rwxrwxrwx 0 0 0 10124 Apr 1 14:40
> org/apache/solr/client/solrj/io/sql/ConnectionImpl.class
> -rwxrwxrwx 0 0 0 23557 Apr 1 14:40
> org/apache/solr/client/solrj/io/sql/DatabaseMetaDataImpl.class
> -rwxrwxrwx 0 0 0 4459 Apr 1 14:40
> org/apache/solr/client/solrj/io/sql/DriverImpl.class
> -rwxrwxrwx 0 0 0 28333 Apr 1 14:40
> org/apache/solr/client/solrj/io/sql/ResultSetImpl.class
> -rwxrwxrwx 0 0 0 5167 Apr 1 14:40
> org/apache/solr/client/solrj/io/sql/ResultSetMetaDataImpl.class
> -rwxrwxrwx 0 0 0 10451 Apr 1 14:40
> org/apache/solr/client/solrj/io/sql/StatementImpl.class
> -rwxrwxrwx 0 0 0 141 Apr 1 14:40
> org/apache/solr/client/solrj/io/sql/package-info.class
>
>
> Kevin Risden
> Apache Lucene/Solr Committer
> Hadoop and Search Tech Lead | Avalon Consulting, LLC
> <http://www.avalonconsult.com/>
> M: 732 213 8417
> LinkedIn <http://www.linkedin.com/company/avalon-consulting-llc> | Google+
> <http://www.google.com/+AvalonConsultingLLC> | Twitter
> <https://twitter.com/avalonconsult>
>
>
> -------------------------------------------------------------------------------------------------------------
> This message (including any attachments) contains confidential information
> intended for a specific individual and purpose, and is protected by law. If
> you are not the intended recipient, you should delete this message. Any
> disclosure, copying, or distribution of this message, or the taking of any
> action based on it, is strictly prohibited.
>
Re: Question on Solr JDBC driver with SQL client like DB Visualizer
Posted by Kevin Risden <ri...@avalonconsult.com>.
>
> Page 11, the screenshot specifies to select a
> "solr-solrj-6.0.0-SNAPSHOT.jar" which is equivalent into
> "solr-solrj-6.0.0.jar" shipped with released version, correct?
>
Correct the PDF was generated before 6.0.0 was released. The documentation
from SOLR-8521 is being migrated to here:
https://cwiki.apache.org/confluence/display/solr/Parallel+SQL+Interface#ParallelSQLInterface-SQLClientsandDatabaseVisualizationTools
> When I try adding that jar, it doesn't show up driver class, DBVisualizer
> still shows "No new driver class". Does it mean the class is not added to
> this jar yet?
>
I checked the Solr 6.0.0 release and the driver is there. I was testing it
yesterday for a blog series that I'm putting together.
Just for reference here is the output for the Solr 6 release:
tar -tvf solr-solrj-6.0.0.jar | grep sql
drwxrwxrwx 0 0 0 0 Apr 1 14:40
org/apache/solr/client/solrj/io/sql/
-rwxrwxrwx 0 0 0 842 Apr 1 14:40
META-INF/services/java.sql.Driver
-rwxrwxrwx 0 0 0 10124 Apr 1 14:40
org/apache/solr/client/solrj/io/sql/ConnectionImpl.class
-rwxrwxrwx 0 0 0 23557 Apr 1 14:40
org/apache/solr/client/solrj/io/sql/DatabaseMetaDataImpl.class
-rwxrwxrwx 0 0 0 4459 Apr 1 14:40
org/apache/solr/client/solrj/io/sql/DriverImpl.class
-rwxrwxrwx 0 0 0 28333 Apr 1 14:40
org/apache/solr/client/solrj/io/sql/ResultSetImpl.class
-rwxrwxrwx 0 0 0 5167 Apr 1 14:40
org/apache/solr/client/solrj/io/sql/ResultSetMetaDataImpl.class
-rwxrwxrwx 0 0 0 10451 Apr 1 14:40
org/apache/solr/client/solrj/io/sql/StatementImpl.class
-rwxrwxrwx 0 0 0 141 Apr 1 14:40
org/apache/solr/client/solrj/io/sql/package-info.class
Kevin Risden
Apache Lucene/Solr Committer
Hadoop and Search Tech Lead | Avalon Consulting, LLC
<http://www.avalonconsult.com/>
M: 732 213 8417
LinkedIn <http://www.linkedin.com/company/avalon-consulting-llc> | Google+
<http://www.google.com/+AvalonConsultingLLC> | Twitter
<https://twitter.com/avalonconsult>
-------------------------------------------------------------------------------------------------------------
This message (including any attachments) contains confidential information
intended for a specific individual and purpose, and is protected by law. If
you are not the intended recipient, you should delete this message. Any
disclosure, copying, or distribution of this message, or the taking of any
action based on it, is strictly prohibited.