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 <mohitja...@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.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.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 >> > >
