Appreciate for the article http://habrahabr.ru/company/jetinfosystems/blog/269769/
Thanks, moon On Mon, Oct 19, 2015 at 9:32 PM Alexander Kardapolov <akardapo...@gmail.com> wrote: > Hi! > > Is it possible to read data from Oracle database directly on Zeppelin > using psql interpretator? > > I tried the following steps: > > 1. Download the ojdbc14.jar file and copy it to > /usr/zeppelin/interpreter/psql directory > > 2. Set the following psql parameters: > > postgresql.driver.nameoracle.jdbc.pool.OracleDataSource > postgresql.max.result1000postgresql.passwordpassword_herepostgresql.url > jdbc:oracle:thin://hostname_here:1521/postgresql.usersystem > 3. And I try to get data from system table (dual): > %psql.sql > select 1 from dual; > > java.lang.NullPointerException at > org.apache.zeppelin.postgresql.PostgreSqlInterpreter.executeSql(PostgreSqlInterpreter.java:201) > at > org.apache.zeppelin.postgresql.PostgreSqlInterpreter.interpret(PostgreSqlInterpreter.java:288) > at > org.apache.zeppelin.interpreter.ClassloaderInterpreter.interpret(ClassloaderInterpreter.java:57) > at > org.apache.zeppelin.interpreter.LazyOpenInterpreter.interpret(LazyOpenInterpreter.java:93) > at > org.apache.zeppelin.interpreter.remote.RemoteInterpreterServer$InterpretJob.jobRun(RemoteInterpreterServer.java:276) > at org.apache.zeppelin.scheduler.Job.run(Job.java:170) at > org.apache.zeppelin.scheduler.FIFOScheduler$1.run(FIFOScheduler.java:118) > at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > at java.util.concurrent.FutureTask.run(FutureTask.java:262) at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:178) > at > java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292) > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > at java.lang.Thread.run(Thread.java:745) > > Is it possible to do it for existing psql interpreter or I have to to > develop the new one, for Oracle Database? > > -- > Thanks, > Alex. >