Dominique Jean-Prost created NIFI-11043:
-------------------------------------------
Summary: 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
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)
