You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@zeppelin.apache.org by Mohit Jaggi <mo...@gmail.com> on 2018/04/02 21:12:10 UTC

mysql jdbc

Hi,
I following instructions here:
https://zeppelin.apache.org/docs/0.7.0/interpreter/jdbc.html#mysql
But I get this when I try "show databases". Do I need to do something to
fetch the driver?

%mysql
show databases
java.lang.ClassNotFoundException: org.mysql.jdbc.Driver
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:338)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at
org.apache.zeppelin.jdbc.JDBCInterpreter.createConnectionPool(JDBCInterpreter.java:341)
at
org.apache.zeppelin.jdbc.JDBCInterpreter.getConnectionFromPool(JDBCInterpreter.java:352)
at
org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCInterpreter.java:372)
at
org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:565)
at
org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:692)
at
org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:97)
at
org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:498)
at org.apache.zeppelin.scheduler.Job.r

Re: mysql jdbc

Posted by Mohit Jaggi <mo...@gmail.com>.

put the jar file where you suggested and changed the config to point to
it...still have the same error.

On Tue, Apr 3, 2018 at 8:52 AM, Mohit Jaggi <mo...@gmail.com> wrote:

> '''The last step is *Dependency Setting*. Since Zeppelin only includes
> PostgreSQL driver jar by default, you need to add each driver's maven
> coordinates or JDBC driver's jar file path for the other databases.'''
>
> I added the maven co-ords as shown in the screenshot not the jar.
>
> On Mon, Apr 2, 2018 at 10:28 PM, Belousov Maksim Eduardovich <
> m.belousov@tinkoff.ru> wrote:
>
>> Hi Mohit!
>>
>>
>>
>> Did you follow to [1] ?
>>
>> JAR need to put in $ZEPPELIN_HOME/interpreter/jdbc
>>
>>
>>
>> 1.       http://zeppelin.apache.org/docs/0.7.3/interpreter/jdbc.html#
>> mysql
>>
>>
>>
>> Regards,
>>
>>
>>
>>
>> *Maksim Belousov *
>>
>>
>>
>> *From:* Mohit Jaggi [mailto:mohitjaggi@gmail.com]
>> *Sent:* Tuesday, April 03, 2018 12:12 AM
>> *To:* users@zeppelin.apache.org
>> *Subject:* mysql jdbc
>>
>>
>>
>> Hi,
>>
>> I following instructions here: https://zeppelin.apache.
>> org/docs/0.7.0/interpreter/jdbc.html#mysql
>>
>> But I get this when I try "show databases". Do I need to do something to
>> fetch the driver?
>>
>>
>>
>> %mysql
>>
>> show databases
>>
>> java.lang.ClassNotFoundException: org.mysql.jdbc.Driver
>>
>> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
>>
>> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>>
>> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:338)
>>
>> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
>>
>> at java.lang.Class.forName0(Native Method)
>>
>> at java.lang.Class.forName(Class.java:264)
>>
>> at org.apache.zeppelin.jdbc.JDBCInterpreter.createConnectionPoo
>> l(JDBCInterpreter.java:341)
>>
>> at org.apache.zeppelin.jdbc.JDBCInterpreter.getConnectionFromPo
>> ol(JDBCInterpreter.java:352)
>>
>> at org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCI
>> nterpreter.java:372)
>>
>> at org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInte
>> rpreter.java:565)
>>
>> at org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInter
>> preter.java:692)
>>
>> at org.apache.zeppelin.interpreter.LazyOpenInterpreter.
>> interpret(LazyOpenInterpreter.java:97)
>>
>> at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServ
>> er$InterpretJob.jobRun(RemoteInterpreterServer.java:498)
>>
>> at org.apache.zeppelin.scheduler.Job.r
>>
>
>

Re: mysql jdbc

Posted by Mohit Jaggi <mo...@gmail.com>.

'''The last step is *Dependency Setting*. Since Zeppelin only includes
PostgreSQL driver jar by default, you need to add each driver's maven
coordinates or JDBC driver's jar file path for the other databases.'''

I added the maven co-ords as shown in the screenshot not the jar.

On Mon, Apr 2, 2018 at 10:28 PM, Belousov Maksim Eduardovich <
m.belousov@tinkoff.ru> wrote:

> Hi Mohit!
>
>
>
> Did you follow to [1] ?
>
> JAR need to put in $ZEPPELIN_HOME/interpreter/jdbc
>
>
>
> 1.       http://zeppelin.apache.org/docs/0.7.3/interpreter/jdbc.html#mysql
>
>
>
> Regards,
>
>
>
>
> *Maksim Belousov *
>
>
>
> *From:* Mohit Jaggi [mailto:mohitjaggi@gmail.com]
> *Sent:* Tuesday, April 03, 2018 12:12 AM
> *To:* users@zeppelin.apache.org
> *Subject:* mysql jdbc
>
>
>
> Hi,
>
> I following instructions here: https://zeppelin.apache.
> org/docs/0.7.0/interpreter/jdbc.html#mysql
>
> But I get this when I try "show databases". Do I need to do something to
> fetch the driver?
>
>
>
> %mysql
>
> show databases
>
> java.lang.ClassNotFoundException: org.mysql.jdbc.Driver
>
> at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
>
> at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
>
> at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:338)
>
> at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
>
> at java.lang.Class.forName0(Native Method)
>
> at java.lang.Class.forName(Class.java:264)
>
> at org.apache.zeppelin.jdbc.JDBCInterpreter.createConnectionPool(
> JDBCInterpreter.java:341)
>
> at org.apache.zeppelin.jdbc.JDBCInterpreter.getConnectionFromPool(
> JDBCInterpreter.java:352)
>
> at org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(
> JDBCInterpreter.java:372)
>
> at org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(
> JDBCInterpreter.java:565)
>
> at org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(
> JDBCInterpreter.java:692)
>
> at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(
> LazyOpenInterpreter.java:97)
>
> at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$
> InterpretJob.jobRun(RemoteInterpreterServer.java:498)
>
> at org.apache.zeppelin.scheduler.Job.r
>

RE: mysql jdbc

Posted by Belousov Maksim Eduardovich <m....@tinkoff.ru>.

Hi Mohit!

Did you follow to [1] ?
JAR need to put in $ZEPPELIN_HOME/interpreter/jdbc


1.       http://zeppelin.apache.org/docs/0.7.3/interpreter/jdbc.html#mysql

Regards,

Maksim Belousov


From: Mohit Jaggi [mailto:mohitjaggi@gmail.com]
Sent: Tuesday, April 03, 2018 12:12 AM
To: users@zeppelin.apache.org
Subject: mysql jdbc

Hi,
I following instructions here: https://zeppelin.apache.org/docs/0.7.0/interpreter/jdbc.html#mysql
But I get this when I try "show databases". Do I need to do something to fetch the driver?

%mysql
show databases
java.lang.ClassNotFoundException: org.mysql.jdbc.Driver
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:338)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:264)
at org.apache.zeppelin.jdbc.JDBCInterpreter.createConnectionPool(JDBCInterpreter.java:341)
at org.apache.zeppelin.jdbc.JDBCInterpreter.getConnectionFromPool(JDBCInterpreter.java:352)
at org.apache.zeppelin.jdbc.JDBCInterpreter.getConnection(JDBCInterpreter.java:372)
at org.apache.zeppelin.jdbc.JDBCInterpreter.executeSql(JDBCInterpreter.java:565)
at org.apache.zeppelin.jdbc.JDBCInterpreter.interpret(JDBCInterpreter.java:692)
at org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:97)
at org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:498)
at org.apache.zeppelin.scheduler.Job.r