'''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.belou...@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:mohitja...@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 >
