[jira] [Resolved] (NIFI-11043) Cannot use external jdbc driver using http url

["David Handermann (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/NIFI-11043?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

David Handermann resolved NIFI-11043.
-------------------------------------
    Fix Version/s: 1.21.0
       Resolution: Fixed

> Cannot use external jdbc driver using http url
> ----------------------------------------------
>
>                 Key: NIFI-11043
>                 URL: https://issues.apache.org/jira/browse/NIFI-11043
>             Project: Apache NiFi
>          Issue Type: Bug
>    Affects Versions: 1.19.1
>            Reporter: Dominique Jean-Prost
>            Priority: Major
>             Fix For: 1.21.0
>
>
> Hello,
> I'm trying to add a sql server jdbc driver in an execute SQL block. Documentation says I can use http url to "download" the driver.
> I can pass the validation of my configuration, but then I get an error telling the URI scheme is not {{file}}
>  
> Here is the error I get in logs.
> Is using http in driver location operational ?
> Thank you.
> {code:java}
> 2023-01-10 13:02:14,437 INFO [NiFi Web Server-88] o.a.n.controller.AbstractComponentNode Updating classpath for DBCPConnectionPool with the ID 95df9b89-0185-1000-a129-8a1076e45363
> 2023-01-10 13:02:14,441 ERROR [NiFi Web Server-88] org.apache.nifi.dbcp.DBCPConnectionPool DBCPConnectionPool[id=95df9b89-0185-1000-a129-8a1076e45363] Error reloading component with id 95df9b89-0185-1000-a129-8a1076e45363: URI scheme is not "file"
> java.lang.IllegalArgumentException: URI scheme is not "file"
>         at java.io.File.<init>(File.java:423)
>         at org.apache.nifi.util.file.classloader.ClassLoaderUtils.getLastModified(ClassLoaderUtils.java:160)
>         at org.apache.nifi.util.file.classloader.ClassLoaderUtils.lambda$generateAdditionalUrlsFingerprint$3(ClassLoaderUtils.java:150)
>         at java.util.ArrayList.forEach(ArrayList.java:1259)
>         at org.apache.nifi.util.file.classloader.ClassLoaderUtils.generateAdditionalUrlsFingerprint(ClassLoaderUtils.java:150)
>         at org.apache.nifi.controller.service.StandardControllerServiceNode.reload(StandardControllerServiceNode.java:219)
>         at org.apache.nifi.controller.AbstractComponentNode.setProperties(AbstractComponentNode.java:309)
>         at org.apache.nifi.controller.service.StandardControllerServiceNode.setProperties(StandardControllerServiceNode.java:227)
>         at org.apache.nifi.web.dao.impl.StandardControllerServiceDAO.configureControllerService(StandardControllerServiceDAO.java:377)
>         at org.apache.nifi.web.dao.impl.StandardControllerServiceDAO.updateControllerService(StandardControllerServiceDAO.java:170)
>         at org.apache.nifi.web.dao.impl.StandardControllerServiceDAO$$FastClassBySpringCGLIB$$6b77954.invoke(<generated>)
>         at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
>         at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
>         at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
>         at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89)
>         at org.apache.nifi.audit.ControllerServiceAuditor.updateControllerServiceAdvice(ControllerServiceAuditor.java:114)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:498)
>         at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:634)
>         at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:624)
>         at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:72)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175)
>         at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
>         at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97)
>         at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
>         at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
>         at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:708)
>         at org.apache.nifi.web.dao.impl.StandardControllerServiceDAO$$EnhancerBySpringCGLIB$$7eee7f7b.updateControllerService(<generated>)
>  {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)