Zetaris JDBC Driver install

Options
MikeBran
MikeBran Partner, Registered Posts: 3 Partner

Hi Guys, Running Zetaris on ubuntu and trying to install the Zetaris JDBC driver for my team. I have placed he jar fin the dss_home/lib/jdbc folder as directed, restarted Dataiku and we get a Failed to load database driver: Failed to load JDBC driver error when we attempt to test the connection. I have tried permissions on the file, placing it the file almost everywhere and it still doesn't work. Any assistance appreciated.


Operating system used: Ubuntu

Answers

  • Sergey
    Sergey Dataiker, Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS Core Concepts Posts: 366 Dataiker
    Options

    Hi @MikeBran

    Yes, usually, you just need to load the driver into DATA_DIR/lib/jdbc directory and restart DSS.

    Can you please provide a listing of the DATA_DIR/lib/jdbc directory?

  • MikeBran
    MikeBran Partner, Registered Posts: 3 Partner
    Options
  • MikeBran
    MikeBran Partner, Registered Posts: 3 Partner
    Options

    From backend.log

    [2022/05/03-11:21:45.703] [qtp1278616846-4015] [ERROR] [dku.datasets.sql]  - Driver errorcom.dataiku.dip.exceptions.CodedSQLException: Failed to load JDBC driver (zetaris.jar)	at com.dataiku.dip.connections.SQLDriverLoader.loadDriver(SQLDriverLoader.java:44)	at com.dataiku.dip.server.services.ConnectionsTestService.testSQL_NOTRANSACTION(ConnectionsTestService.java:336)	at com.dataiku.dip.server.controllers.ConnectionsController.adminTestSQL(ConnectionsController.java:517)	at com.dataiku.dip.server.controllers.ConnectionsController$$FastClassBySpringCGLIB$$149f32e4.invoke(<generated>)	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:701)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)	at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)	at com.dataiku.dip.server.controllers.CallTracingAspect.doCall(CallTracingAspect.java:78)	at jdk.internal.reflect.GeneratedMethodAccessor26.invoke(Unknown Source)	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)	at java.base/java.lang.reflect.Method.invoke(Method.java:566)	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:621)	at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:610)	at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:161)	at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:633)	at com.dataiku.dip.server.controllers.ConnectionsController$$EnhancerBySpringCGLIB$$f2bf219f.adminTestSQL(<generated>)	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)	at java.base/java.lang.reflect.Method.invoke(Method.java:566)	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:743)	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:672)	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:933)	at com.dataiku.dip.server.controllers.DKUDispatcherServlet.doDispatch(DKUDispatcherServlet.java:50)	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:867)	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:951)	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:853)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:827)	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)	at org.eclipse.jetty.servlet.ServletHolder$NotAsyncServlet.service(ServletHolder.java:1411)	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:763)	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1651)	at com.dataiku.dip.shaker.server.ResourceFilter.doFilter(ResourceFilter.java:33)	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1630)	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:567)	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602)	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1610)	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1377)	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:507)	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1580)	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1292)	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)	at org.eclipse.jetty.server.Server.handle(Server.java:501)	at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)	at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:556)	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273)	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)	at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)	at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)	at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375)	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806)	at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938)	at java.base/java.lang.Thread.run(Thread.java:829)Caused by: java.lang.ClassNotFoundException: zetaris.jar	at java.base/jdk.internal.loader.BuiltinClassLoader.loadClass(BuiltinClassLoader.java:581)	at java.base/jdk.internal.loader.ClassLoaders$AppClassLoader.loadClass(ClassLoaders.java:178)	at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:522)	at java.base/java.lang.Class.forName0(Native Method)	at java.base/java.lang.Class.forName(Class.java:315)	at com.dataiku.dip.connections.SQLDriverLoader.loadDriver(SQLDriverLoader.java:42)... 73 more
Setup Info
    Tags
      Help me…