Hi Ahmed, Make sure you have everything you need on the classpath. Easiest would be to include the Phoenix client jar. Thanks, James
On Sunday, August 10, 2014, Ahmed Hussien <[email protected]> wrote: > 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 > >
