有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

java连接NiFi到MS SQL server windows 10

我无法使用sql server连接nifi,请您帮助我了解以下错误

Error 
00:52:36 ISTERRORcf6cf1cb-0173-1000-1496-523d316e3cff
ExecuteSQL[id=cf6cf1cb-0173-1000-1496-523d316e3cff] ExecuteSQL[id=cf6cf1cb-0173-1000-1496-523d316e3cff] failed to process session due to Cannot invoke method public default java.sql.Connection org.apache.nifi.dbcp.DBCPService.getConnection(java.util.Map) throws org.apache.nifi.processor.exception.ProcessException on Controller Service with identifier cf674d7f-0173-1000-ce58-0312a249a0df because the Controller Service's State is currently ENABLING; Processor Administratively Yielded for 1 sec: org.apache.nifi.controller.service.ControllerServiceDisabledException: Cannot invoke method public default java.sql.Connection org.apache.nifi.dbcp.DBCPService.getConnection(java.util.Map) throws org.apache.nifi.processor.exception.ProcessException on Controller Service with identifier cf674d7f-0173-1000-ce58-0312a249a0df because the Controller Service's State is currently ENABLING

数据库连接URL:jdbc:sqlserver://localhost;databaseName=DB_NAME;integratedSecurity=true 数据库驱动程序类名com。微软sqlserver。jdbc。SQLServerDriver 数据库驱动程序位置file:///C:/Users/user_name/sqljdbc_8.4/enu/mssql-jdbc-8.4.0。jre8。jar

enter image description here


共 (1) 个答案

  1. # 1 楼答案

    控制器服务的状态为“启用”,这意味着该服务尚不可用。刷新UI,当该服务可用时,可以启动依赖该服务的处理器