We are using NiFi to connect to MS SQL Server and have had success with both 
Sqljdbc41.jar and Sqljdbc42.jar.

-----Original Message-----
From: Bryan Bende [mailto:bbe...@gmail.com] 
Sent: Monday, September 19, 2016 9:12 AM
To: dev@nifi.apache.org
Subject: Re: NIFI java.lang.UnsupportedOperationException


I'm not totally sure, but it seems like that error is saying that you are 
running Java 8, and the sqljdbc4.jar is not compatible with Java 8.

From reading the system requirements when downloading the SQL Server's JDBC 
Driver, it says:

   Version support for Java Runtime Environments (JRE) and the associated
   JDBC API versions are determined by the included JAR files as follows:
   • Sqljdbc.jar requires a JRE of 5 and supports the JDBC 3.0 API
   • Sqljdbc4.jar requires a JRE of 6 and supports the JDBC 4.0 API
   • Sqljdbc41.jar requires a JRE of 7 and supports the JDBC 4.1 API
   • Sqljdbc42.jar requires a JRE of 8 and supports the JDBC 4.2 API

I wonder if the sqljdbc42.jar would work.


On Mon, Sep 19, 2016 at 9:26 AM, HadyZiade <hadyzi...@gmail.com> wrote:

> I Am running NIFI under windows .
> trying to connect to sql server and i got the following error
> java.lang.UnsupportedOperationException: Java Runtime Environment
> Version1.8
> is not supported by this driver. Use the sqljdbc4.jar class library, 
> which provides support to JDBC 4.0: java.lang.Unsuppo......
> my configuration for DBCPConnection pool (that is working for another 
> Linux
> installation)
> Database Connection Url:
> jdbc:sqlserver://NEX-ETL-42;databaseName=etl_catalog
> Database Driver Class Name: 
> com.microsoft.sqlserver.jdbc.SQLServerDriver
> Database Driver Location(s) : /enu/sqljdbc4.jar
> for the driver location i tried   C:\enu\sqljdbc4.jar
> i tried file:///C:\enu\sqljdbc4.jar
> i tried the default path when the sqljdbc4.jar is initially installed 
> ......
> nothing is working
> i get same issue when i run PUTSQL
> --
> View this message in context: http://apache-nifi-developer-
> list.39713.n7.nabble.com/NIFI-java-lang-UnsupportedOperationException-
> tp13392.html
> Sent from the Apache NiFi Developer List mailing list archive at 
> Nabble.com.

Reply via email to