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