You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Peter Vary (JIRA)" <ji...@apache.org> on 2017/06/02 12:06:04 UTC

[jira] [Created] (HIVE-16814) When registering a new local driver the connection will fail

Peter Vary created HIVE-16814:
---------------------------------

             Summary: When registering a new local driver the connection will fail
                 Key: HIVE-16814
                 URL: https://issues.apache.org/jira/browse/HIVE-16814
             Project: Hive
          Issue Type: Bug
          Components: Beeline
    Affects Versions: 2.0.0, 1.2.0, 3.0.0
            Reporter: Peter Vary
            Assignee: Peter Vary


Register a new local driver:
{code}
!addlocaldriverjar /path/to/mysql.jar
{code}

Try to connect with the Driver in the jar providing the Driver class in the connect command:
{code}
!connect jdbc:mysql://localhost:3306/testdb hive secret com.mysql.jdbc.Driver
{code}

I get the following error:
{code}
Connecting to jdbc:mysql://localhost:3306/testdb
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
	at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
	at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:195)
	at org.apache.hive.beeline.DatabaseConnection.connect(DatabaseConnection.java:112)
	at org.apache.hive.beeline.DatabaseConnection.getConnection(DatabaseConnection.java:211)
	at org.apache.hive.beeline.Commands.connect(Commands.java:1522)
	at org.apache.hive.beeline.Commands.connect(Commands.java:1417)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:606)
	at org.apache.hive.beeline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:52)
	at org.apache.hive.beeline.BeeLine.execCommandWithPrefix(BeeLine.java:1135)
	at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:1174)
	at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:1010)
	at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:922)
	at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:518)
	at org.apache.hive.beeline.BeeLine.main(BeeLine.java:501)
{code}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)