Dears,
I got this error while trying to establish a new connection to phoenix using eclipse. knowing that I can run the phoenix shell with the same configuration without any errors.

here is the code:

import java.sql.*;
public class ConnConf {
private static String conString="jdbc:phoenix:localhost:2181";
    public static void main(String[] args) {

        try {
            Connection conn = DriverManager.getConnection(conString);
            System.out.println("connetion to "+conString+" is Successful");
            } catch (SQLException e) {
            System.out.println("connetion to "+conString+" failed");
            e.printStackTrace();

        }}


here is the error:



2014-08-10 14:36:46,323 INFO [main] Configuration.deprecation (Configuration.java:warnOnceIfDeprecated(840)) - topology.node.switch.mapping.impl is deprecated. Instead, use net.topology.node.switch.mapping.impl 2014-08-10 14:36:46,326 INFO [main] Configuration.deprecation (Configuration.java:warnOnceIfDeprecated(840)) - topology.script.number.args is deprecated. Instead, use net.topology.script.number.args 2014-08-10 14:36:46,328 INFO [main] Configuration.deprecation (Configuration.java:warnOnceIfDeprecated(840)) - dfs.umaskmode is deprecated. Instead, use fs.permissions.umask-mode 2014-08-10 14:36:46,328 INFO [main] Configuration.deprecation (Configuration.java:warnOnceIfDeprecated(840)) - hadoop.native.lib is deprecated. Instead, use io.native.lib.available 2014-08-10 14:36:46,328 INFO [main] Configuration.deprecation (Configuration.java:warnOnceIfDeprecated(840)) - dfs.df.interval is deprecated. Instead, use fs.df.interval 2014-08-10 14:36:46,329 INFO [main] Configuration.deprecation (Configuration.java:warnOnceIfDeprecated(840)) - fs.default.name is deprecated. Instead, use fs.defaultFS 2014-08-10 14:36:46,684 WARN [main] util.NativeCodeLoader (NativeCodeLoader.java:<clinit>(62)) - Unable to load native-hadoop library for your platform... using builtin-java classes where applicable 2014-08-10 14:36:46,772 INFO [main] zookeeper.ZooKeeper (Environment.java:logEnv(100)) - Client environment:zookeeper.version=3.4.6-1569965, built on 02/20/2014 09:09 GMT

2014-08-10 14:36:46,772 INFO [main] zookeeper.ZooKeeper (Environment.java:logEnv(100)) - Client environment:java.version=1.8.0_05 2014-08-10 14:36:46,773 INFO [main] zookeeper.ZooKeeper (Environment.java:logEnv(100)) - Client environment:java.vendor=Oracle Corporation 2014-08-10 14:36:46,773 INFO [main] zookeeper.ZooKeeper (Environment.java:logEnv(100)) - Client environment:java.home=/usr/local/java/jdk1.8.0_05/jre

2014-08-10 14:36:46,774 INFO [main] zookeeper.ZooKeeper (Environment.java:logEnv(100)) - Client environment:java.io.tmpdir=/tmp 2014-08-10 14:36:46,774 INFO [main] zookeeper.ZooKeeper (Environment.java:logEnv(100)) - Client environment:java.compiler=<NA> 2014-08-10 14:36:46,775 INFO [main] zookeeper.ZooKeeper (Environment.java:logEnv(100)) - Client environment:os.name=Linux 2014-08-10 14:36:46,776 INFO [main] zookeeper.ZooKeeper (Environment.java:logEnv(100)) - Client environment:os.arch=amd64 2014-08-10 14:36:46,776 INFO [main] zookeeper.ZooKeeper (Environment.java:logEnv(100)) - Client environment:os.version=3.13.0-32-generic 2014-08-10 14:36:46,776 INFO [main] zookeeper.ZooKeeper (Environment.java:logEnv(100)) - Client environment:user.name=hduser 2014-08-10 14:36:46,776 INFO [main] zookeeper.ZooKeeper (Environment.java:logEnv(100)) - Client environment:user.home=/home/hduser 2014-08-10 14:36:46,776 INFO [main] zookeeper.ZooKeeper (Environment.java:logEnv(100)) - Client environment:user.dir=/home/hduser/workspace/uaph 2014-08-10 14:36:46,777 INFO [main] zookeeper.ZooKeeper (ZooKeeper.java:<init>(438)) - Initiating client connection, connectString=localhost:2181 sessionTimeout=90000 watcher=hconnection-0x27c6e487, quorum=localhost:2181, baseZNode=/hbase 2014-08-10 14:36:46,792 INFO [main-SendThread(localhost:2181)] zookeeper.ClientCnxn (ClientCnxn.java:logStartConnect(975)) - Opening socket connection to server localhost/127.0.0.1:2181. Will not attempt to authenticate using SASL (unknown error) 2014-08-10 14:36:46,800 INFO [main-SendThread(localhost:2181)] zookeeper.ClientCnxn (ClientCnxn.java:primeConnection(852)) - Socket connection established to localhost/127.0.0.1:2181, initiating session 2014-08-10 14:36:46,804 INFO [main] zookeeper.RecoverableZooKeeper (RecoverableZooKeeper.java:<init>(120)) - Process identifier=hconnection-0x27c6e487 connecting to ZooKeeper ensemble=localhost:2181 2014-08-10 14:36:46,847 INFO [main-SendThread(localhost:2181)] zookeeper.ClientCnxn (ClientCnxn.java:onConnected(1235)) - Session establishment complete on server localhost/127.0.0.1:2181, sessionid = 0x147bfa4fde80007, negotiated timeout = 90000 2014-08-10 14:36:47,003 INFO [main] client.HConnectionManager$HConnectionImplementation (HConnectionManager.java:closeZooKeeperWatcher(1857)) - Closing zookeeper sessionid=0x147bfa4fde80007 2014-08-10 14:36:47,010 INFO [main] zookeeper.ZooKeeper (ZooKeeper.java:close(684)) - Session: 0x147bfa4fde80007 closed 2014-08-10 14:36:47,010 INFO [main-EventThread] zookeeper.ClientCnxn (ClientCnxn.java:run(512)) - EventThread shut down Exception in thread "main" java.lang.NoClassDefFoundError: org/antlr/runtime/RecognitionException at org.apache.phoenix.jdbc.PhoenixStatement.parseStatement(PhoenixStatement.java:852) at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:900) at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1452) at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:131) at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:112)
    at java.sql.DriverManager.getConnection(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:270)
    at adminOperations.ConnConf.main(ConnConf.java:9)
Caused by: java.lang.ClassNotFoundException: org.antlr.runtime.RecognitionException
    at java.net.URLClassLoader$1.run(URLClassLoader.java:372)
    at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:360)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
    at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
    ... 8 more

Reply via email to