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